Jump to content

IncrediblePony

Member
  • Posts

    47
  • Joined

  • Last visited

Reputation Activity

  1. Like
    IncrediblePony got a reaction from Biohazard777 in GoXLR users/owners and Linux folk - REJOICE! It works and it works quite well!   
    I've used this utility to manage my GoXLR and audio settings with the PulseAudio Volume Control software. And it works like a charm! There's still a few kinks here and there but these are set to be fixed down the line. The quote below is taken from their roadmap. Be sure to star the repo and tell them thanks!
     
    I'm using Pop!_OS 22.04 🙂 All I did was make sure that the GoXLR daemon is running at startup and BOOM! Now your beautiful piece of hardware just works ^_^ GLHF!
     
    https://github.com/GoXLR-on-Linux/goxlr-utility
  2. Like
    IncrediblePony got a reaction from jejones3141 in GoXLR users/owners and Linux folk - REJOICE! It works and it works quite well!   
    I've used this utility to manage my GoXLR and audio settings with the PulseAudio Volume Control software. And it works like a charm! There's still a few kinks here and there but these are set to be fixed down the line. The quote below is taken from their roadmap. Be sure to star the repo and tell them thanks!
     
    I'm using Pop!_OS 22.04 🙂 All I did was make sure that the GoXLR daemon is running at startup and BOOM! Now your beautiful piece of hardware just works ^_^ GLHF!
     
    https://github.com/GoXLR-on-Linux/goxlr-utility
  3. Like
  4. Like
    IncrediblePony got a reaction from WereCat in GoXLR users/owners and Linux folk - REJOICE! It works and it works quite well!   
    I've used this utility to manage my GoXLR and audio settings with the PulseAudio Volume Control software. And it works like a charm! There's still a few kinks here and there but these are set to be fixed down the line. The quote below is taken from their roadmap. Be sure to star the repo and tell them thanks!
     
    I'm using Pop!_OS 22.04 🙂 All I did was make sure that the GoXLR daemon is running at startup and BOOM! Now your beautiful piece of hardware just works ^_^ GLHF!
     
    https://github.com/GoXLR-on-Linux/goxlr-utility
  5. Like
    IncrediblePony got a reaction from Radium_Angel in GoXLR users/owners and Linux folk - REJOICE! It works and it works quite well!   
    I've used this utility to manage my GoXLR and audio settings with the PulseAudio Volume Control software. And it works like a charm! There's still a few kinks here and there but these are set to be fixed down the line. The quote below is taken from their roadmap. Be sure to star the repo and tell them thanks!
     
    I'm using Pop!_OS 22.04 🙂 All I did was make sure that the GoXLR daemon is running at startup and BOOM! Now your beautiful piece of hardware just works ^_^ GLHF!
     
    https://github.com/GoXLR-on-Linux/goxlr-utility
  6. Like
    IncrediblePony reacted to N!GHTFoX79 in MSI Optix MAG271C Monitor blurry icons and text   
    Hi, I just registered so I can reply to your Post.
    I have MSI OPTIX AG32CQ and under settings when you just disable "FreeSync: OFF" the Text is smooth, so this worked for me.
    Thank you.
  7. Agree
    IncrediblePony reacted to Kilrah in Builds for developer/gamers - are we overlooked in vids?   
    No idea. But as long as your build system can use multiple threads, which they all should then it should be pretty similar. Easy to see by looking at CPU usage on your current system.
  8. Informative
    IncrediblePony reacted to Fatih19 in Builds for developer/gamers - are we overlooked in vids?   
    Have you checked Phoronix review? IIRC they have compile test for their CPU review.
  9. Informative
    IncrediblePony reacted to Kilrah in Builds for developer/gamers - are we overlooked in vids?   
    From the C projects I'm working on it's pretty simple, faster is always better...
     
    As good a single thread performance as possible is best as there are always some single thread processes that need to be run at some points in the build that everything else has to wait for, but when it's compiling actual source files it will do one per thread and max out whatever you have. 
    So the more individual files to compile the better a large number of cores will be made use of.
  10. Like
    IncrediblePony got a reaction from boggy77 in DAN A4-SFX v4.1 Weightloss goal PC   
    huh - neat didn't think I could pull a 3700x in a system like this without smahsing thermal throttles
    The 2070 Super mini looks so freaking cool! I love it!
  11. Informative
    IncrediblePony reacted to boggy77 in DAN A4-SFX v4.1 Weightloss goal PC   
    made some tweaks. samsung drives are expensive.
    PCPartPicker Part List Type Item Price CPU AMD Ryzen 7 3700X 3.6 GHz 8-Core Processor 2880.88kr @ Newegg Denmark CPU Cooler Noctua NH-L9i chromax.black 33.84 CFM CPU Cooler 471.00kr @ Alternate Thermal Compound Thermal Grizzly Kryonaut 1g 1 g Thermal Paste   Motherboard Gigabyte X570 I AORUS PRO WIFI Mini ITX AM4 Motherboard 2196.00kr @ CDON DK Memory Corsair Vengeance LPX 32 GB (2 x 16 GB) DDR4-3200 Memory 1420.00kr @ Alternate Storage ADATA XPG SX8200 Pro 2 TB M.2-2280 NVME Solid State Drive 2533.00kr @ Alternate Video Card Zotac GeForce RTX 2070 SUPER 8 GB MINI Video Card 4542.00kr @ Alternate Case DAN Cases A4-SFXv4 Mini ITX Desktop Case   Power Supply Corsair SF 600 W 80+ Platinum Certified Fully Modular SFX Power Supply     Prices include shipping, taxes, rebates, and discounts     Total 14042.88kr   Generated by PCPartPicker 2020-04-15 14:10 CEST+0200    
  12. Agree
    IncrediblePony reacted to Phoenix125 in MSI Optix MAG271C Monitor blurry icons and text   
    I just got the monitor and having same issue with text clarity.  Did you find a solution yet?  Thanks!

    Edit: The issue for me was FreeSync. I am using an nVidia GTX-1070 with FreeSync support via drivers.  Once I disabled it, everything looks normal.  Here are the other recommended settings:
    Please refer manual on page 2-5 ~ 2-8 for checking some setting value first.
    Game Mode: User
    Response tome: Normal
    Anti motion blur: OFF
    FreeSync: OFF
    Pro Mode: User
    Eye Saver: OFF
    HDCR: OFF
  13. Informative
    IncrediblePony reacted to wasab in MySQL join sequence confusion   
    Join is a Cartesian product of two relations  minus their duplicated shared attributes. You can use a nested queries to retrieve the Cartesian products of the tupples relevant to your queries and then do use the select operator to narrow down the attributes you desire in your relations. If you use the natural join, you no longer have to specify which foreign keys should be equivalent because natural join automatically does that for you. 
  14. Agree
    IncrediblePony reacted to Franck in MySQL join sequence confusion   
    Don't add the condition filter on the LEFT join. This cause to match the records AND apply the filter at the same time. Put a standard WHERE instead which will prefilter the records and cut a ton load of iterations.
     
    so the last line instead of 
    ) AS ex ON p.project_id = ex.project_id AND p.project_name NOT LIKE 'K - %'; do this
    ) AS ex ON p.project_id = ex.project_id WHERE p.project_name NOT LIKE 'K - %';  
  15. Informative
    IncrediblePony reacted to Franck in MySQL join sequence confusion   
    You can technically cheat by summing values per records of the second query
     
    SELECT i.issue_id, i.internal_note, (SELECT TOP 1 SUM(seconds_elapsed) FROM intervals WHERE intervals.issue_id = i.issue_id) as 'Total Elapsed Seconds' FROM issues i JOIN projects p ON i.project_id = p.project_id WHERE project_name NOT LIKE "K - %" AND i.internal_note NOT LIKE "%SKIF%" If you look this simply added a column that is the result of a select on the third table based on the current iteration of the main query. I don't have a MySQL ready on hand right now it's my day off but that would be a simple quick and dirty version to grab more of the data you need.
     
    But overall you wouldn't want that query as your final result. that's not what your output is based on, What you result show is you want a list of project first, then sums of other data so it should be more like :
     
    SELECT projects.project_id, projects.hourly_rate, ( SELECT SUM(seconds_elapsed) FROM intervals LEFT JOIN issues ON intervals.issue_id = issues.issue_id WHERE issues.internal_note NOT LIKE '%SKIF%' AND issues.project_id = projects.project_id ) as 'elapsed_seconds' FROM projects WHERE projects.project_name NOT LIKE 'K - %'  Not 100% it runs, again i don't have access to SQL right now. But the logic is good or at least very close.
  16. Informative
    IncrediblePony got a reaction from GOLD1176 in Is it a good idea for a beginner programmer to learn two languages at once?   
    As so many already has told you, it's really not the language, but your reasoning/problem solving skills that you develop here. Your first programming language should be one that's used widely and has loads of support on forums and documentation. I would start on something like JAVA or C# because these languages are Object Oriented and Strongly Typed.
     
    When you have grasped the core concepts of one of these languages I would recommend starting on a Weakly Typed language like Python or JavaScript to see the differences. Link to article about this subject. Loads more info on a simple google search.
     
    So in short - I would recommend learning one language first and then branching out. A good site for learning code for free is CodeCademy
  17. Agree
    IncrediblePony reacted to iLostMyXbox21 in Is it a good idea for a beginner programmer to learn two languages at once?   
    I know, those were just examples
  18. Informative
    IncrediblePony reacted to Techicolors in would like to learn   
    Codeacademy is a nice place to start. but programming is a huge field, what do you like to do? i assume game development
  19. Informative
    IncrediblePony reacted to prysm in SQL vs MySQL - any difference?   
    SQL is a standard language for relational database management system (RDBMS).
     
    MySQL is an open source RDBMS with its own dialect of the language controlled by Oracle.
    PostgreSQL is an open source RDBMS with its own dialect of the language.
    Sql Server is Microsoft's RDBMS and using the T-SQL proprietary dialect of SQL.
     
    SQLite has a SQL dialect but it is flat file based. I think its useful for development or a program that needs a local, light weight database; however, it wouldn't be useful for concurrent users.

    When you get started, download a sample database. Sql Server has Adventure Works sample database.
     
    When developing you want to use the standard SQL as much as possible. Don't pull out the nifty features out of that particular implementation unless you have to. It makes your code and knowledge more transferable.
  20. Informative
    IncrediblePony reacted to mariushm in SQL vs MySQL - any difference?   
    Traditionally, they are database servers ( a standalone application that runs like a web server), and on Windows it usually runs as a Windows service.
    Your application connects to the database server through network connection or pipes or whatever and sends a command in the SQL language and the server software replies with the result of the command.
    For example your application says "USE databasename; SELECT * from databasename.tablename WHERE tablename.age=15;" and the database server software processes the query and knows that it has to open the database called "databasename" , then look up in the table "tablename" from that database and return all the columns (because I used * which means all columns)  in the rows that have a value 15 in the column called "age"
    The database server software takes care of how data is stored physically on the disk and maintain the relationship between tables of a database based on specific constrains you may set - most database systems use one file for each table and the definition of the database (names of each table , the columns and data types of each column in a table) are either saved as a separate file or files in a folder somewhere on disk, or they're actually stored in a "special" database.
    Your application only needs to be aware of the SQL language and maybe some differences between various database servers (for example MS SQL may use some keywords while MySQL may use another keyword to do the same thing) anbd doesn't have to worry about where the data is actually saved, updated, inserted into tables. .. the database software takes care of that.
     
    SQLite is a sort of special cornflake .. all the "database management and stuff" is packed into a single DLL file that can be loaded by your application so your application doesn't have to install a separate database server, doesn't have to connect to everything.  The databases are also cleverly stored into single files and data is appended to those files when needed, instead of having multiple files for each table, separate files for the definition of the database and so on.
    Basically your application just loads the library and says "use database stored in file x.sqlite" , then calls a function where you simply pass a SQL string like "select * from tablename where x=something and y=somethingelse" and the function returns the results.
     
     
  21. Informative
    IncrediblePony reacted to mariushm in SQL vs MySQL - any difference?   
    SQL is short for structured query language.
    You have MS SQL made by Microsoft, MySQL (the commercial version owned by oracle or MariaDB which is the open source MySQL) , Postgress SQL, SQLite , Oracle databases etc each has some benefits and some downsides / tradeoffs.
     
    SQLite is a lightweight SQL database system which stores everything required to access and query a  database in a single file, so it's great for tiny applications, no need to install separate sql server, very portable etc. For reference, it's used by Firefox to store last accessed urls, bookmarks and so on.
    MS SQL is good but if you want to do something commercial you have to pay money to microsoft, licenses etc
    MySQL/MariaDB is good, but the often used MyISAM tables trade off reliability  for speed (not transactional, but have fast full text search, stuff like that), the innodb format tables solve that but they're tiny bit slower
    Postgress SQL is the more serious  brother of mysql, fully transactional, has a better reputation but it's a bit slower than mysql
     
    and so on..
     
    mysqli is a sort of different way to talk to the mysql server , with support for more modern things that weren't as easy to work with plain mysql way
     
  22. Like
    IncrediblePony reacted to grss1982 in Build Log - My kinda old/kinda new machine [Please review]   
    The HardwareCanucks video below might give you an idea on performance:
     
    https://www.bing.com/videos/search?q=2600k 1080 ti canucks&qs=n&form=QBVR&sp=-1&pq=2600k 1080 ti ca&sc=0-16&sk=&cvid=868DD3D80613441FA69C35B287FB07B4
  23. Like
    IncrediblePony got a reaction from MandoPanda in Build Log - My kinda old/kinda new machine [Please review]   
    Wonderful  Thx for your help and patience  
     
    I might wait for a bit though, I have my eye set on either a desk pc build or a tiny case build just for the thrill of it
  24. Agree
    IncrediblePony got a reaction from Ebel Student in Web Development   
    Frameworks are pre-prepared pieces of code, most are written in the language you are using. In your case CSS. So the Bootstrap CSS Framework is CSS that is written for you. The point being that all the things Bootstrap does for you, you can do yourself by writing your own CSS.
     
    The reason people say that you should learn "vanilla" CSS3 first is because, when you implement Bootstrap on your site, then you don't really know the inner workings of bootstrap and therefore, when something does not behave the way you expect it to, you cannot fix it yourself, because you have no idea where it goes wrong.
  25. Agree
    IncrediblePony got a reaction from TopHatProductions115 in simple .php assignment   
    Damn you guys are being hard on this guy/gal...
    @smiles rising - I hope the code provided by @homeap5 helped you. The highlighted version of the code is here (also testing out my skills with the forum text editor at this point):
     

    if (strtolower($_POST["uid"])=="admin" and $_POST["pwd"]=="kanelbulle"){     // code when you're entering good login and password } else {     // code when you're not entering good login and password }
     
    If there is anything about this, let's be honest, relatively, simple if statement, let me and @TopHatProductions115 know. We may be able to give a detailed answer to why some things work as they do
×