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 Sun 21 Sep 2014, 22:24
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 Posts_count  
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]

Edited_times_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

Edited_time_total
Back to top
View user's profile Send_private_message 
smokey01


Joined: 30 Dec 2006
Posts: 1818
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_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: 1818
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_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: 1818
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_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: 2247

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: 1818
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_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:   Sort by:   
Page 1 of 1 Posts_count  
Post_new_topic   Reply_to_topic View_previous_topic :: View_next_topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Utilities
Jump to:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0664s ][ Queries: 12 (0.0047s) ][ GZIP on ]