godror
GO DRiver for ORacle DB (by godror)
go-sqlite3
sqlite3 driver for go using database/sql (by mattn)
Our great sponsors
godror | go-sqlite3 | |
---|---|---|
4 | 37 | |
496 | 7,373 | |
2.8% | - | |
8.6 | 6.3 | |
6 days ago | about 1 month ago | |
C | C | |
GNU General Public License v3.0 or later | MIT 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.
godror
Posts with mentions or reviews of godror.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-10-07.
-
Oracle DB support in Benthos
This work wasn't possible without https://github.com/sijms/go-ora and the amazing Oracle XE Docker images which Gerald Venzl put together: https://geraldonit.com/2021/08/15/oracle-xe-docker-images/. There's also https://github.com/godror/godror, but the main Benthos release is strictly CGo-free.
-
Getting timezone from address (country code, zip code and state)
https://github.com/godror/godror/commit/703514c6ee2e5da6078b253ddd9c1c4fc5af8f40 https://github.com/evanoberholster/timezoneLookup
-
Install godror
go get github.com/godror/godror go: downloading github.com/godror/godror v0.24.4 go: downloading github.com/go-logfmt/logfmt v0.5.0 # github.com/godror/godror cc1.exe: sorry, unimplemented: 64-bit mode not compiled in
go-sqlite3
Posts with mentions or reviews of go-sqlite3.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-12-01.
-
What 3rd-party libraries do you use often/all the time?
github.com/mattn/go-sqlite3
-
From Golang Beginner to Building Basic Web Server in 4 Days!
For building my web server, I chose to use the Gin framework as the foundation of my app. It was incredibly easy to understand and work with, and I was pleasantly surprised by how seamlessly it integrated with writing unit tests for the server. To handle the database, I leveraged the power of go-sqlite and migrate for efficient SQL queries and migrations. These libraries proved to be both powerful and user-friendly, making the development process a breeze.
- Zig now has built-in HTTP server and client in std
-
Exciting SQLite Improvements Since 2020
SQLite does have an optional "user authentication" extension, though I've not personally tried it out:
https://www.sqlite.org/src/doc/trunk/ext/userauth/user-auth....
The widely used Go SQLite library by mattn says it supports it, if that's useful:
-
Go port of SQLite without CGo
I have an OSS project, sq which is a data-wrangling swiss-army knife for structured data. Think of it as jq for databases. It supports Postgres, SQLServer, MySQL and - relevantly - SQLite. It embeds SQLite via CGo and the mattn/go-sqlite3 driver.
- In-memory key value store
-
Tools besides Go for a newbie
IDE: use whatever make you productive. I personally use vscode. VCS: git, as golang communities use github heavily as base for many libraries. AFAIK Linter: use staticcheck for linting as it looks like mostly used linting tool in go, supported by many also. In Vscode it will be recommended once you install go plugin. Libraries/Framework: actually the standard libraries already included many things you need, decent enough for your day-to-day development cycles(e.g. `net/http`). But here are things for extra: - Struct fields validator: validator - Http server lib: chi router , httprouter , fasthttp (for non standard http implementations, but fast) - Web Framework: echo , gin , fiber , beego , etc - Http client lib: most already covered by stdlib(net/http), so you rarely need extra lib for this, but if you really need some are: resty - CLI: cobra - Config: godotenv , viper - DB Drivers: sqlx , postgre , sqlite , mysql - nosql: redis , mongodb , elasticsearch - ORM: gorm , entgo , sqlc(codegen) - JS Transpiler: gopherjs - GUI: fyne - grpc: grpc - logging: zerolog - test: testify , gomock , dockertest - and many others you can find here
- GitHub - elgs/gosqlapi: Turns any SQL database into a RESTful API.
-
The most widely used database in the world
In Go, you need to install the go-sqlite3 package first. After that, it’s pretty straightforward to use as well:
-
Exploring Go bindings to SQLite using Wazero
Performance is below crawshaw.io/sqlite, but close enough that it might be competitive with modernc.org/sqlite. I'd need to build a database/sql driver to make a fair comparison (with modernc.org/sqlite and github.com/mattn/go-sqlite3).
What are some alternatives?
When comparing godror and go-sqlite3 you can also consider the following projects:
go-oci8 - Oracle driver for Go using database/sql
goracle
GORM - The fantastic ORM library for Golang, aims to be developer friendly
sqlx - general purpose extensions to golang's database/sql
pgx - PostgreSQL driver and toolkit for Go
go-sqlite - Low-level Go interface to SQLite 3
go-sqlite-lite - SQLite driver for the Go programming language
Sqinn-Go - Golang SQLite without cgo
go-sql-driver/mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package
firebirdsql - Firebird RDBMS sql driver for Go (golang)