[ANN] SQLiteAdmin

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
phaworth
Posts: 592
Joined: Thu Jun 11, 2009 9:51 pm

[ANN] SQLiteAdmin

Post by phaworth » Wed Apr 11, 2012 6:38 pm

I'm happy to announce the release of my first commercial Livecode application, SQLiteAdmin, a db admin tool for SQLite databases. A 30-day trial version of SQLiteAdmin is available at www.lcsql.com/products.html

I am making SQLiteAdmin available for $4.99, a $20 discount, to any forum member until midnight on Friday April 13th. Please email me off list at pete@lcsql.com if you would like to take advantage of this deal, and I will send you a link to buy it at that price.

SQLiteAdmin has been tested on OS X and Windows. I do not have access to Linux (yet!) but would be happy to compile a Linux standalone for anyone who would be willing to try it and give me feedback on what changes might be needed to make it a viable Linux product.

SQLiteAdmin is a full-featured administration tool for SQLite databases that removes all of the restrictions and omissions inherent in the standard SQLite Data Definition Language. You can safely add, modify, or delete any of the properties of a table or column including name, data type, data length, primary key, foreign key, check, unique, not null, and default constraints, all while maintaining the integrity of your data.

SQLiteAdmin extends the DDL even further with convenience features that provide you with the ability to add multiple columns that share the same properties with a single click, and optional automatic index creation for foreign key fields.

SQLiteAdmin provides complete data export and import capability in a number of formats including csv, delimited text files with your choice of delimiter, and SQL INSERT statements. You can export all or selected rows of a table. You can also export the CREATE statements necessary to build your database, with or without the INSERT statements to populate it.

With SQLiteAdmin's Utilities view, you will be able to audit your database, get recommendations for better performance, and modify any of your database's PRAGMA settings.

SQLiteAdmin's Browse view gives you access to the SQLite Data Manipulation Language. You can display data from any table with filtering capability on any columns in the table, select the columns you want to view and display them in your preferred sequence, all by "filling in the blanks" instead of writing any SQL statements. The Browse Tool also provides complete insert, duplicate, update and delete capabilities, including modification or deletion of multiple rows in one operation. And you can save your filter definitions, column selections, and sort sequence for later use.

If you need to write your own SQL statements, you can enter any SQLite command in SQLiteAdmin's SQL tool and execute it. SQL commands can be saved and recalled for later use.

SQliteAdmin includes full support for in memory databases and also provides the ability to save an in memory database as a permanent disk file.

A 30-day demo version of SQLiteAdmin is available at http://www.lcsql.com/products.html. Some functionality is disabled in the demo version.

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10053
Joined: Sat Apr 08, 2006 7:05 am
Contact:

Re: [ANN] SQLiteAdmin

Post by FourthWorld » Wed Apr 11, 2012 9:18 pm

I picked up a copy this morning, and it's quite a time-saver. Well done, Peter.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

KennyR
Posts: 256
Joined: Thu Jan 19, 2012 4:25 am

Re: [ANN] SQLiteAdmin

Post by KennyR » Fri Apr 13, 2012 1:52 pm

I grabbed a copy and love the interface....I think everyone who needs an easy DB creator should check it out! My only thing is, and maybe someone can help, is I don't quite understand how to implement the newly created database into LC. There is some good documentation in the help section regarding the actual program, but I can't seem to figure out how to utilize the database in my scrips....if anyone knows please let me know....

FourthWorld
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 10053
Joined: Sat Apr 08, 2006 7:05 am
Contact:

Re: [ANN] SQLiteAdmin

Post by FourthWorld » Fri Apr 13, 2012 2:36 pm

Kenny, check out the SQLite example in the IDE. It's a simple one, but quite effective for getting started.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn

townsend
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 430
Joined: Sun Feb 13, 2011 8:43 pm

Re: [ANN] SQLiteAdmin

Post by townsend » Fri Apr 13, 2012 4:31 pm

Looks great! And thanks for the discount.

But what's this LiquidSQL? What is it? Where is it?
Using controls from the LiquidSQL tools palette, you will eliminate a high percentage of the Livecode scripts and SQL Data Manipulation statements normally required to implement an application, thus freeing up your time to concentrate on the design and coding of the most complicated aspects of your application.

phaworth
Posts: 592
Joined: Thu Jun 11, 2009 9:51 pm

Re: [ANN] SQLiteAdmin

Post by phaworth » Fri Apr 13, 2012 6:17 pm

LiquidSQL? Patience, it will be worth the wait! Just take your application, pour some LiquidSQL on it, and you'll be up and running in no time.
Pete

townsend
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 430
Joined: Sun Feb 13, 2011 8:43 pm

Re: [ANN] SQLiteAdmin

Post by townsend » Mon Apr 23, 2012 10:57 pm

phaworth wrote:LiquidSQL? Patience, it will be worth the wait! Just take your application,
pour some LiquidSQL on it, and you'll be up and running in no time.
Pete
Sounds great! Could you give us some idea when this will be available?
Will this be a plug-in? Or a utility that generates code from a SQLite db file?

phaworth
Posts: 592
Joined: Thu Jun 11, 2009 9:51 pm

Re: [ANN] SQLiteAdmin

Post by phaworth » Mon Apr 23, 2012 11:31 pm

I'm hoping to begin beta testing by the end of this quarter.

There are basically two components to the product. A plugin which is a palette of preconfigured controls which will be linked to columns in your database tables, and a runtime library. As I get closer to beta testing, I plan to make a short video available of how it all works.

Pete

Post Reply