usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

usql - universal command-line interface for SQL databases

rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. Forming a cluster is very straightforward, it gracefully handles leader elections, and tolerates failures of machines, including the leader. rqlite gives you the functionality of a rock solid, fault-tolerant, replicated relational database, but with very easy installation, deployment, and operation. With it you've got a lightweight and reliable distributed relational data store. Think etcd or Consul, but with relational data modelling also available.
<BR><BR>
if you're interested in understanding how distributed systems actually work, rqlite is a good example to study. Much thought has gone into its design and implementation, with clear separation between the various components, including storage, distributed consensus, and API. rqlite uses Raft to achieve consensus across all the instances of the SQLite databases, ensuring that every change made to the system is made to a quorum of SQLite databases, or none at all. 



rqlite is a lightweight, distributed relational database, which uses SQLite as its storage engine. Forming a cluster is very straightforward, it gracefully handles leader elections, and tolerates failures of machines, including the leader. rqlite gives you the functionality of a rock solid, fault-tolerant, replicated relational database, but with very easy installation, deployment, and operation. With it you've got a lightweight and reliable distributed relational data store. Think etcd or Consul, but with relational data modelling also available.


rqlite - The lightweight, distributed relational database built on SQLite

Squirrel is not an ORM, It helps you build SQL queries from composable parts and also supports executing queries directly. Squirrel works well with PostgreSQL.

Squirrel - Fluent SQL generation for golang

Discover open source projects across all platforms

Projects

usql - universal command-line interface for SQL databases

rqlite - The lightweight, distributed relational database built on SQLite

Squirrel - Fluent SQL generation for golang

Tagcloud

Suggested keywords:

Projects

usql - universal command-line interface for SQL databases

rqlite - The lightweight, distributed relational database built on SQLite

Squirrel - Fluent SQL generation for golang

Tagcloud