Tag 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 16 posts.