Top 16 sql-builder Open-Source Projects

• GRDB.swift

  37 6,527 9.3 Swift

  A toolkit for SQLite databases, with a focus on application development

Project mention: Bundling database with iOS app | /r/iOSProgramming | 2023-10-24

I'm using GRDB , you can use existing pre-populated sqlite DB file. https://github.com/groue/GRDB.swift/wiki/Performance .

• jOOQ

  94 5,896 9.8 Java

  jOOQ is the best way to write SQL in Java

  

Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

> 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/

• InfluxDB

  www.influxdata.com featured

  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.

  

• goqu

  23 2,245 5.6 Go

  SQL builder and query library for golang

Project mention: newbie here looking for a framework | /r/golang | 2023-10-03

For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/

• jet

  27 2,076 8.1 Go

  Type safe SQL builder with code generation and automatic query result data mapping

Project mention: Use Rails | news.ycombinator.com | 2024-05-07

"I can make a JS or Go program perform the same way. In fact the exact same thing happened in my shop with Go/Gorm. The key question is: how do you compute the 5mb of JSON? The devil is in those details. We changed the way we computed ours, and the issue was gone."

The problem is ActiveRecord in my case. The data layout is not great (lots of joins through relationships, I thik 12 tables or so). What do you use (except raw sql) in Ruby if you cannot use ActiveRecord? I actually reimplemented the same API endpoint in Go using https://github.com/go-jet/jet and measured 10MB of allocations and essentially zero overhead over queries itself, a 50x speedup.

• go-sqlbuilder

  1 1,202 7.0 Go

  A flexible and powerful SQL string builder library plus a zero-config ORM.

Project mention: Best sqlc alternative for dynamic queries? | /r/golang | 2023-05-15

Here are 2 options for you * https://github.com/huandu/go-sqlbuilder * https://github.com/Masterminds/squirrel

• sql-parser

  3 425 9.2 PHP

  A validating SQL lexer and parser with a focus on MySQL dialect. (by phpmyadmin)

  

• DbExtensions

  0 223 0.0 C#

  Data-access framework with a strong focus on query composition, granularity and code aesthetics.

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• workers-qb

  1 215 7.2 TypeScript

  Zero dependencies Query Builder for Cloudflare Workers

• NReco.Data

  1 182 4.3 C#

  Fast DB-independent DAL for .NET Core: abstract queries, SQL commands builder, schema-less data access, POCO mapping (micro-ORM). (by nreco)

  

• go-sql

  0 176 0.0 Go

  golang orm and sql builder (by rushteam)

  

• sqlf

  0 140 2.0 Go

  Fast SQL query builder for Go (by leporo)

• ElSql

  1 100 1.2 Java

  Manage external SQL files in Java with a little DSL goodness

  

• builq

  2 89 6.9 Go

  Easily build SQL queries in Go.

  

• Dapper.SimpleSqlBuilder

  1 40 6.5 C#

  A simple SQL builder for Dapper using string interpolation and fluent API for building safe static and dynamic SQL queries.

• superbasic

  2 39 3.0 Go

  The superbasic SQL-Builder.

• goqux

  1 16 6.7 Go

  Library for simple CRUD, scanning & pagination using query builder in golang

Project mention: GoquX: Simplify CRUD Queries and Pagination | /r/golang | 2023-06-11

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

sql-builder related posts

• Bundling database with iOS app

  1 project | /r/iOSProgramming | 24 Oct 2023

• How can I quickly parse a huge 45MB JSON file using JsonDecoder

  2 projects | /r/swift | 19 Jun 2023

• When considering how to store data for something like a cooking recipe application, what are the disadvantages of using CoreData, when compared with other database options?

  1 project | /r/swift | 16 May 2023

• The most amazing project documentation you saw

  2 projects | /r/swift | 12 Mar 2023

• Struggles with Logic & CoreData

  1 project | /r/SwiftUI | 25 Feb 2023

• Database/permanent data storing solution for iOS

  1 project | /r/iOSProgramming | 22 Feb 2023

• GRDB-ORM, an ORM for GRDB - Swift SQLite

  2 projects | /r/swift | 18 Jan 2023
• A note from our sponsor - SaaSHub
  www.saashub.com | 10 May 2024

  SaaSHub helps you find the best software and product alternatives Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com