Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Mon 01 Sep 2014, 08:21
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Utilities
MightyQuery 1.0.8 SQL Database Management Software
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 1 [14 Posts]  
Author Message
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Mon 06 Jun 2011, 15:08    Post subject:  MightyQuery 1.0.8 SQL Database Management Software  

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]

Last edited by tatamata on Thu 29 Dec 2011, 04:47; edited 5 times in total
Back to top
View user's profile Send private message 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Fri 22 Jul 2011, 06:09    Post subject:  

Could somebody share his opinion about MightyQuery?
Do you find it useful?
Back to top
View user's profile Send private message 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Sun 24 Jul 2011, 16:49    Post subject: MightyQuery 1.0.5 released  

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

Last edited by tatamata on Mon 25 Jul 2011, 02:45; edited 1 time in total
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 1806
Location: South Australia

PostPosted: Sun 24 Jul 2011, 17:00    Post subject:  

Interesting. I will take a peek.

Does it allow you to create forms?

_________________
Puppy Software <-> Distros <-> Puppy Linux Tips
Back to top
View user's profile Send private message Visit poster's website 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Sun 24 Jul 2011, 17:05    Post subject:  

No, not yet Rolling Eyes
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 1806
Location: South Australia

PostPosted: Sun 24 Jul 2011, 17:08    Post subject:  

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.

_________________
Puppy Software <-> Distros <-> Puppy Linux Tips
Back to top
View user's profile Send private message Visit poster's website 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Mon 25 Jul 2011, 02:50    Post subject:  

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... Laughing[/url]
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 1806
Location: South Australia

PostPosted: Mon 25 Jul 2011, 03:49    Post subject:  

Very exciting. I'm looking forward to it.
_________________
Puppy Software <-> Distros <-> Puppy Linux Tips
Back to top
View user's profile Send private message Visit poster's website 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Thu 04 Aug 2011, 10:24    Post subject:  

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
Back to top
View user's profile Send private message 
amigo

Joined: 02 Apr 2007
Posts: 2238

PostPosted: Thu 04 Aug 2011, 13:14    Post subject:  

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.
Back to top
View user's profile Send private message 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Thu 04 Aug 2011, 13:37    Post subject:    

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++...
Back to top
View user's profile Send private message 
smokey01


Joined: 30 Dec 2006
Posts: 1806
Location: South Australia

PostPosted: Thu 04 Aug 2011, 17:18    Post subject:  

tatamata

As requested.

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

or direct link to MightyQuery

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

_________________
Puppy Software <-> Distros <-> Puppy Linux Tips
Back to top
View user's profile Send private message Visit poster's website 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Thu 04 Aug 2011, 17:25    Post subject:  

Thank you, smokey01!
Back to top
View user's profile Send private message 
tatamata

Joined: 02 May 2010
Posts: 63

PostPosted: Thu 29 Dec 2011, 04:48    Post subject:  

Bug fix release, version 1.0.8 is available for download:
http://www.4shared.com/file/KpejPA6A/MightyQuery-108.html
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 1 [14 Posts]  
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Utilities
Jump to:  

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


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0659s ][ Queries: 11 (0.0044s) ][ GZIP on ]