go-sqlite-lite
SQLite driver for the Go programming language (by bvinc)
go-pg
Golang ORM with focus on PostgreSQL features and performance (by go-pg)
| go-sqlite-lite | go-pg | |
|---|---|---|
| 3 | 9 | |
| 331 | 5,586 | |
| - | 0.3% | |
| 0.0 | 6.4 | |
| over 3 years ago | 5 days ago | |
| C | Go | |
| BSD 3-clause "New" or "Revised" License | BSD 2-clause "Simplified" License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
go-sqlite-lite
Posts with mentions or reviews of go-sqlite-lite.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-07-02.
- What SQL library are you using?
-
Are both MySQL and Postgres drivers similar in quality?
There is a third driver that I'll mention but is no longer maintained: https://github.com/bvinc/go-sqlite-lite
-
My Go-To Stack for Web Apps in 2021: Spring Boot, React, Postgres, Docker Compose
Database driver: bvinc/go-sqlite-lite
go-pg
Posts with mentions or reviews of go-pg.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-12.
-
Dockerized RESTful API Application in Go: CRUD,ORM,Logs,Migrations,Validations
Might have been this one but I can't be sure https://github.com/go-pg/pg
-
What SQL library are you using?
I usually work with PostgreSQL and have used https://github.com/go-pg/pg. https://github.com/uptrace/bun is its successor.
- Why all the hate?
-
Clean Transactions in Golang Hexagon
And it is go-pg. I personally really like it as a query builder (rather than an ORM) and it has good performance. It has one feature which I'll tell you about next, without which I would have struggled to implement what I had in mind. But this feature is available in other libraries too, so don't rush to rewrite your code.
-
SQL Query Strategy for complex structs
bun and go-pg both seem to work fairly well for these kind of purposes.
- Go for Backend development
-
Connecting with database
For database communication we will use go-pg module. You can install it by running go get github.com/go-pg/pg/v10. This will install version 10 of go-pg module, which is latest version at the time of writing this guide. Now create new directory internal/database/ and file database.go inside of it.
-
How much do you agree completely switching from Java to Go? I have total 9yrs of experience in Java but now I am interested in Go.
gorm.io/gorm`, or `github.com/go-pg/pg` if you need something more feature-rich. I would avoid using `go-kit` and `go-micro` "frameworks" unless you have some special requirement for it. But you can take a look to have an idea of what Go "framework" may look like.
-
A Proposal for Adding Generics to Go
This one is mostly excellent: https://github.com/go-pg/pg
What are some alternatives?
When comparing go-sqlite-lite and go-pg you can also consider the following projects:
go-sqlite3 - sqlite3 driver for go using database/sql
GORM - The fantastic ORM library for Golang, aims to be developer friendly
sqleet - SQLite3 encryption that sucks less
bun - Incredibly fast JavaScript runtime, bundler, test runner, and package manager – all in one
sqlite - Go SQLite3 driver
ent - An entity framework for Go
lsqlite - lua sqlite module
SQLBoiler - Generate a Go ORM tailored to your database schema.
esp32_arduino_sqlite3_lib - Sqlite3 Arduino library for ESP32
sqlx - general purpose extensions to golang's database/sql
SQLite-ICU-MinGW - Building SQLite and SQLiteODBC on Windows with ICU and other extensions using MSVC Build Tools and MSYS2/MinGW
bun - SQL-first Golang ORM