OpenTelemetry instrumentation for database/sql. Contribute to XSAM/otelsql development by creating an account on GitHub.
by 
Jamie Tanna
.
#opentelemetry
#sqlite
#sql.
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.
Original Post SQLite is cool now. DHH uses it, Laravel defaults to it. Here is a list of sensible...
by Jamie Tanna
.
#sqlite.
SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, DuckDB] - frectonz/sql-studio
by Jamie Tanna
.
#sqlite.
SQLite Studio is a single-file binary, single-command SQLite database explorer.
by Jamie Tanna
.
#sqlite.
24 comments
by Jamie Tanna
.
#sqlite.
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.
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.
Datasette authentication using IndieAuth and RelMeAuth - simonw/datasette-indieauth
by Jamie Tanna
.
#sqlite
#indieauth.
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.
Explore ELF objects through the power of SQL. Contribute to fzakaria/sqlelf development by creating an account on GitHub.
by Jamie Tanna
.
#sqlite.
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.
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.
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.
Visualize your SQLite database schema. Contribute to inukshuk/sqleton development by creating an account on GitHub.
by Jamie Tanna
.
#sqlite.
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.
Search for the query instead of typing it by hand.
by Jamie Tanna
.
#sqlite.
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 36 posts.