Open Source SQLite 3 Database Manager

David de Argentina · Post by **David de Argentina** » Tue Jul 17, 2007 4:20 pm

Hi All

Im working on a SQLite 3 Database Manager.

I think there is the best option to work with local databases. It has good perfomance and capabilities, not need previous installer packages, and Zero Royalites to MS.

I think this is a good idea in order to do a Open Source Project.

There are some areas to work:

a) Tree Object Navegation for Databases, Tables, Columns, Indexes, Collations, etc.

b) Reconfigurable Grid to display the recordset.

c) Wizard to generate a SQL querry

d) Wizard to generate new Databases, Tables, Columns, indexes, etc or edit them

e) Multilingual Support.

f) Other services.

g) Miscelanious: Icon designers, images designers, etc

If you are interested to join in this project, feel free to continue this topic telling me what kind or work you think you can do.

This is a good place to write all questions, suggestions and ideas.

Thanks in advance,

David de Argentina

David de Argentina · Post by **David de Argentina** » Wed Sep 19, 2007 9:27 am

Hi Guys,

Project is still alive.
I need Beta Testers.

At ths Beta 1 you can:

* Create SQLite 3 Databases
* Create / Rename / Drop Tables
* Create / Rename / Delete Columns
* View / Edit / Delete Records
* Import Binary Files into a Blob Field Directly
* Export Binary Blob Data to an external File Directly
* View Recordset into a Grid
* Execute SQL Statements
* Optimize Database
* Resize Viewports freely: Database ViewPort, Table ViewPort and Recordset Viewport

. All Functions are acceded using right click.
. Double click at Table Name into Database Viewport starts recordset grid and Table Info viewports.
. Please note there are a specific context menu for each level (database, table, column) for the database treeview viewport.

. This Beta 1 asumes that first column called "ID" is the primary key of the table. It will not be modified. It will be changed on beta 2.

. All files stored into the sample database are JPG images

You can download Beta 1 at:

http://specialapps.software-zone.com/fi ... anager.zip

Please, send me your comments.

Thanks in advance
David de Argentina

smartmedia · Post by **smartmedia** » Wed Sep 19, 2007 10:29 am

Hi...

Well i don't know about functionality but from visual point of view needs a lot of changes. Before 3 months i started a project called RapidFinder http://www.rapidfinder.ws, still i have problems that comes from the way the application actually is presented to end user. What i am trying to say is that even if you make the best program if the GUI is not attractive then you don't have to much possibilities.

David as soon you open i can resize the application, small bug, but enough give wrong idea to user.

http://i9.tinypic.com/4qxr6u9.jpg

I wise you the best...

David de Argentina · Post by **David de Argentina** » Wed Sep 19, 2007 10:44 am

Hi SmartMedia,

Thanks for your comments,

"Refresh Recordset" must be disabled at start time.
this produces the error.

I dont reset the "resizeable" attribute. you are seeing hidden objects.

I will upload a new version updated.

Thanks again.

David de Argentina · Post by **David de Argentina** » Wed Sep 19, 2007 10:54 am

Program updated.

you need download again the file.

http://specialapps.software-zone.com/fi ... anager.zip

When I tell about resize viewports, do this steps:

* Open sample database
* Click the database name at the left panel
* Double click at Table Name. It starts the Table Info Panel and Recordset panel.
* The vertical and horizontal separator works as trackbar, you can see the mouse cursor changes at "hand" cursor.
* Drag the vertical separator to left or right.
* Or drag the horizontal separator to up or down.

you can see how the panels was reconfiguring itself automaticaly.