-
Posts
102 -
Joined
-
Last visited
Reputation Activity
-
LegionOfOne got a reaction from Merkey in SQL vs MySQL - any difference?
SQL (called sequel) [Yes this is JUST the language but in discussions is commonplace to interchange this for MS-SQL or SQL Server] was created and is generally considered Microsoft's proprietary server. MySQL (called My Sequel) is just another type of server that is open sourced. They effectively use the same structured query language (lol -> SQL get it ). Generaly speaking MySQLi and postgresSQL are iterations that simply expand on the feature set that is native to MySQL. The basics are the same but its the nuance between them that lends to the "differences".
Hope that helps!
-Luke
-
LegionOfOne got a reaction from IAmAndre in SQL vs MySQL - any difference?
SQL (called sequel) [Yes this is JUST the language but in discussions is commonplace to interchange this for MS-SQL or SQL Server] was created and is generally considered Microsoft's proprietary server. MySQL (called My Sequel) is just another type of server that is open sourced. They effectively use the same structured query language (lol -> SQL get it ). Generaly speaking MySQLi and postgresSQL are iterations that simply expand on the feature set that is native to MySQL. The basics are the same but its the nuance between them that lends to the "differences".
Hope that helps!
-Luke
-
LegionOfOne got a reaction from done12many2 in Unigine Valley Benchmark Scores Thread + SUPERPOSITION ***Over 1000 Submissions!***
For the science of the numbers my CPU is ocd at 4.3
-
LegionOfOne got a reaction from rogueone in Hardware Monitor
This depends IMO, based on your question, my gold standard for stats monitoring for testing is Aida64. That has everything you need in a nice little lightweight package.
If you want to monitor like FPS and some temps get PrecisionX and get familar with the OSD portion of the app. You can use anything anyone above suggested however, all great apps. :-)
-
LegionOfOne reacted to SansVarnic in What would happen if you plugged a UPS into itself...
Cant put my finger on it but something is not quite right about this sentence ... hmm
-
LegionOfOne got a reaction from minibois in What would happen if you plugged a UPS into itself...
You would loose energy through heat until the battery died.
-
LegionOfOne got a reaction from Sujalama in Ethernet no IP configuration
Try leaving your dns to auto and try it again. After you set it up and apply disable and re-enable the NIC. setting 8.8.8.8 and 8.8.4.4 sets your dns to googles DNS servers. The DNS is essentially what allows your computer to translate domain names into IP address destinations.
-
LegionOfOne got a reaction from Joveice in Chrome exstension to change css property after load
https://chrome.google.com/webstore/detail/user-css/okpjlejfhacmgjkmknjhadmkdbcldfcb?utm_source=chrome-app-launcher-info-dialog
I use this one. Dead simple css style sheet makes the sites i hate more useable haha
-
LegionOfOne reacted to madknight3 in Need help finding the error in this SQL statement
It's hard to know exactly what's wrong without seeing your data. The best way to know for sure is for you to post some test data and the correct order you want the data to be displayed. I'll give a couple guesses below though.
It could be that what you really want is to ORDER BY SenderID and not UserID. Example.
Given this data SenderID, Subject, UserID ------------------------- 1, "Subject 1", Scott 2, "Subject 2", Admin 3, "Subject 3", Betty Using ORDER BY UserID will sort it like this 2, "Subject 2", Admin 3, "Subject 3", Betty 1, "Subject 1", Scott Since you aren't selecting UserID it could be that it just looks out of order. 2, "Subject 2" 3, "Subject 3" 1, "Subject 1" Using ORDER BY SenderID will return this 1, "Subject 1", Scott 2, "Subject 2", Admin 3, "Subject 3", Betty Or it could be that because you're using a string and not a number for your UserID column, it's sorting lexicographically and it's not doing what you want. Example.
Say you have this data UserId ------ Admin1 Admin2 Admin100 You might think "ORDER BY UserID" will result in the above order. However, it will actually result in this order. Admin1 Admin100 Admin2 Because the database doesn't look at the numbers at the end of the UserID as an integer.
-
LegionOfOne got a reaction from Factory OC in Keyboard randomly changes to US instead of UK or Swedish. HELP!
Search for "Change keyboards or other input methods" open the Keyboards and Languages then click "Change Keyboards..." You can remove the extra keyboards configs in there so there are no other profiles. Alternatively click the "Advanced Key Settings" Tab and change your setting under the Between input languages catagory.
Best of luck,
-Luke
-
LegionOfOne got a reaction from Dat Guy in Best language for a begginer?
Ha! On the brackets thing, god yes haha. That is my least favorite part about py. This is why I love chatting with programmers there is almost always a sense of humor about it as almost everything is more opinionated haha. I have to agree with you in that once you understand a languages real purpose and the methodology that governs its usage they are really mostly the same and easy to some degree or another, what really differentiates each one really does become the actually perks/flaws of the language itself. Very valid point :-)
-
LegionOfOne reacted to Dat Guy in Best language for a begginer?
Your perception of the semantical easyness of a language entirely depends on your ability to pick up certain patterns, not on the language. Absurd but true example: If your first language was APL, you'll be fluent in APL.
True.
I (mostly) hate to teach, depending on who asks me to. But I randomly help people around me to get started with programming. We usually agree on Perl though.
edit for clarification: I feel comfortable in a number of languages, but I found C to be a pretty good all-round language which is nice to work with. Of course there are things I'd rather write in other languages.
Which language does not kinda read like English? In fact, you're actually arguing for COBOL now ...
Of course that's a matter of preference. IMO it mostly lacks brackets, a good compiler and adequate performance.
-
LegionOfOne got a reaction from Dat Guy in Best language for a begginer?
While I am unfamiliar with all the languages you personally know I would very much disagree that all the languages that I know are semantically easy, that is to say that some languages are conceptually harder for a newer programmer to get into. Then again either way think we can agree that it really is more of a opinionated stance based on preference. Me? I LOVE to teach, code in, and simply be around JavaScript. Based on your signature I would perhaps assume you feel similar about C. My point is that python, like vb, kinda reads like English and in my humble opinion python isn't a bad suggestion. I think we agree it's perhaps not the best, but I defend that doesn't make it bad either.
-
LegionOfOne got a reaction from justcuz2345 in stress test
Are you testing out an overclock? I assume so, you could if you chose disconnect the internet for running overnight to reduce some risk in that way. Otherwise a few hours monitored through the day should be fine.
Best of luck and happy tuning!
-
-
LegionOfOne got a reaction from Factory OC in Opening .accdb files without MS Access?
Microsoft EXCEL and i think open office should be able to handle that task for you in the future.
-
LegionOfOne got a reaction from IAmAndre in Autocomplete plugin for Chrome
Hahaha this would need an "incognito mode" to be sure haha. That being said if one doesn't exists you could create one.
Looks like this is what your looking for
https://chrome.google.com/webstore/detail/predictive-tab-key-auto-c/jdoppinocmncfoogncheajbjeipceeok?hl=en
I have never used it so this is not me endorsing it in any way just trying to get a complete answer your way. Careful exposing yourself to stuff like this though, this is essentially installing a key logger to an effect which can of course be less than ideal...
Best of luck