RestfulDB is a Web frontend for SQL databases. It provides both a Web GUI and a RESTful API for interaction with any MySQL/MariaDB or SQLite database. RestfulDB is developed with off-the-shelf usage in mind, but nevertheless it provides the means to override the default interpretations of underlying database's schema and data.
A Huginn agent that writes events into InfluxDB in line protocol format (primarily). No docs right now but there are only two files and the Huginn on-line docs therein seem helpful.
Securely store passwords using industry standard encryption, quickly auto-type them into desktop applications, and use our browser extension to log into websites.
Complete database encryption using industry standard 256-bit AES. Fully compatible with KeePass Password Safe formats. Your password database works offline and requires no internet connection.
Every feature looks, feels, works, and is tested on Windows, macOS, and Linux. You can expect a seamless experience no matter which operating system you are using.
A plugin for Firefox that lets you interface with a KeepassXC password manager.
Note that this is an official KeepassXC project, not somebody's third party code.
A collection of Awesome resources for the Flipper Zero device.
A Huginn agent for querying SQLite databases. Whatever it finds are emitted as events.
A Huginn agent for writing data into influxdb.
This gem provides two agents for Huginn that can read from and write to SQLite 3 databases.
For detailed instructions on their usage, please see the Markdown descriptions within the agents' source (which will also be displayed in your Huginn dashboard).
Note that this gem relies on the sqlite3 gem which itself requires SQLite3 development headers. If you're running Huginn on a regular server, satisfying this requirement may be simple.
A curated list of delightful databases in all shapes and sizes, and all FOSS.
WaveDB is SQLite with a HTTP interface.
It is a ~6MB (~2MB UPX-compressed) self-contained, zero-dependency executable that bundles SQLite 3.35.5 (2021-04-19) with JSON1, RTREE, FTS5, GEOPOLY, STAT4, and SOUNDEX.
If you are already a fan of SQLite, WaveDB acts as a thin HTTP-server wrapper that lets you access your SQLite databases over a network.
WaveDB can be used as a lightweight, cross-platform, installation-free companion SQL database for Wave apps. The h2o-wave package includes non-blocking async functions to access WaveDB.
Database files managed by WaveDB are 100% interoperable with SQLite, which means you can manage them with the sqlite3 CLI, backup/restore/transfer them as usual, or use Litestream for replication.
Manticore Search is an open-source search engine that was born in 2017 as a continuation of the famous Sphinx Search engine. We took all the best from that, significantly improved its functionality, fixed hundreds of bugs, and rewrote it almost completely internally. And left it all open-sourced! That’s what makes Manticore Search a modern, fast and light-weight full-featured search engine.
We have designed and developed Manticore to provide you with multi-functional relevant search capabilities with high performance and low resource consumption and importantly easily integrable. It doesn’t matter what environment you are using, whether it’s Windows, Linux, MacOS or Docker, you can always use Manticore Search and connect to it from different programming languages or HTTP via JSON or even using MySQL client.
Github: https://github.com/manticoresoftware/manticoresearch
Problems I'm seeing
Hey! I'm @rstacruz and this is a modest collection of cheatsheets I've written.
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.
A curated list of lists of awesome things.
Chartbrew is an open-source web application that can connect directly to databases and APIs and use the data to create beautiful charts. It features a chart builder, editable dashboards, embedable charts, query & requests editor, and team capabilities. Can pull data from MySQL, Postgres, MongoDB, and any API that returns JSON documents. Interactive graph and chart builder.
Written in node.js. Requires MySQL on the back-end.
If you use the service (https://chartbrew.com/) there's a free tier.
A curated list of awesome MySQL software, libraries, tools and resources.
sandman2 automagically generates a RESTful API service from your existing database, without requiring you to write a line of code. Simply point sandman2 to your database, add salt for seasoning, and voila!, a fully RESTful API service with hypermedia support starts running, ready to accept HTTP requests. sandman2 analyzes the schema for every table in the database you point it at and generates a REST APi automagickally. No ORM required.
Supports SQLite, Postgres, Oracle, SQLserver, Sybase, Drizzle, Firebird, DB2, Redshift, SQL Anywhere, and MonetDB. Uses the SQL Alchemy database URL format for connecting.
Example:
user@host:$ sandman2ctl -p 8000 -l -r sqlite+pysqlite:///geoplanet.sqlite
How to load JSON into a SQLite database all in one go using Python.
SQLite has a JSON datatype, so it's possible to load JSON objects into columns. There still needs to be a unique key for each entry, though.
dataset provides a simple abstraction layer removes most direct SQL statements without the necessity for a full ORM model - essentially, databases can be treated like a JSON file, a hash table or a NoSQL datastore.
Schema is automatically generated and updated. If you want to, you can use SQLite's in-memory database functionality. Records are either created or updated automatically, depending on whether or not they exist already. Built on top of SQLalchemy so whatever it supports, dataset supports.
Github: https://github.com/pudo/dataset
Teaching the server tech you need for development and production. Eliminating the frustration of server configuration. Databases, configuration management, containers, proxies, security, PHP, and much more.