sqrl alternatives and similar packages
Based on the "Database" category.
Alternatively, view sqrl alternatives based on common mentions on social networks and blogs.
-
tidb
TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial -
groupcache
groupcache is a caching and cache-filling library, intended as a replacement for memcached in many cases. -
TinyGo
Go compiler for small places. Microcontrollers, WebAssembly (WASM/WASI), and command-line tools. Based on LLVM. -
bytebase
The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams. -
go-cache
An in-memory key:value store/cache (similar to Memcached) library for Go, suitable for single-machine applications. -
immudb
immudb - immutable database based on zero trust, SQL/Key-Value/Document model, tamperproof, data change history -
buntdb
BuntDB is an embeddable, in-memory key/value database for Go with custom indexing and geospatial support -
pREST
PostgreSQL ➕ REST, low-code, simplify and accelerate development, ⚡ instant, realtime, high-performance on any Postgres application, existing or new -
xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server -
nutsdb
A simple, fast, embeddable, persistent key/value store written in pure Go. It supports fully serializable transactions and many data structures such as list, set, sorted set. -
gocraft/dbr (database records)
Additions to Go's database/sql for super fast performance and convenience. -
lotusdb
Most advanced key-value database written in Go, extremely fast, compatible with LSM tree and B+ tree.
WorkOS - The modern identity platform for B2B SaaS
Do you think we are missing an alternative of sqrl or a related project?
Popular Comparisons
README
sqrl - fat-free version of squirrel - fluent SQL generator for Go
Non thread safe fork of squirrel. The same handy fluffy helper, but with extra letters removed :)
import "github.com/elgris/sqrl"
Requires Go 1.8 and higher
Inspired by
Why to make good squirrel lighter?
Ask benchmarks about that ;). Squirrel is good, reliable and thread-safe with it's immutable query builder. Although immutability is nice, it's resource consuming and sometimes redundant. As authors of dbr
say: "100% of our application code was written without the need for this".
Why not to use dbr then?
Although, dbr
's query builder is proven to be much faster than squirrel and even faster than sqrl, it doesn't have all syntax sugar. Especially I miss support of JOINs, subqueries and aliases.
Usage
sqrl is not an ORM., it helps you build SQL queries from composable parts. sqrl is non thread safe. SQL builders change their state, so using the same builder in parallel is dangerous.
It's very easy to switch between original squirrel and sqrl, because there is no change in interface:
import sq "github.com/elgris/sqrl" // you can easily use github.com/lann/squirrel here
users := sq.Select("*").From("users").Join("emails USING (email_id)")
active := users.Where(sq.Eq{"deleted_at": nil})
sql, args, err := active.ToSql()
sql == "SELECT * FROM users JOIN emails USING (email_id) WHERE deleted_at IS NULL"
sql, args, err := sq.
Insert("users").Columns("name", "age").
Values("moe", 13).Values("larry", sq.Expr("? + 5", 12)).
ToSql()
sql == "INSERT INTO users (name,age) VALUES (?,?),(?,? + 5)"
Like squirrel, sqrl can execute queries directly:
stooges := users.Where(sq.Eq{"username": []string{"moe", "larry", "curly", "shemp"}})
three_stooges := stooges.Limit(3)
rows, err := three_stooges.RunWith(db).Query()
// Behaves like:
rows, err := db.Query("SELECT * FROM users WHERE username IN (?,?,?,?) LIMIT 3", "moe", "larry", "curly", "shemp")
Build conditional queries with ease:
if len(q) > 0 {
users = users.Where("name LIKE ?", q)
}
MySQL-specific functions
Multi-table delete
sql, args, err := sq.Delete("a1", "a2").
From("z1 AS a1").
JoinClause("INNER JOIN a2 ON a1.id = a2.ref_id").
Where("b = ?", 1).
ToSql()
sql, args, err := sq.Delete("a1").
Using("a2").
Where("a1.id = a2.ref_id AND a2.num = ?", 42).
ToSql()
PostgreSQL-specific functions
Package pg contains PostgreSQL specific operators.
Update from
sql, args, err := sq.Update("a1").
Set("foo", 1).
From("a2").
Where("id = a2.ref_id AND a2.num = ?", 42).
ToSql()
Delete using
sql, args, err := sq.Delete("a1").
Using("a2").
Where("id = a2.ref_id AND a2.num = ?", 42).
ToSql()
Returning clause
sql, args, err := Update("a").
Set("foo", 1).
Where("id = ?", 42).
Returning("bar").
ToSql()
JSON values
JSON and JSONB use json.Marshal to serialize values and cast them to appropriate column type.
sql, args, err := sq.Insert("posts").
Columns("content", "tags").
Values("Lorem Ipsum", pg.JSONB([]string{"foo", "bar"})).
ToSql()
Array values
Array serializes single and multidimensional slices of string, int, float32 and float64 values.
sql, args, err := sqrl.Insert("posts").
Columns("content", "tags").
Values("Lorem Ipsum", pg.Array([]string{"foo", "bar"})).
ToSql()
License
Sqrl is released under the MIT License.
*Note that all licence references and agreements mentioned in the sqrl README section above
are relevant to that project's source code only.