Puppy Linux Discussion Forum

[tatamata]

I have prepared PET package for MightyQuery 1.0.4 (UPDATE: MightyQuery 1.0.7) Database management software. You can download it from here:

http://www.4shared.com/file/wRupy78S/MightyQuery-104.html (3.8 MB download)
UPDATE:
http://www.4shared.com/file/SDJGBhgS/MightyQuery-107.html
UPDATE:
http://www.4shared.com/file/KpejPA6A/MightyQuery-108.html

I would kindly ask maintainers of different PETs repositories to upload the PET to their repositories.

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 and effective SQL DBMS for querying CSV files. In contrast to most database systems, MightyQuery does not require neither server installation, neither external libraries.

Though there are other database solutions that can process single textual file, MightyQuery is distinguished from them by its SQL engine, by which you can query and modify CSV tables with power that is normally reserved for huge enterprize-level SQL engines.

If you need to process heterogenous business data exported from various enterprize ERP, MRP, Data Warehouse, Accounting or other database systems, MightyQuery could be your solution. It is, also, suitable for managing simple personal databases, in cases where installing and managing complicated SQL servers is overkill for you.

To enable processing of external data, Mighty Query contains importing utility, supporting wide range of SQL database servers, such as: PostgreSQL, Interbase, Firebird, MSSQL, Sybase, SQLite, Oracle, ado, ASA.

MightyQuery is developed by using Lazarus Free Pascal RAD IDE (www.lazarus.freepascal.org) and janSQL database engine, which original code is written Jan Verhoeven (http://jansfreeware.com) and released under MPL 1.1. license.

You can download source code and binaries from:

http://www.4shared.com/folder/XL3EZwUR/MightyQuery.html[url][/url]

[tatamata]

Could somebody share his opinion about MightyQuery?
Do you find it useful?

[tatamata]

MightyQuery version 1.0.5 is out.
You can download both source and binaries from:
http://www.4shared.com/folder/XL3EZwUR/MightyQuery.html
Changes from previous version:

- SQL syntax colouring and highlighting
- auto-completion in SQL editor ([Ctrl]+[Space])

Next few days I am going to clean-up whole code, so the next version will be rewritten and based on zmsql package (TZMonnection and TZMQueryDataset components). In future, these two projects (MightyQuery and zmsql) will be synchronized.
PET package can be downloaded from:
http://www.4shared.com/file/U0vQCvLm/MightyQuery-105.html

[smokey01]

Interesting. I will take a peek.

Does it allow you to create forms?

[tatamata]

No, not yet

[smokey01]

That's a pity.

Forms are the one thing that is missing from some other good applications such as Portabase which is also quite nice.

[tatamata]

Smokey01, in following weeks I am going to focus on zmsql package (http://www.lazarus.freepascal.org/index.php/topic,13821.msg72958.html#msg72958) that will be basis for future MightyQuery versions.
Namely,
- adding master/detail filtering
- enforcing refferential integrity
- improving JanSQL database engine
- enabling parameterized queries
- to enable autoincrement field type

After that I will focus on the MightyQuery:
-visual query builder
- form generation, reporting
- scripting

Yeah, a long way to go... [/url]

[smokey01]

Very exciting. I'm looking forward to it.

[tatamata]

MightyQuery 1.0.7 is released. This is bug fixes release.
In previous version there was a stupid bug that prevented proper connecting to a "database" when scrolling through "Projects".

Binaries and source code can be downloaded from:
http://www.4shared.com/folder/XL3EZwUR/MightyQuery.html

PET package can be downloaded from:
http://www.4shared.com/file/SDJGBhgS/MightyQuery-107.html

[amigo]

lazarus -yuucckk! Can't you work in C or something else more common? Getting lazarus compiler working just to build one program is a royal PITA.

[tatamata]

amigo,
You don't need FPC compiler at all, PET package containes already compiled binary.

Why are you against Lazarus and FPC? These are great and superb projects.
Talking about languages, well, have you ever tried using object Pascal? If you had, maybe you would understand why I prefer Pascal over C/C++...

[smokey01]

tatamata

As requested.

http://www.smokey01.com/pets/

or direct link to MightyQuery

http://www.smokey01.com/pets/MightyQuery-1.0.7.pet

[tatamata]

Thank you, smokey01!

[tatamata]

Bug fix release, version 1.0.8 is available for download:
http://www.4shared.com/file/KpejPA6A/MightyQuery-108.html