Tag sqlite

6 bookmarks have this tag.

2023-08-23

578.

riyaz-ali/sqlean.go

github.com/riyaz-ali/sqlean.go

This module provides go bindings for sqlean. It is compatible with the popular mattn/go-sqlite3 driver.

2023-07-25

511.

Hosting SQLite databases on Github Pages - (or IPFS or any static file hoster) - phiresky's blog

phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages

It is possible to host read-only SQLite databases on static file hosters. Might be useful in some cases.

2023-07-03

417.

Как установить расширение для SQLite

antonz.ru/install-sqlite-extension

Антон Жиянов рекламирует свой новый реестр. Там показано, как расширение в Го подключить, может пригодиться потом.

416.

sqlpkg - SQLite Package Registry

sqlpkg.org

2023-05-07

210.

SQLite the only database you will ever need in most cases

unixsheikh.com/articles/sqlite-the-only-database-you-will-ever-need-in-most-cases.html

This is true.

2023-03-19

99.

The right way to use go-sqlite3

web.archive.org/web/20210423132955/https://foxcpp.dev/articles/the-right-way-to-use-go-sqlite3

SQLite is a wonderful piece of software and it is completely meaningful to use it in a project written in Go even though SQLite itself is in C. Though people has been hitting lots of issues with it, mostly "database is locked" error that seems to appear out of nowhere.

First of all, SQLite allows concurrent readers but only a single writer. Unlike most places where you may encounter some sort of synchronization SQLite does not wait for the write lock to become available - instead it just returns an error, letting the caller deal with it. This is why you are getting "database is locked" errors.