SQLitening Database Manager Project

[Rolf Brandt]

SQLiteningMan - a Database Manager for SQLitening.

The project just is to show how fast and easy database applications can be written with FireFly and SQLitening. The program can work in local or Client / Server mode.

These functions are implemented :
- Connect to a server
- Open a database
- Read and display a recordset in a listview
- Layout - Changing the fontsize of the listview
- Add records
- Edit records
- Delete records
- Show some database info (will be extended)
- A QuickSQL function
- A SQL Query Builder
- Grid sorting (Credit goes to Jean-Piere Leroy)
- Column Auto Sizing (Credit goes to Jean-Piere Leroy)
- Create databases
- Create tables
- Create indeces
- Create triggers
- Print data grid (column width is reflected in printout)
- Helpfile

Something about the speed of SQLitening - I tested this app with the sample database that Fred Meier provided. These are the machines I used for testing:

- Server: AMD Athlon 5000 with 2.6 GHz, 2 GB RAM, Win7 Ultimate
- Dev machine: AMD Athlon 4850e with 2,526 MHz, 4 GB RAM, Win XP Pro SP3
- NetBook: Acer 751, Atom Z520, 1.30 GHz, 2 GB RAM, Win XP Home SP3

Speed on Dev Machine, reading 10,000 records:
- LAN (cable):  0.937 sec
- Local:        0.704 sec

Speed on NetBook, reading 10,000 records:
- Local:        2.781 sec
- WLAN:         3.719 sec
- Internet:     7.516 sec 

(Mobile Internet connection via UMTS Stick, Transfer rate was 68 kbs)

PS: I had created (some just adapted) a couple of icons for the toolbar. They are certainly not the most fantastic. I just wanted something in blue. If anyone has a good source for icons let me know. If anyone wants to use any of mine he can do so, they are Public Domain.

Rolf

A complete setup with all dependencies, helpfile, and sample database can be downloaded here:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe

Attached are two zip files:
- The project files. (You need to download these only, if you are just updating the project.)
- The runtime files. (The Dlls and the sample database. You need these in the release folder to run the compiled program.)

Latest Update: 2012-04-06 v1.01.148

[Ivan Iraola]

NICE!!!

You should also include the requirements, for example, I see you're using Jose's includes, make a note of that in case someone doesn't have them.

Include also the compiler you're using, just as a  reference.

[Rolf Brandt]

You've got a point there, Ivan.
I am using PB 9 and FireFly 3.04.

I should have also made some mention how to use the program. I will start a little helpfile later. Basic steps are:
- Choose a connection to connect or leave it empty to work local.
- Choose a datase (sample.db3)
- Connect and/or open Database.
- In the treeview click on the table you want to use.
- Click Show Data.

Rolf

[Marc van Cauwenberghe]

This really is great,

THANK YOU.

Marc

[Martin Francom]

Rolf,
   Excellent...  I look forward to using it.  I will try it out with that AdBook DB to see how it behaves.

[David Warner]

What a great idea, well done Rolf!

[Rolf Brandt]

I just noticed that I left the German language file (SQLMan.lng) in the Release folder, so that the program has German menues. The file is a normal ini file and can be edited. If you delete or rename the file, then the program will have the original English menues.

Rolf

[Andrew Lindsay]

Rolf,

Fantastic program, this is an excellent tool to show what both SQLite and FF3 can do.

Thanks for giving your effort to the FF community.

Regards

Andrew

[Rolf Brandt]

SQLMan Update

These are the changes:
- Added Delete Record
- DB Info - Added CopyToClipboard
- Added QuickSQL
- Add / Edit Dialog - Cursor moves now automatic to next field
- Removed some bugs (Might have created a few new ones...)

The download is in the first message of this thread.

Rolf

[Martin Francom]

Rolf,
   It's looking better and better.   When the "Create Database" is implimented, will the user be able to create a Multi-Table database and be able to define the indexes they want to use?  And to define the releationship between the records,  One to One and One to Many relationships ?
 
   I don't know if SQLite databases ever need to be "packed" but will this be possible with your SQL-DBM ?
   Also, if a SQLite database gets dammaged will SQL-DBM have tools to allow for rebuilding/repairing the database? 
   Finially, will SQL-DBM allow the user to re-structure the database.  IE insert or remove fileds, and  add or remove tables?

[Rolf Brandt]

Hi Marty,

all these features I am planning to implement.

[Rolf Brandt]

There was a bug in the AddEdit.frm module. Here is the proper working module.
The changes are also reflected in the complete project in the first message of this thread.

[Barry Marks]

I just noticed that I left the German language file (SQLMan.lng) in the Release folder, so that the program has German menues. The file is a normal ini file and can be edited. If you delete or rename the file, then the program will have the original English menues.

Rolf

Could you give us the English translation of the menus?  I can guess some of them and maybe figure out most of the rest, but the chances of getting some wrong are pretty high.

I have a future project in mind that might use SQLite and this will be a good introduction for me.  I had a bunch of training in SQL maybe 20 years ago but I've never done much with it after the training and about all I remember about it is that it was too confusing.  I was always a low level programmer and this just seemed so high level it made me dizzy.

Thanks,
Barry

[Rolf Brandt]

Barry,

I will work on the menues in the next days and post the complete menue file in English and German. Like that everybody can make his own file for his language.

If you just want English menues then delete the file 'SQLMan.lng' in the release folder. SQLMan will show the default English menues.

[Barry Marks]

Thank you.  That gives me what I need.

Barry