Sqlite support?

MikeSchinkel posted 11 years ago in General
HeidiSQL is awesome, as good as commercial tools. Great job!

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. :(
ansgar posted 11 years ago
Depends on the underlying database layer in HeidiSQL which is ZeosDBO currently. Zeos neither supports SQLite nor PostgreSQL as far as I know. If we find a well functioning replacement for Zeos which can handle more DBMS we probably switch to that.
MikeSchinkel posted 11 years ago
Interesting. What specific functionality does Zeos provide?
ansgar posted 11 years ago
"Zeos DataBase Objects" is the "backend interface" to MySQL for HeidiSQL. It provides functionalities to connect to mysql servers, send queries and so on. It uses the C-API of MySQL. It's Opensource and GPL-licensed like HeidiSQL itself.
MikeSchinkel posted 11 years ago
Thanks for the explanation.

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.
ansgar posted 11 years ago
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.
MikeSchinkel posted 11 years ago

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... :)
MeisterLampe posted 7 years ago
Are there any news on this?

An integration of SQLite would please me. I think it's possible with Zeos.
ansgar posted 7 years ago
Hey this post is more than 3 years old.

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.
rspadim posted 4 years ago
+1 !
ialopezg posted 3 years ago
I'm still awaiting for...

SQLite let me collect information from devices making some sync operations. But I have give support and maintenance to these database into the devices.

Thanks for all job do it. It's great!!!
baraniello posted 3 years ago
+1;

I often use mysql and sqlite; to use a single tool would be great.
Ti9eR posted 3 years ago
+1 , hope to surpport SQLite
PLP.GTR posted 3 years ago
+1 on SQLite Support! smile

I hate playing around with the Firefox plugin all the time...
maflorezp posted 3 years ago
+1 for SQLite Support
user23424 posted 3 years ago
+1

SQLite is often used for web stuff, but all the graphical tools for it are complete crap.
b3wii posted 3 years ago
+1 for SQLite Support
rustyx posted 3 years ago
+1 +2 +3 +4 +5 for SQLite support happy
softwareguy74 posted 3 years ago
+1+2+3+4+5+6 for SQLite support
Electrosa posted 3 years ago
Up! :)
bean posted 3 years ago

Has SQLite support been added? If so do any of you know how to open one of the .db files using HeidiSLQ?

mikemvpi posted 3 years ago

+1 for SQLite

fbachofner posted 3 years ago

Agreed!

+1 for SQLite

jfalch posted 3 years ago

will not happen.

rustyx posted 3 years ago

Why not?

Cronus posted 2 years ago

Is there no plan for this?

ansgar posted 2 years ago

No plan for SQlite. Sorry.

zejur posted 2 years ago

No plan for SQlite. Sorry.

I've been following this post almost nine years for now, and still patiently awaiting for sqlite support :)

Maybe next year?

baraniello posted 2 years ago

:)

for just two years but i will wait with zejur...

jbrimble posted 1 year ago

Please consider adding SQLite support some day, Ansgar. HeidiSQL is a fantastic tool, and SQLite is becoming increasingly popular.

fork posted 1 year ago

SQLite Studio is an excellent GUI tool for managing SQLite databases, no urgent need to have it in HeidiSQL.

  • Cross-Platform
  • Nice lean GUI
  • Does its job very well

Have a look at sqlitestudio.pl (I may not post the link yet)

holgerflick posted 1 year ago

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.

AKR posted 1 year ago

ZeosLib now supports MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle and SQLite (sourceforge.net/projects/zeoslib). Maybe worth a try support SQLite? That would be very useful.

become posted 1 year ago

+1

maxsnts posted 7 months ago

Hell, sorry but i will just pile on.

+1 (times a lot)

This would be great.

ansgar posted 7 months ago

Feel free to put some flesh into the ticket:

https://github.com/HeidiSQL/HeidiSQL/issues/12

aikona posted 4 months ago

Hi Ansgar

Feel free to put some flesh into the ticket:

https://github.com/HeidiSQL/HeidiSQL/issues/12

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

fbachofner posted 4 months ago

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

ansgar posted 4 months ago

"Next logical step" would be more support for PostgreSQL and MSSQL, which are both quite incomplete yet. Just ask the people who use it. HeidiSQL is far behind with their features.

fbachofner posted 4 months ago

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).

jbrimble posted 4 months ago

Have you ever considered a paid version and getting another dev to write a plugin?

Please login to leave a reply, or register at first.