DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import.
Supports MySQL, PostgreSQL, SQL Server, Oracle, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, MariaDB, CosmosDB (Premium), ClickHouse. Admin databases, tables, schemas, indexes, keys. Synchronize database structures. Query designer. Form view. Limited JSON views.
Also known as SQL for Data Scientists in 100 Queries.
Has its own pack of lesson materials (SQLite databases) here: https://github.com/gvwilson/sql-tutorial/raw/main/sql-tutorial.zip
A utility that lets you query CSV, JSON and Parquet files with regular SQL statements. If DuckDB is okay with it, it'll run. Has both a fire-and-forget CLI and an interactive TUI.
The ChatGPT Retrieval Plugin lets you easily search and find personal or work documents by asking questions in everyday language. Provides a flexible solution for semantic search and retrieval of personal or organizational documents using natural language queries.
A CLI tool that lets you run SQL queries against CSV and TSV (tab-separated values) files. This includes data from shell pipes, like the output of ps
or other tools.
A set of tools and libraries to access human-editable, plain text databases called recfiles. The data is stored as a sequence of records, each record containing an arbitrary number of named fields. They're basically flat files. Field names and types are specified with %, data is in field name: value format. It's sort of like key/value, but more structured. Fields can be mandatory or forbidden. Primary keys, unique fields, automatically incrementing counters and timestamps. Template support for running reports. SQL-like joins and foreign keys. Individual fields can be encrypted. Conversion to and from several formats.
pyquery allows you to make jquery queries on xml documents. The API is as much as possible the similar to jquery. pyquery uses lxml for fast xml and html manipulation.
This is not (or at least not yet) a library to produce or interact with javascript code. I just liked the jquery API and I missed it in python so I told myself "Hey let's make jquery in python". This is the result.
A collection of interesting, funny, and depressing search queries to plug into https://shodan.io/
Fava is a web interface for the double-entry bookkeeping software Beancount with a focus on features and usability. Generates expense reports, graphs, tracks your money, assets and accounts, even lets you run queries. Has an API but it's for internal use only