Free SQLite Database Manager

[Simon_Berridge]

For my own use I have created a SQLite Database manager to help with my database applications.

It has a table creator, SQL manager and helper that allows you to create SQL text and scripts that can be copied in to your Xojo applications.

There is some missing functionality (Index and Trigger creation) but it is in working order.

Download from here:
https://dl.dropboxusercontent.com/u/10747116/RealStudioClasses/sbDBManager.zip

Please let me have comments.

Thanks all.

Simon.

[Richard_Summers]

Well done Simon!
Thank you for sharing that with us all. I often use an SQLite database manager app, so I’m more than happy to test it for you.

Thank you.

[Simon_Berridge]

You’re welcome, Richard.

Any feedback directly to me at simberr at gmail dot com.

I hope it is to your liking.

Simon.

[Jean-Yves_Pochez]

still have some work to use it but it’s in a good way.

This application uses unregistered plugins from Monkeybread Software. Please inform the developer of this application that they need to purchase a license from Monkeybread Software to remove this message. Thank you. (Cocoa: NSUserDefaults, Version 14.2 from Jun 22 2014, Process ID: 12761)

An exception of class SQLErrorExceptionMBS was not handled.  The application must shut down.

Exception Message: duplicate column name: Untitled Exception Error Number: 1

[Joost_Rongen]

@190460:@Simon Berridge

There is some missing functionality (Index and Trigger creation) but it is in working order.

Don’t understand why developing a tool where there are some available as freeware.

[Richard_Summers]

Maybe Simon enjoys the satisfaction of making his own version; I know I do.
If nobody ever made anything, simply because a version already existed - nothing would ever advance.

[Simon_Berridge]

Oops!

Forgot the registration part, now fixed.

Download from here:
https://dl.dropboxusercontent.com/u/10747116/RealStudioClasses/sbDBManager.zip

Simon.

[Peter_Job]

@190543:@Joost Rongen

Don’t understand why developing a tool where there are some available as freeware.

Because it is there, or because you can.

[Joost_Rongen]

@190544:@Richard Summers

If nobody ever made anything, simply because a version already existed - nothing would ever advance.

Agree !

[Richard_Summers]

[Dave_Kondris]

Does it not open .rsd files from Real Studio? It’s not letting me select them in the open dialogue.

[Simon_Berridge]

@190561:@Dave Kondris

Does it not open .rsd files from Real Studio? It’s not letting me select them in the open dialogue.

I will fix that.

Simon.

[DaveS]

@190543:@Joost Rongen

Don’t understand why developing a tool where there are some available as freeware.

Why did Chevrolet build a car? The Ford Model A already existed…
Why did RealBasic do what they did, 1000’s of programming languages already existed
Why did Apple or Dell or HP build a computer? IBM already had one.

[Simon_Berridge]

@190561:@Dave Kondris

Does it not open .rsd files from Real Studio? It’s not letting me select them in the open dialogue.

Now fixed.

[Axel_Schneider]

The app crashes when the database is encrypted.

An exception of class SQLErrorExceptionMBS was not handled.
The application must shut down.
Exception Message: file is encrypted or is not a database
Exception Error Number: 26

[Simon_Berridge]

@190776:@Axel Schneider

The app crashes when the database is encrypted.

Fixed.

Now extended to include Indexes.

Download: https://dl.dropboxusercontent.com/u/10747116/RealStudioClasses/sbDBManager.zip

Simon.