SQLitening Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Welcome to the SQLitening support forums!

Author Topic: SQLMan - Database Manager for SQLitening  (Read 13814 times)

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
SQLMan - Database Manager for SQLitening
« on: December 06, 2009, 06:36:18 AM »

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
« Last Edit: April 17, 2010, 08:05:35 AM by Rolf Brandt »
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #1 on: December 09, 2009, 11:49:05 AM »

Update:

Fixed some bugs.
Changed Layout to tabbed dialogs.

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

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #2 on: December 15, 2009, 07:04:47 PM »

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.
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #3 on: December 17, 2009, 02:58:31 AM »

Minor Update!
v1.0.0.72

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

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #4 on: December 17, 2009, 02:21:27 PM »

Bugfix!
v1.0.0.73

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

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #5 on: December 20, 2009, 03:52:26 AM »

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
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #6 on: December 25, 2009, 02:14:25 PM »

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
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #7 on: April 17, 2010, 08:19:57 AM »

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
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Fredrick Ughimi

  • Master Geek
  • ****
  • Posts: 601
    • View Profile
    • Software Development Company
Re: SQLMan - Database Manager for SQLitening
« Reply #8 on: April 18, 2010, 04:34:47 AM »

Great job!

Thank you Rolf.

Logged
Fredrick O. Ughimi

fughimi@yahoo.com
- Freedom lies in being bold -- Robert Frost, Poet

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #9 on: April 06, 2012, 07:37:04 AM »

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
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rudolf Fuerstauer

  • Newbie
  • *
  • Posts: 16
    • View Profile
Re: SQLMan - Database Manager for SQLitening
« Reply #10 on: April 06, 2012, 08:45:57 AM »

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
Logged

Rolf Brandt

  • Master Geek
  • ****
  • Posts: 382
    • View Profile
    • Taxi Dispatching Systems
Re: SQLMan - Database Manager for SQLitening
« Reply #11 on: April 07, 2012, 01:29:05 AM »

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
Logged
I like to cook with wine - sometimes I even add it to the food.
www.rbsoft.eu

Rudolf Fuerstauer

  • Newbie
  • *
  • Posts: 16
    • View Profile
Re: SQLMan - Database Manager for SQLitening
« Reply #12 on: April 07, 2012, 10:29:04 AM »

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

Rudi
Logged