* * *

Author Topic: Database Desktop and SQLite  (Read 5925 times)

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Database Desktop and SQLite
« 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,
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

chrnobel

  • Full Member
  • ***
  • Posts: 225
Re: Database Desktop and SQLite
« Reply #1 on: March 22, 2013, 01:59:22 pm »
Database Desktop??

Anyways, I do normally use the Firefox extension called SQLite Manager - imo it works quite good.

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Re: Database Desktop and SQLite
« Reply #2 on: March 22, 2013, 02:21:10 pm »
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 :)
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

JanRoza

  • Hero Member
  • *****
  • Posts: 500
    • http://www.silentwings.nl
Re: Database Desktop and SQLite
« Reply #3 on: March 22, 2013, 08:28:57 pm »
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
OS: Windows 10 (64 bit)
Laz: Lazarus 1.8.4 FPC 3.0.4 i386-win32-win32/win64

Leledumbo

  • Hero Member
  • *****
  • Posts: 7970
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: Database Desktop and SQLite
« Reply #4 on: March 22, 2013, 10:02:02 pm »
Quote
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.

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: Database Desktop and SQLite
« Reply #5 on: March 23, 2013, 06:55:17 am »
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)
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

eny

  • Hero Member
  • *****
  • Posts: 1583
Re: Database Desktop and SQLite
« Reply #6 on: March 23, 2013, 09:29:21 am »
SQLite administrator : http://sqliteadmin.orbmu2k.de/
Free.
All posts based on: Win10 (Win64); Lazarus 1.8.0 'stable' (#56594 win64) unless specified otherwise...

chrnobel

  • Full Member
  • ***
  • Posts: 225
Re: Database Desktop and SQLite
« Reply #7 on: March 23, 2013, 12:58:40 pm »
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.

TurboRascal

  • Hero Member
  • *****
  • Posts: 672
  • "Good sysadmin. Bad programmer."™
Re: Database Desktop and SQLite
« Reply #8 on: March 23, 2013, 11:43:21 pm »
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.
Regards, ArNy the Turbo Rascal
-
"The secret is to give them what they need, not what they want." - Scotty, STTNG:Relics

thierrybo

  • Full Member
  • ***
  • Posts: 122
Re: Database Desktop and SQLite
« Reply #9 on: October 27, 2018, 12:54:13 pm »
cross-platform (mac linux windows) :

http://sqlitebrowser.org/

Thaddy

  • Hero Member
  • *****
  • Posts: 7087
Re: Database Desktop and SQLite
« Reply #10 on: October 27, 2018, 01:00:33 pm »
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..
inline variables like in D10.3 are a bit like Brexit: if you are given the wrong information it sounds like a good idea. Every kid loves candy, but it makes you fat and your teeth will disappear.

 

Recent

Get Lazarus at SourceForge.net. Fast, secure and Free Open Source software downloads Open Hub project report for Lazarus