MightyQuery 1.0.8 SQL Database Management Software

Miscellaneous tools
Post Reply
Message
Author
tatamata
Posts: 63
Joined: Sun 02 May 2010, 09:09

MightyQuery 1.0.8 SQL Database Management Software

#1 Post by 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/Mi ... y-104.html (3.8 MB download)
UPDATE:
http://www.4shared.com/file/SDJGBhgS/Mi ... y-107.html
UPDATE:
http://www.4shared.com/file/KpejPA6A/Mi ... y-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
Last edited by tatamata on Thu 29 Dec 2011, 08:47, edited 5 times in total.

tatamata
Posts: 63
Joined: Sun 02 May 2010, 09:09

#2 Post by tatamata »

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

tatamata
Posts: 63
Joined: Sun 02 May 2010, 09:09

MightyQuery 1.0.5 released

#3 Post by 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/Mi ... y-105.html
Last edited by tatamata on Mon 25 Jul 2011, 06:45, edited 1 time in total.

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#4 Post by smokey01 »

Interesting. I will take a peek.

Does it allow you to create forms?

tatamata
Posts: 63
Joined: Sun 02 May 2010, 09:09

#5 Post by tatamata »

No, not yet :roll:

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#6 Post by 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
Posts: 63
Joined: Sun 02 May 2010, 09:09

#7 Post by tatamata »

Smokey01, in following weeks I am going to focus on zmsql package (http://www.lazarus.freepascal.org/index ... l#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... :lol:[/url]

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#8 Post by smokey01 »

Very exciting. I'm looking forward to it.

tatamata
Posts: 63
Joined: Sun 02 May 2010, 09:09

#9 Post by 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/Mi ... y-107.html

amigo
Posts: 2629
Joined: Mon 02 Apr 2007, 06:52

#10 Post by 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
Posts: 63
Joined: Sun 02 May 2010, 09:09

#11 Post by 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++...

User avatar
smokey01
Posts: 2813
Joined: Sat 30 Dec 2006, 23:15
Location: South Australia :-(
Contact:

#12 Post by 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
Posts: 63
Joined: Sun 02 May 2010, 09:09

#13 Post by tatamata »

Thank you, smokey01!

tatamata
Posts: 63
Joined: Sun 02 May 2010, 09:09

#14 Post by tatamata »

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

Post Reply