Lazarus
Programming => Databases => Topic started by: TurboRascal on March 22, 2013, 01:26:51 pm
-
I expected Database Desktop to be able to edit databases, but it seems I've either misunderstood how it works, or it doesn't work right. Namely, I wanted to use it to edit a SQLite database, but although it shows the database schema, it doesn't allow editing anything; on the other hand, I can create a dictionary from that database and edit it, but that's not the database itself.
Please someone point me what I'm doing wrong and how can I edit the database. If it's not possible, please tell me some recommendations for a good SQLite management application. There are several out there, but I'm not sure which to choose, so if someone has some experience with it, please tell. So far I've written everything directly in SQL, but as the base goes more complex, I'd prefer to have a quicker and simpler way to edit it.
Thanks,
-
Database Desktop??
Anyways, I do normally use the Firefox extension called SQLite Manager - imo it works quite good.
-
Database Desktop??
The Lazarus Database Desktop...
Anyways, I do normally use the Firefox extension called SQLite Manager - imo it works quite good.
Hmmm... I've already heard it works good, however the fact it is a FF extension puts me off a bit :)
-
I think that what you are looking for is SQLite Expert Personal, it's free, it's complete and it's all you need.
You can find it at http://www.sqliteexpert.com/index.html (http://www.sqliteexpert.com/index.html)
-
I expected Database Desktop to be able to edit databases, but it seems I've either misunderstood how it works, or it doesn't work right
Seems so, the check mark doesn't seem to call ApplyUpdates. I'll dig in to the code, feel free to file a bugreport if you can't wait.
-
I expected Database Desktop to be able to edit databases, but it seems I've either misunderstood how it works, or it doesn't work right. Namely, I wanted to use it to edit a SQLite database,
Seems it does work with Firebird (at least the create table button etc can be clicked, haven't tested further0. Probably needs some additional metadata code for sqlite.
$(fpcdirectory)\packages\fcl-db\src\datadict\fpddsqlite3.pp
(see e.g. $(fpcdirectory)\packages\fcl-db\src\datadict\fpddfb.pp for how it's done in Firebird)
-
SQLite administrator : http://sqliteadmin.orbmu2k.de/
Free.
-
Hmmm... I've already heard it works good, however the fact it is a FF extension puts me off a bit :)
Yes, but it can actually work as a stand alone program by starting it as a XULrunner application.
-
Thank you for the replies!
So it seems Database Desktop should be able to modify sqlite databases? I guess I'll file a bugreport, and might also take a look a the code to try and see why it doesnt work right. I actually didn't know how it should work, since the "full" DBMS's have their own management apps, while sqlite doesn't, so I needed the DD...
In the meantime, I'll take a look at the other recommended apps. The two last mentioned ones might be of help now because I need this for a Windows based app, but in the long run they are not a solution for me because I mostly work on Linux. I need a crossplatform solution, and while the SQLite Manager does satisfy that request, I'd prefer to be able to use the Database Desktop.
-
cross-platform (mac linux windows) :
http://sqlitebrowser.org/
-
cross-platform (mac linux windows) :
http://sqlitebrowser.org/
Bit of nonsense to reply on this old thread and refer to a browser written in another language.
Currently the database browsers written in Object Pascal are a lot more mature and more capable..