• Welcome, Guest. Please login.
 
November 18, 2019, 02:47:27 am

News:

Welcome to the SQLitening support forums!


SQLMan - Database Manager for SQLitening

Started by Rolf Brandt, December 06, 2009, 08:06:18 am

Previous topic - Next topic

Rolf Brandt

December 06, 2009, 08:06:18 am Last Edit: April 17, 2010, 10:35:35 am by Rolf Brandt
SQLiteningMan - a Database Manager for SQLitening

SQLiteningMan is written PB 9 / FireFly 3. The full source code is availabe on the Paul Squire's FireFly3 Forum. Please not that SQLiteningMan is at a very early stage of development. It certainly is not bug free.

SQLiteningMan can work in local or Client / Server mode.

So far I have implemented the following functions:
- 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- Helpfile
- Create triggers
- Export to CSV
- Grid Printing - Column width reflected in printout

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 Desktop 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 connection via UMTS Stick)


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

Last Update: 2009-12-25
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Update:

Fixed some bugs.
Changed Layout to tabbed dialogs.

Download and screenshots in first message of thread.
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Update v1.0.0.71

Corrected bug frmAddModify
Changed Layout to Tab based rather then Popup Dialogs
Added NOT LIKE to Query Builder
Added Database creation
Still fidgeting with implementation of ESCAPE in Query Builder
frmAddModify - set Cancel property  =True for Cancel button
Added DoubleClick event in Grid to open edit dialog
Corrected Click/DblClick behaviour in Treeview
QueryBuilder - Added UpDown  control to change order of selected fields
MainWindow - Added Indices to Treeview
Database Creation - Added Create Index
Database Info - Added Listview for TableDefinition
Database Info - Added Index information

Download in first message of thread.
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Minor Update!
v1.0.0.72

Bugfix in Add/Edit record.
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Bugfix!
v1.0.0.73

Download in first message of thread.
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Update!
v1.0.0.74

Changes:
Implemented Creation of Triggers
frmAddModify again - jumps to next field after edit (finally)

Changed name of executable to SQLiteningMan to reflect it's real purpose.

A complete setup with all dependencies, helpfile, and sample database can be downloaded here:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Update!
v1.0.0.75

Changes:
RecordBrowser - right mouseclick opens Edit dialog with selected column
ToolsMenu - Export to CSV
Updated helpfile

Complete setup with all dependencies, helpfile, and sample database:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

Update!
v1.0.0 Release 86

Changes:
New Layout - Selected record displayed in 2nd Listview (see image)
New Feature - Grid printing, column width is reflected in printout.


Complete setup with all dependencies, helpfile, and sample database:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Fredrick Ughimi

Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Rolf Brandt

Update!
v1.0.1 Release 148

Changes:
Supports password protected database files now.
Some quirks fixed.

Complete setup with all dependencies, helpfile, and sample database:
http://sqlitening.rbsoft.eu/SQLiteningMan_Setup.exe

Rolf
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rudolf Fuerstauer

Hi Rolf,

thank you for the new version, but I can not connect to the database.
I get a connection to the server, but not to the database.


Rudolf

Rolf Brandt

Thanks Rudolf,

I am gonna check it out. Found a little bug anyway.

Are you sure that there is no error in database name or password?

Rolf
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rudolf Fuerstauer

Yes, the database name and the password is correct.
I've even tried using another database and see the same behavior.

Rudi