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 zmsql package (http://www.4shared.com/account/dir/3Cw6SC1j/_online.html#dir=94126104; http://lazarus.freepascal.org/index.php/topic,13821.msg74492.html#msg74492).
ZMSQL package is based on TBufDataset and JanSQL database engine, which original code is written Jan Verhoeven (http://jansfreeware.com) and released under MPL 1.1. license.

You can download MightyQuery's source code and binaries from:
http://matalab.freehostia.com_________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.Last edited by Pelo on Thu 12 May 2016, 23:17; edited 1 time in total

I shall try it with polarpup QT. I suppose we can change column' names,
Databases are daily used at office; More than generic office suites. The challenge is adapting them to personal needs.
Create a new collection.
Collections group your structured data together.
Before you begin to enter data, you need to define at least one input field.
Input fields have a data type (text, numeric, image...) and delineate how data is presented and inserted.
You can add an unlimited amount of fields.
The structure of a collection can be modified at any time.
Once the data structure is defined, you can start to add as many records as you wish.
Records are data entries of your collection, they can be modified, deleted and duplicated

forum.jpg

Description

Database of people, dead.. or alive (Gramps)

Filesize

68.47 KB

Viewed

242 Time(s)

_________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.Last edited by Pelo on Thu 12 May 2016, 23:07; edited 2 times in total

I shall try it with Tahrpup, the brand new QT Puppy i shall look at the PPM if Sumphytum if available (for french druids)
Loaded from archives.org pets here
I must change my pendrive (i'm running an old Racy 5.3)
That is done, and symphytum runs without adding anything in my Tahrpup puppy. Qt and python stuff is included in that distro.
And so does Symphytum in LXPUP Qt issued december 2014_________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.Last edited by Pelo on Tue 17 Mar 2015, 05:09; edited 2 times in total

You can move Gui where you like on the page, resize them, rename, add, or delete fields, so easily _________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.Last edited by Pelo on Thu 12 May 2016, 23:05; edited 2 times in total

libQtSvg.so.4: cannot open shared object file: No such file or directory
#
My developers are searching... I'am afraid they will not find it.
That was just to see how easy is Symphytum to install. It's the first failure.
Gui's for apps are often sad. Symphytum brings some Joy not only with medecines but for pleasure of playing Puppy Linux, by a nice sunny afternoon. Is'it ?
"It would be the package managers job to find the packages that provide those files. This would be incredibly easy for the package manager" said the haikipup vietnamese conceptor in 2010. I Agree.
https://packages.debian.org/wheezy/libqt4-svg on try_________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.

MightyQuery to fullfil. None of my employees had even added one record ! they told me mys Slacko 5.5 is too old, and hat didn't found any help on forums about building the database..
Thats is true that windowsians use more databases than Linux, but Puppy is free of charge, and windows is a lot of money.
If people here really use data base, please contact me..
Libre-Office is very popular in Puppy, and seems to satisfy anybody..._________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.

Portabase now included in some puppies as defaut database. Try it and feed back ! I don't like Portabase, but it's not a reason... CSV cannot be imported, what a pity_________________Passenger Pelo ! don't ask him to repair the aircraft. Don't use him as a demining dog .... pleeease.

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forumYou cannot attach files in this forumYou can download files in this forum