Recent

Author Topic: Database Desktop and SQLite  (Read 8751 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

  • Sr. Member
  • ****
  • Posts: 283
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: 672
    • 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) / Linux Mint (64 bit)
       Lazarus 3.2 FPC 3.2.2
       CodeTyphon 8.40 FPC 3.3.1

Leledumbo

  • Hero Member
  • *****
  • Posts: 8746
  • 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: 1634
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 2.0.10 'stable' (x64) unless specified otherwise...

chrnobel

  • Sr. Member
  • ****
  • Posts: 283
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: 143
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: 14204
  • Probably until I exterminate Putin.
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..
Specialize a type, not a var.

 

TinyPortal © 2005-2018