Sqlite GUI's

[guest2013-1]

Busy playing around with Sqlite and noticed the gui I'm using is bugged, on each open of the db and editing fields, the default field's I set, gets another single quote on it... making it invalid (especially for boolean)

Any free ones out there that does the trick nicely without any bugs or douche bags that can't read the last sentence of a post?

 

[DailyTech]

You need to elucute the muskies forsically.

 

[semaphore]

You need to elucute the muskies forsically.

Say What


Try Squirrel: http://www.squirrelsql.org/#installation

or sqlitebrowser.sourceforge.net/

 

[Vixremento]

How do you find the performance of SQLite?

I was asked to compare the performance of SQL server and MySQL - I was quite surprised at how much slower MySQL seemed to be (I created a simple app in C# that just executes a set of scripts from a file that I open - create table, insert into, drop table, etc.). Also only played with SQLite and the command-line statements but it seemed to be pretty quick...you think it's worth proposing as an alternative to MySQL/SQL Server? We want to have databases/files on local workstations that allow the users to work on disconnected (checked-out) data that can be synchronised (checked-in) when they get back onto the network.

 

[semaphore]

No you cannot use SQLLite as a server database, its most likely used for tiny compact local db's for applications. mysql/mssql are not that dissimilar. Oracle is still the best.

 

[Vixremento]

Just so expensive to use Oracle...unless there is a free local only version that I don't know about? We're looking for something fast that will be used in single-user mode only...once it syncs (we'll probably have to do that) we just insert/update/delete data in the MS SQL database server.

 

[semaphore]

You could use postgres that is also an awesome db

 

[Vixremento]

You could use postgres that is also an awesome db

Cool thanks - I'll try get an install up and running to see how it compares (as long as it has a driver we can use easily from .NET apps). Would be nice to just create our own binary data files but of course our company isn't too keen on us doing anything that can't be billed for el pronto.

 

[semaphore]

http://npgsql.projects.postgresql.org/

 

[guest2013-1]

semaphore, for a local database, for what is described, an offline version of the server database that will resync, I'd recommend sqlite.

 

[semaphore]

semaphore, for a local database, for what is described, an offline version of the server database that will resync, I'd recommend sqlite.

I would just use xml to be honest.

 

[guest2013-1]

+1 to dequadin. Using XML has it's function, but not on an occasionally connected scenario. Plus you don't have to then write specific code for working with XML or SQL, you'd use normal SQL, basically just the connection changes

 

[semaphore]

XML can bloat quite badly, not always a good solution. I've had good success with a SQL Compact (very similar to SQLite) - SQL Server combination for a occasionally connected scenarios.

Obviously decisions like this are totally dependent on each situation

The consensus I'm getting from StackOverflow is that using XML as a database is a bad idea

Yes thats fair, but when its going to be minor check-ins. Do really want to have another linked dependency to the software. Also for this particular scenario the xml files can be dumped once they have been successfully committed to the central db.