Liked
Litestream: Revamped
Post details
Bringing in what we learned from LiteFS
by 
Jamie Tanna
.
#sqlite.
Tag sqlite
Liked
SQLite Extension Hub
Post details
Easily find and manage SQLite extensions.
by Jamie Tanna
.
#sqlite.
Performing group_concat queries over distinct values, with a custom delimiter, with SQLite (2 mins read).
How to avoid SQLite's DISTINCT aggregates must have exactly one argument error when performing a group_concat(distinct ...) with a custom delimiter.
Liked
Collection of insane and fun facts about SQLite - blag
Post details
Some of the interesting and insane facts I learned about SQLite
by Jamie Tanna
.
#sqlite.
Some useful SQL(ite) tips I've learned (5 mins read).
A collection of SQLite snippets I've picked up recently to improve my queries.
Liked
GitHub - XSAM/otelsql: OpenTelemetry instrumentation for database/sql
Post details
OpenTelemetry instrumentation for database/sql. Contribute to XSAM/otelsql development by creating an account on GitHub.
by Jamie Tanna
.
#opentelemetry
#sqlite
#sql.
Liked
Julia Evans (@b0rk@jvns.ca)
Post details
Attached: 1 image Just discovered litecli (https://github.com/dbcli/litecli), it feels like a big improvement over the default SQLite REPL (autocompletion! support for multiline queries! syntax highlighting!)
by Jamie Tanna
.
#sqlite.
Liked
Sensible SQLite defaults
Post details
Original Post SQLite is cool now. DHH uses it, Laravel defaults to it. Here is a list of sensible...
by Jamie Tanna
.
#sqlite.
Liked
GitHub - frectonz/sql-studio: SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB]
Post details
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB] - frectonz/sql-studio
by Jamie Tanna
.
#sqlite.
Liked
SQLite Studio is a SQLite Database Explorer - Laravel News
Post details
SQLite Studio is a single-file binary, single-command SQLite database explorer.
by Jamie Tanna
.
#sqlite.
Liked
Why does SQLite (in production) have such a bad rep? | Lobsters
Post details
24 comments
by Jamie Tanna
.
#sqlite.
Liked
Why does SQLite (in production) have such a bad rep? - blag
Post details
My answer to a question online, why?
by Jamie Tanna
.
#sqlite.
Performing cross-database queries with SQLite (2 mins read).
How to query multiple database files with SQLite.
My workflow for writing SQL(ite) queries (2024 edition) (4 mins read).
Writing about my recent workflow for writing, executing, and sharing SQL queries with others.
by Jamie Tanna
.
#blogumentation
#sql
#sqlite
#neovim
#datasette
#lsp.
Querying your organisation's Renovate configuration using SQL(ite) (3 mins read).
A new tool, renovate-config-sqlite to pull Renovate configuration into an SQLite database.
Bookmarked
Optimizing SQLite for servers
Post details
SQLite is often misconceived as a "toy database", only good for mobile applications and embedded systems because it's default configuration is optimized for embedded use cases, so most people trying it will encounter poor performances and the dreaded SQLITE_BUSY error. But what if I told you that by tuning a
by Jamie Tanna
.
#sqlite
#performance.
Liked
GitHub - simonw/datasette-indieauth: Datasette authentication using IndieAuth and RelMeAuth
Post details
Datasette authentication using IndieAuth and RelMeAuth - simonw/datasette-indieauth
by Jamie Tanna
.
#sqlite
#indieauth.
Liked
GitHub - maragudk/goqite: Go queue library built on SQLite and inspired by AWS SQS.
Post details
Go queue library built on SQLite and inspired by AWS SQS. - maragudk/goqite
by Jamie Tanna
.
#go
#sqlite.
What's everyones' favourite resources for how to best find which column(s) to index in your database?
by Jamie Tanna
.
#sql
#sqlite
#databases.
Liked
GitHub - fzakaria/sqlelf: Explore ELF objects through the power of SQL
Post details
Explore ELF objects through the power of SQL. Contribute to fzakaria/sqlelf development by creating an account on GitHub.
by Jamie Tanna
.
#sqlite.
Liked
GitHub - badboy/sqlelf: Explore ELF objects through the power of SQL
Post details
Explore ELF objects through the power of SQL. Contribute to badboy/sqlelf development by creating an account on GitHub.
by Jamie Tanna
.
#sqlite.
Anyone know a good place to ask #sqlite or #sql questions?
I'm trying to convert rows (produced by a big query that then uses a GROUP BY advisory_type) that produces data like:
-- the `advisory_type` can be one of multiple values, i.e. SECURITY, DEPRECATED, UNSUPPORTED
repo advisory_type total_advisories
------ ------------- ----------------
jvt.me SECURITY 10
jvt.me DEPRECATED 5
And I'm trying to convert this to:
repo total_security total_deprecated total_unmaintained
------ ------------- ---------------- ----------------
jvt.me 10 5 0
Any clue how I'd go about doing so? Happy to provide more details / some data for you to query too, but been playing around with it on and off and not really having any luck.
by Jamie Tanna
.
#sqlite
#sql.
Liked
Tracking SQLite Database Changes in Git | Garrit's Notes
Post details
by Jamie Tanna
.
#git
#sqlite.
Analysing GitHub Pull Request review times with SQLite and Go (3 mins read).
How measuring how long code review took as a team lead to being able to change our processes, and then deliver much more effectively.
by Jamie Tanna
.
#blogumentation
#sqlite
#go.
Liked
GitHub - dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
Post details
CLI for SQLite Databases with auto-completion and syntax highlighting - GitHub - dbcli/litecli: CLI for SQLite Databases with auto-completion and syntax highlighting
by Jamie Tanna
.
#sqlite.
Liked
GitHub - inukshuk/sqleton: Visualize your SQLite database schema
Post details
Visualize your SQLite database schema. Contribute to inukshuk/sqleton development by creating an account on GitHub.
by Jamie Tanna
.
#sqlite.
Liked
GitHub - ncruces/go-sqlite3: Go bindings to SQLite using Wazero
Post details
Go bindings to SQLite using Wazero. Contribute to ncruces/go-sqlite3 development by creating an account on GitHub.
by Jamie Tanna
.
#go
#sqlite.
Querying JSON with SQLite (1 mins read).
How to use json_each and json_extract to query a JSON field in SQLite.
Liked
SQLite CLI command history
by
Post details
Search for the query instead of typing it by hand.
by Jamie Tanna
.
#sqlite.
Liked
JSON improvements in SQLite 3.38.0
Post details
SQLite 3.38.0 introduced improvements to JSON query syntax using -> and ->> operators that are similar to PostgreSQL JSON functions. In this post we...
by Jamie Tanna
.
#sqlite.
Parsing AWS ALB/ELB access logs into SQLite (2 mins read).
How to take a set of ALB/ELB logs and convert them to an SQLite database for further processing.
Extracting Podcast Addict listening history from the SQLite database (2 mins read).
How to get raw listening history from the Podcast Addict database.
Querying and Interacting with CSV Files More Easily with SQLite (1 mins read).
How to use sqlite3 to parse and query comma-separated value files.
You're currently viewing page 1 of 1, of 42 posts.