distal-attribute
distal-attribute
distal-attribute
distal-attribute

Sqlite support?

User, date Message
Written by MikeSchinkel
7 years ago
Category: General
13 posts since Sat, 11 Aug 07
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. :(
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by MikeSchinkel
7 years ago
13 posts since Sat, 11 Aug 07
Interesting. What specific functionality does Zeos provide?
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
"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.
Written by MikeSchinkel
7 years ago
13 posts since Sat, 11 Aug 07
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.
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by MikeSchinkel
7 years ago
13 posts since Sat, 11 Aug 07

anse wrote: 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... :)
Written by MeisterLampe
3 years ago
2 posts since Mon, 23 Aug 10
Are there any news on this?

An integration of SQLite would please me. I think it's possible with Zeos.
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
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.
 

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