qry alternatives and similar packages
Based on the "Database" category.
Alternatively, view qry alternatives based on common mentions on social networks and blogs.
-
vitess
vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services. -
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, and command-line tools. Based on LLVM. -
migrate
Database migration handling in Golang support MySQL,PostgreSQL,Cassandra and SQLite. -
kingshard
kingshard is a high performance proxy for MySQL powered by Golang. -
go-cache
An in-memory key:value store/cache (similar to Memcached) library for Go, suitable for single-machine applications. -
go-mysql-elasticsearch
Sync your MySQL data into Elasticsearch automatically. -
VictoriaMetrics
fast, resource-effective and scalable open source time series database. May be used as long-term remote storage for Prometheus. Supports PromQL. -
buntdb
A fast, embeddable, in-memory key/value database for Go with custom indexing and spatial support. -
xo
Generate idiomatic Go code for databases based on existing schema definitions or custom queries supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server. -
sql-migrate
Database migration tool. Allows embedding migrations into the application using go-bindata. -
cache2go
An in-memory key:value cache which supports automatic invalidation based on timeouts. -
immudb
immudb is a lightweight, high-speed immutable database for systems and applications written in Go. -
nutsdb
Nutsdb is 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. -
fastcache
fast thread-safe inmemory cache for big number of entries. Minimizes GC overhead. -
skeema
Pure-SQL schema management system for MySQL, with support for sharding and external online schema change tools. -
Bitcask
Bitcask is an embeddable, persistent and fast key-value (KV) database written in pure Go with predictable read/write performance, low latency and high throughput thanks to the bitcask on-disk layout (LSM+WAL). -
Databunker
Personally identifiable information (PII) storage service built to comply with GDPR and CCPA.
Scout APM - Leading-edge performance monitoring starting at $39/month
Do you think we are missing an alternative of qry or a related project?
Popular Comparisons
README
About
qry is a general purpose library for storing your raw database queries in .sql files with all benefits of modern IDEs, instead of strings and constants in the code, and using them in an easy way inside your application with all the profit of compile time constants.
qry recursively loads all .sql files from a specified folder, parses them according to predefined rules and returns a reusable object, which is actually just a map[string]string
with some sugar. Multiple queries inside a single file are separated with standard SQL comment syntax: -- qry: QueryName
. A QueryName
must match [A-Za-z_]+
.
gen tool is used for automatic generation of constants for all user specified query_names
.
Installation
go get -u github.com/HnH/qry/cmd/qry-gen
Usage
Prepare sql files: queries/one.sql
:
-- qry: InsertUser
INSERT INTO `users` (`name`) VALUES (?);
-- qry: GetUserById
SELECT * FROM `users` WHERE `user_id` = ?;
And the second one queries/two.sql
:
-- qry: DeleteUsersByIds
DELETE FROM `users` WHERE `user_id` IN ({ids});
Generate constants: qry-gen -dir=./queries -pkg=/path/to/your/go/pkg
Will produce /path/to/your/go/pkg/qry.go
with:
package pkg
const (
// one.sql
InsertUser = "INSERT INTO `users` (`name`) VALUES (?);"
GetUserById = "SELECT * FROM `users` WHERE `user_id` = ?;"
// two.sql
DeleteUsersByIds = "DELETE FROM `users` WHERE `user_id` IN ({ids});"
)
As a best practice include this qry-gen call in your source code with go:generate prefix: //go:generate qry-gen -dir=./queries -pkg=/path/to/your/go/pkg
and just execute go generate
before each build.
Now it's time to use qry inside your project:
func main() {
/**
* The most obvious way is to use generated constants in the source code
*/
// INSERT INTO `users` (`name`) VALUES (?);
println(pkg.InsertUser)
// DELETE FROM `users` WHERE `user_id` IN (?,?,?);
println(qry.Query(pkg.DeleteUsersByIds).Replace("{ids}", qry.In(3)))
/**
* As an alternative you can manually parse .sql files in the directory and work with output
*/
if q, err := qry.Dir("/path/to/your/go/pkg/queries"); err != nil {
log.Fatal(err)
}
// SELECT * FROM `users` WHERE `user_id` = ?;
println(q["one.sql"]["GetUserById"])
// DELETE FROM `users` WHERE `user_id` IN (?,?,?);
println(q["two.sql"]["DeleteUsersByIds"].Replace("{ids}", qry.In(3)))
}