Sqlite support?
That said, any chance of supporting Sqlite? Sqlite is such an awesome tool, but there is nothing like HeidiSQL for it, and I would love to be able to use HeidiSQL for it. You are aware the Google Gears using Sqlite, so there's a good chance Sqlite databases will soon be landing on people's computers all over the world.
If I had Delphi skills, I'd add the support myself but sadly, I don't. :(
Have you see the C/C++ api for Sqlite? Are you familiar with Sqlite? It is fabulous; everything in one file and no server, just DLLs. I probably wouldn't be that hard to wire up a layer that allows you to call Zeos or Sqlite.
BTW, I'm just discussing architecture but I am in no way expecting you to do the work. What you've already done is amazing and appreciated. I'm just discussing what would be possible and how difficult it might be.
When I get my client billing to the point I have some surplus (over my mortgage and other expenses) I will definitely donate to the project. I will also be telling lots of people I know about it (over 300 at http://web.meetup.com/32) at the next appropriate forum.
I just found that Zeos seems to have support for SQLite. There is a "SQLite Administrator" which is based on Zeos too I think:
http://sqliteadmin.orbmu2k.de/
Maybe that helps you a bit.
Thanks a lot, Mike.
I just found that Zeos seems to have support for SQLite. There is a "SQLite Administrator" which is based on Zeos too I think:
http://sqliteadmin.orbmu2k.de/
Maybe that helps you a bit.
Yes, I know "SQLite Administrator" and it is no HeidiSQL!
(bonus points for knowing my obsure US policital reference... :)
Zeos was used in HeidiSQL up to mid of 2009 I think, I have written my own connection layer doing all stuff to be able to do just everything what I want with that layer. But I have recently implemented basic support for Microsoft SQL Server. I will have a look at SQLite too but that has no priority currently. See issue #1008.
As HeidiSQL seems to be written in Delphi, at least the only reason not to support it is "time". I can definitely understand the decision to rather focus on three common DBs and not dive into the flat-file world as it would require different dialogs or the usual "spread" to use server-focused dialogs for flat-file databases which always looks ugly...
Thus, I can understand the decision, however, I am honest that I need SQlite for my desktop apps all the time now as well.
Feel free to put some flesh into the ticket:
Hi Ansgar
Feel free to put some flesh into the ticket:
I don't have a loging for Github so I write my comment here
Delphi uses Firedac as data access library and Firedac supports SQLite . I just replaced all my INI files and Registry stuff with SQlite in all my Delphi software .
I just wonder why it took me so long ... Adding SQLite support to Heidi would be just the next logical step
Eric
Hi aikona / Eric
Your Firedac comment above is a potentially useful suggestion so I just excerpted your post to: https://github.com/HeidiSQL/HeidiSQL/issues/12
Hi Ansgar:
"Next logical step" would be more support for PostgreSQL and MSSQL, which are both quite incomplete yet.
Yes, that seems to make a lot of sense.
I wonder, however, whether the pain of dissimilar SQL implementation among all these products might be lessened by adopting a multi-backend data access library like Firedac.
I don't really know enough about these, but similar data access libraries make it much easier to target different DBs with PHP, for example (versus using something vendor-specific like MySQLi).
Jumping in late...I really like HeidiSQL and was previously frustrated by the quality of query tools available for SQLite. BUT a recent build of DB Browser for SQLite (I am running 3.11.99) has the option of a Dark Theme (plus customizable font colors), and it really is quite nice. It's still not in the same league as Heidi, but it is quite adequate for me at this point.
See attachment for my customized Dark Theme.
SQLite - done :)
Please login to leave a reply, or register at first.