Matthius MightyQuery is a single user SQL database management software working with data stored as comma separated values (.csv, .txt) in plain, flat, textual files. It is serverless, self-contained, simple SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery does not require neither server installation, neither external libraries. And is multiplatform (due to Lazarus).
It relies on JanSQL database engine , which original code was written by Jan Verhoeven (http://jansfreeware.com) in Delphi and released under MPL 1.1. license.
As far as I am aware, this might be the only existing free/open-source SQL database engine written in Pascal, thus worthy of preservation and improving.
To enable processing of external data, Mighty Query contains importing utility (due to Zeosdbo), supporting wide range of SQL database servers, such as: PostgreSQL, Interbase, Firebird, MSSQL, Sybase, SQLite, Oracle, ado, ASA.
MightyQuery uses TDbf for storing metadata about projects (databases), tables, queries, external sources of data. Retrieved data from JanSQL is transfered to TBufDataset for viewing, filtering and searching.
French
MightyQuery est une gestion de données à utilisateur unique permettant de lire les fichiers CSV, les fichiers textes.
C’est une gestion de données sans serveur; homogène permettant de créer des requêtes sur des fichiers CSV.
Il est compatible avec JanSQL. Il pemet d’importer vers PostgreSQL, Interbase, Firebird, MSSQL, Sybase, SQLite, Oracle, ado, ASA.
MightyQuery utilise les Datasets TDBF pour les métadonnées de projets et TBufDataset pour récupérer les données de JanSQL.
