sqlitebrowser
go-sqlite3
Our great sponsors
sqlitebrowser | go-sqlite3 | |
---|---|---|
279 | 37 | |
19,802 | 7,373 | |
1.3% | - | |
9.0 | 6.3 | |
2 days ago | about 1 month ago | |
C++ | C | |
GNU General Public License v3.0 or later | MIT License |
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.
sqlitebrowser
- SQLite-Web: Web-based SQLite database browser written in Python
-
A SQLite extension that brings column-oriented tables to SQLite
Ahhh. We (sqlitebrowser.org) used to do something along those lines in one of our repos too.
We moved to downloading and compiling the latest SQLite release as a step in the unit tests instead, so we automatically always have the latest SQLite release.
It turns out to be really easy to do, because the SQLite download page has hidden tags in it just for this purpose:
https://github.com/sqlitebrowser/sqlitebrowser/blob/7a31ef97...
We have a spread of different GitHub Actions based workflows that do stuff whenever a PR is proposed or merged:
https://github.com/sqlitebrowser/sqlitebrowser/tree/master/....
Most of those are oriented around building packages for various OS's (Linux, macOS, Windows) so people can try the latest code.
While there are some tests, they're more like extremely basic sanity tests and don't rely on Docker.
Those tests rely on whichever version of SQLite was downloaded and compiled into the GUI (as per above code snippet).
---
That being said, that's for the client side GUI application. There's a server side of things too (https://github.com/sqlitebrowser/dbhub.io -> dbhub.io) that does use docker for it's automated tests:
https://github.com/sqlitebrowser/dbhub.io/tree/master/.githu...
Those are integration tests though (eg "make sure we didn't bust communication with our cli", "make sure our go library still works 100% with the server"), and a reasonably decent set of End to End (E2E) tests of the web interface using Cypress.
---
Does that help? :)
-
Sqlite3 Utility on the Browser
Do you know about SQLite DB Browser ? It's a multi platform application that would perfectly fit your use case :).
-
How do I get sql exactly?
Try https://sqlitebrowser.org/ itβs great for local use and training purposes
-
i feel overwhelmed , should i start learning django from tutorials first or begin by building projects.
You can see how the db file looks for the app using https://sqlitebrowser.org/
-
SQLite-Utils
If you want to fiddle with SQLite and don't need all the power herein, I recommend DB Browser for SQLite.
- How to access cards of a deck ( .apkg file) programmatically?
-
What's the easiest way to quickly run SQL queries on a small datasets?
An SQLite database? There are GUI you can use like DB Browser for SQLite which is easy to run.
-
Ask HN: Examples of desktop software with 20+ years of longevity?
DB Browser for SQLite (https://sqlitebrowser.org) was first released to the public domain on 2003-08-19. So, it'll be 20 years in a few months time. :)
go-sqlite3
-
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?
sqlitestudio - A free, open source, multi-platform SQLite database manager.
sqlcipher - SQLCipher is a standalone fork of SQLite that adds 256 bit AES encryption of database files and other security features.
GORM - The fantastic ORM library for Golang, aims to be developer friendly
nocodb - π₯ π₯ π₯ Open Source Airtable Alternative
sqlx - general purpose extensions to golang's database/sql
dbhub.io - A "Cloud" for SQLite databases. Collaborative development for your data. π
pgx - PostgreSQL driver and toolkit for Go
beekeeper-studio - Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
go-sqlite - Low-level Go interface to SQLite 3
godot-sqlite - GDNative wrapper for SQLite (Godot 4.x+)
go-sqlite-lite - SQLite driver for the Go programming language
Sqinn-Go - Golang SQLite without cgo