Top 23 Relational Database Open-Source Projects

• sqlx

  71 15,448 3.6 Go

  general purpose extensions to golang's database/sql

Project mention: Migrating Next.js App to GO + Templ & HTMX | dev.to | 2024-05-05

sqlx for the database driver.

• go-sql-driver/mysql

  19 14,204 7.8 Go

  Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)

  

• 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.

  

• Peewee

  3 10,825 8.3 Python

  a small, expressive orm -- supports postgresql, mysql, sqlite and cockroachdb

Project mention: Any Python ORMs worthy of production? | news.ycombinator.com | 2023-12-18

• pgx

  71 9,523 9.1 Go

  PostgreSQL driver and toolkit for Go

Project mention: Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App | dev.to | 2024-04-22

Sometimes, backend developers tend to opt for an ORM library because it provides an abstraction between your app and the database and thus there is little or no need to write raw queries and migrations which is nice. However, if you want to get better at writing queries (SQL for example), you need to learn how to build your repositories without an ORM. To open a database handle, you can either do it directly from the database driver or do it from database/sql with the driver passed into it. I will be opening the connection with database/sql together with pgx which is a driver and toolkit for PostgreSQL. Walk with me.

• SQLAlchemy

  124 8,841 9.7 Python

  The Database Toolkit for Python

  

Project mention: Python: A SQLAlchemy Wrapper Component That Works With Both Flask and FastAPI Frameworks | dev.to | 2024-05-03

In SQLAlchemy, models representing database tables typically subclass sqlalchemy.orm.DeclarativeBase (this class supersedes the sqlalchemy.orm.declarative_base function). Accordingly, the abstract base class in this database wrapper component is a sqlalchemy.orm.DeclarativeBase subclass, accompanied by another custom base class providing additional dunder methods.

• pq

  28 8,776 3.2 Go

  Pure Go Postgres driver for database/sql

  

Project mention: Authentication system using Golang and Sveltekit - Initialization and setup | dev.to | 2023-06-02

Following the completion of the series — Secure and performant full-stack authentication system using rust (actix-web) and sveltekit and Secure and performant full-stack authentication system using Python (Django) and SvelteKit — I felt I should keep the streak by building an equivalent system in PURE go with very minimal external dependencies. We won't use any fancy web framework apart from httprouter and other basic dependencies including a database driver (pq), and redis client. As usual, we'll be using SvelteKit at the front end, favouring JSDoc instead of TypeScript. The combination is ecstatic!

• go-sqlite3

  40 7,488 6.2 C

  sqlite3 driver for go using database/sql

Project mention: Show HN: Roast my SQLite encryption at-rest | news.ycombinator.com | 2024-04-30

SQLite encryption at-rest is a hot requested feature of both the “default” CGo driver [1] and the transpiled alternative driver [2]. So, this is a feature I wanted to bring to my own Wasm based Go driver/bindings [3].

Open-source SQLite encryption extensions have had a troubled last few years. For whatever reason, in 2020 the (undocumented) feature that made it easy to offer page-level encryption was removed [4]. Some solutions are stuck with SQLite 3.31.1, but Ulrich Telle stepped up with a VFS approach [5].

Still, their solution seemed harder than something I'd want to maintain, as it requires understanding the structure of what's being written to disk at the VFS layer. So, I looked at full disk encryption for something with less of an impedance mismatch.

Specifically, I'm using the Adiantum tweakable and length-preserving encryption (with 4K blocks, matching the default SQLite page size), and encrypting whole files (rather than page content).

I'm not a cryptographer, so I'd really appreciate some roasting before release.

There is nothing very Go specific about this (apart from the implementation) so if there are no obvious flaws, it may make sense to port it to C/Rust/etc and make it a loadable extension.

[1] https://github.com/mattn/go-sqlite3/pull/1109

• SaaSHub

  www.saashub.com featured

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

  

• PonyORM

  2 3,528 5.8 Python

  Pony Object Relational Mapper

  

• GINO

  0 2,644 0.0 Python

  GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.

  

• djongo

  10 1,857 7.3 Python

  Django and MongoDB database connector

  

• go-mssqldb

  5 1,793 0.0 Go

  Microsoft SQL server driver written in go language

• orm

  1 1,754 0.0 Python

  An async ORM. 🗃 (by encode)

  

• prisma-client-py

  11 1,618 9.0 Python

  Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use

• go-oci8

  1 628 0.0 Go

  Oracle driver for Go using database/sql

• godror

  4 504 8.6 C

  GO DRiver for ORacle DB

  

• pyDAL

  0 477 6.1 Python

  A pure Python Database Abstraction Layer

  

• micronaut-data

  1 457 9.6 Java

  Ahead of Time Data Repositories

  

Project mention: [Mictonaut] Accessing SQL Server 2 | dev.to | 2024-01-19

micronaut-data/doc-examples/r2dbc-example-java - GitHub

• Sqinn-Go

  8 402 5.5 Go

  Golang SQLite without cgo

Project mention: Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it | news.ycombinator.com | 2023-12-14

Note that Squinn is not "native go" or "go only", but the owner insists on misleading people:

https://github.com/cvilsmeier/sqinn-go/issues/8

• firebirdsql

  0 219 5.9 Go

  Firebird RDBMS sql driver for Go (golang)

• homebase-react

  2 201 0.0 Clojure

  The React state management library for write-heavy applications

  

• go-adodb

  0 136 0.0 Go

  Microsoft ActiveX Object DataBase driver for go that using exp/sql

• gofreetds

  0 110 0.0 Go

  Go Sql Server database driver.

  

• vertica-sql-go

  0 60 4.9 Go

  Official native Go client for the Vertica Analytics Database.

  

• SaaSHub

  www.saashub.com featured

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

  

Relational Databases related posts

• Python: A SQLAlchemy Wrapper Component That Works With Both Flask and FastAPI Frameworks

  3 projects | dev.to | 3 May 2024

• Show HN: Roast my SQLite encryption at-rest

  9 projects | news.ycombinator.com | 30 Apr 2024

• Setting up a Database Driver, Repository and Implementation of a transaction function for your Go App

  2 projects | dev.to | 22 Apr 2024

• Replacing Complicated Hashmaps with SQLite

  1 project | news.ycombinator.com | 6 Apr 2024

• Xz/liblzma: Bash-stage Obfuscation Explained

  1 project | news.ycombinator.com | 31 Mar 2024

• The DDD Hamburger for Go

  2 projects | dev.to | 6 Jan 2024

• Alembic with Async SQLAlchemy

  1 project | dev.to | 12 Dec 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