Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
Voxera6409226dWell SQL is the most versatile database. Others excel in specific situations but often you find you need to use multiple different databases for different parts of information or resort to very cumbersome solutions.
dangerzone343226dName a better database language than SQL. Go ahead, I'll wait.
DataJockey1270226dBe thankful you can use SQL. Our main solution runs on isam files powered by Cobol dlls.
Npstr725226dThe two main problems with SQL are that it is the only really wide spread 4th generation language, meaning it is hard to learn it from doing non-SQL because there is no other language like it, and it doesn't play well with the rest of the lower generation languages. Also often ppl will try to translate the relational model of their data into an object oriented one, and that just does not work very well.
Voxera6409225d@Npstr well. Microsoft has moved the same syntax into C# with Linq.
First time I saw it I thought why?
Today I use it so much that you often cannot find a function without at least some linq in it.
var activeIssueIds =
from i in issues
Its a very simple example but issues in this case could be an Orm table, a list or any number of item implementing the right interfaces.
Its extremely powerful and expressive :)
There is a fluent form to for this kind of simple queries.
Npstr725225d@Voxera I've heard only good things about LINQ.
Personally, since I hail from the Java world, I'm giving jOOQ a try currently and so far it's awesome.
It generates code from the database schema which is then used to build the queries. No more sql strings. This gives you great peace of mind when migrating the database schema as you will get (most of the time) compile time errors if you made a change that breaks a query.
Voxera6409224d@Npstr that sounds a lot like it.
The real beauty with linq thou is that its not only database but any enumerable that can he queried the same way:)
And as a bonus, you can turn the query into an expression tree that you can use to dissect the query, for example to serialize it or make changes.
It tends to pop in everywhere. :)
Your Job Suck?
Take a quick quiz from Triplebyte to skip the job search hassles and jump to final interviews at hot tech firms
Get a Better Job