DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
Model-driven REST API for CRUD and more, written in Javascript, using Node.js, Express, and PostgreSQL.
Powerful and portable (Linux/Windows) astrology program, based on the swisseph library, with multitasking charts and data stored in a SQL database (postgresql). Many charts and options.
SQLite is a lightweight and embeddable database. It's fully ACID and SQL92 compliant with 100% test coverage. As storage a single cross-platform disk file format is used, which may be up to terrabytes in size. It requires no setup and little administrative work. SQLite itself has a simple yet expandable API. Bindings for most programming languages exist on all major plattforms.
Spawner can fill up database tables with sample data for testing. It either outputs CSV text values, or generates SQL INSERT statements, according to optionally configured data and field types (numeric, textual, names, address parts, varied-size text / enums / binary data). It can also connect to MySQL 5.x servers for insertions.
FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.
Apache Drill allows to query non-relational datastores. It supports HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. The aggregation and query mechanism even allows to join across multiple database backends. The query plan optimizer is datastore-aware and utilizes individual NoSQL filter and query mechanisms depending on each backend scheme.
LazSqlX is a cross-platform database management tool. It works with MariaDB/Mysql, PostgreSQL, SQLite, Firebird and Oracle databases. It provides am intuitive data browser, querying tool and management GUI. LazSqlX can also be used on stored procedures, for changing table schemata, search, filtering, printing, or CSV / XML /JSON exports.
termsql converts text from stdin or any file into an SQLite database table and allows users to execute SQL queries on that table, all in just one line on the command line. It can be used to sort, display, convert, extract, and modify data on the command line using syntax familiar to those who know SQL.
QAL (Query Abstraction Layer) is a set of Python libraries to handle and interchange data between multiple SQL databases or file storage backends. It works with Postgres, MySQL, DB2, Oracle and MS SQL server, and can read/write XML, CSV and Excel. It defines a SQL subset to facilitate interoperability.
ERMaster is an Eclipse plugin to make database Entitity-Relationship diagrams. It allows to import from a database, export a table definition to Excel, generate an ER image, or DDL output.
DBeauty is a database browser which visualizes relational structures and table/row interrelations. It can connect to an JDBC-supported SQL database, browser its content, navigate bidirectionally through tables, understands foreign key relations or user-defined connections, can generate SQL/DML, and execute arbitrary SQL queries.
SQL::Yapp is a Perl module which embeds SQL completely and safely into Perl. It checks SQL syntax at compile time and fully parses SQL to allow usage of any Perl scalars, arrays, and hashes in an intuitive and safe way. It makes SQL injections virtually impossible while making you feel as if SQL syntax were native to Perl.
|