Tag sqlite
Post details
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB] - frectonz/sql-studio
by 
Jamie Tanna
.
#sqlite.
Post details
SQLite Studio is a single-file binary, single-command SQLite database explorer.
by Jamie Tanna
.
#sqlite.
Post details
24 comments
by Jamie Tanna
.
#sqlite.
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.
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.
Post details
Datasette authentication using IndieAuth and RelMeAuth - simonw/datasette-indieauth
by Jamie Tanna
.
#sqlite
#indieauth.
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.
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.
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.
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.
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.
Post details
Visualize your SQLite database schema. Contribute to inukshuk/sqleton development by creating an account on GitHub.
by Jamie Tanna
.
#sqlite.
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.
Post details
Search for the query instead of typing it by hand.
by Jamie Tanna
.
#sqlite.
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 33 posts.