Top 22 sql-query Open-Source Projects
-
SqlKata Query Builder
SQL query builder, written in c#, helps you build complex queries easily, supports SqlServer, MySql, PostgreSql, Oracle, Sqlite and Firebird
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
AdvancedSQLPuzzles
Welcome to my GitHub repository. I hope you enjoy solving these puzzles as much as I have enjoyed creating them.
-
SQL-interview-questions
List of Top 500 SQL Interview Questions & Answers with queries and more (by kansiris)
-
sql-template-tag
ES2015 tagged template string for preparing SQL statements, works with `pg`, `mysql`, and `sqlite`
-
mql
MQL tool is designed to generate SQL queries directly from natural language inputs. (by shurutech)
-
Dapper.SimpleSqlBuilder
A simple SQL builder for Dapper using string interpolation and fluent API for building safe static and dynamic SQL queries.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
> 2. ORMs do not hide SQL nastiness.
This is certainly true!
I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".
I think the are of ORMs is over. It simply did not deliver.
If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.
I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.
There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)
https://www.jooq.org/
https://hasura.io/
Project mention: Understanding TTFB Latency in DJango - Seems absurdly slow after DB optimizations even locally | /r/django | 2023-12-08GraphQL could be efficiently translated into SQL and things certainly try, but the only thing close to a "bulletproof" implementation I found was Join Monster (https://github.com/join-monster/join-monster) in NodeJS-land and even that I think is now mostly abandoned. GraphQL as a system was built assuming random-access to data stores is ~free because that's what Facebook has, but the rest of us don't :)
For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/
Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.
https://github.com/go-jet/jet
Please file an issue at https://github.com/jupyter-incubator/sparkmagic
This is the best measure I've found:
https://madnight.github.io/githut/#/pushes/2023/4
Unfortunately it doesn't have new projects, but it does seem like C++ peaked a couple of years ago and is starting to trend down. "Plummeting" is clearly an exaggeration though.
Try advancedsqlpuzzles.com
Project mention: Hi Guys! I am completely new to database and trying to switch from Civil Engineering background to IT sector. I want to get entry level job in database. I have learned the basics of MySQL. Now how do I prepare for interview? | /r/SQL | 2023-06-22Here’s a list of 500 SQL interview questions https://github.com/kansiris/SQL-interview-questions
You can avoid this entirely with JavaScript's tagged template literals. Here is an example library: https://github.com/blakeembrey/sql-template-tag
Project mention: MQL – Client and Server to query your DB in natural language | news.ycombinator.com | 2024-04-07
Project mention: Don't use your ORM entities for everything – embrace the SQL | news.ycombinator.com | 2024-03-29I guess I failed to set the context correctly given that you presented solutions for Clojure and Python, where it isn't as much of a problem since from the start the language fails to provide compiler guarantees you usually come to expect out of a SQL driver wrapper in typed languages (even though Clojure macros are probably powerful enough to allow this).
As a comparison, DX-wise this is no safer and is indeed very similar to the usual idiom in Go for example, where you just concatenate (pre-interpolated) SQL strings. But when you actually want the compiler to prove the correctness of your queries even in a rudimentary way, these .sql file solutions usually (if not, everytime) fail to provide the necessary external checker that processes templates and uses an accurate model of your database and SQL to verify that all used combinations make sense.
The closest thing to a proper take on this I've seen is https://github.com/andywer/squid with https://github.com/andywer/postguard which, although the SQL is inlined in the code, it uses the right approach for verifying correctness as far as I could tell in the little time I experimented with it.
sql-query related posts
Index
What are some of the best open-source sql-query projects? This list will help you:
Project | Stars | |
---|---|---|
1 | jOOQ | 5,882 |
2 | SqlKata Query Builder | 2,997 |
3 | join-monster | 2,652 |
4 | goqu | 2,232 |
5 | jet | 2,025 |
6 | sparkmagic | 1,284 |
7 | githut | 935 |
8 | AdvancedSQLPuzzles | 485 |
9 | sql-parser | 423 |
10 | SQL-interview-questions | 415 |
11 | sql-template-tag | 312 |
12 | tableQA | 284 |
13 | mql | 147 |
14 | squid | 130 |
15 | ship-hold | 113 |
16 | Dapper.SimpleSqlBuilder | 39 |
17 | lib12 | 37 |
18 | qhs | 33 |
19 | chadbaldwin.github.io | 26 |
20 | sql-sidekick | 17 |
21 | sql-examples | 11 |
22 | scommons-websql | 1 |
Sponsored