Sqlite support?

[expired user #2778]'s profile image [expired user #2778] posted 17 years ago in General Permalink
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's profile image ansgar posted 17 years ago Permalink
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.
[expired user #2778]'s profile image [expired user #2778] posted 17 years ago Permalink
Interesting. What specific functionality does Zeos provide?
ansgar's profile image ansgar posted 17 years ago Permalink
"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.
[expired user #2778]'s profile image [expired user #2778] posted 17 years ago Permalink
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's profile image ansgar posted 17 years ago Permalink
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.
[expired user #2778]'s profile image [expired user #2778] posted 17 years ago Permalink

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... :)
[expired user #5112]'s profile image [expired user #5112] posted 13 years ago Permalink
Are there any news on this?

An integration of SQLite would please me. I think it's possible with Zeos.
ansgar's profile image ansgar posted 13 years ago Permalink
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's profile image rspadim posted 9 years ago Permalink
+1 !
[expired user #8747]'s profile image [expired user #8747] posted 9 years ago Permalink
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's profile image baraniello posted 9 years ago Permalink
+1;

I often use mysql and sqlite; to use a single tool would be great.
Ti9eR's profile image Ti9eR posted 9 years ago Permalink
+1 , hope to surpport SQLite
[expired user #8858]'s profile image [expired user #8858] posted 9 years ago Permalink
+1 on SQLite Support! smile

I hate playing around with the Firefox plugin all the time...
[expired user #7651]'s profile image [expired user #7651] posted 9 years ago Permalink
+1 for SQLite Support
[expired user #9018]'s profile image [expired user #9018] posted 9 years ago Permalink
+1

SQLite is often used for web stuff, but all the graphical tools for it are complete crap.
[expired user #9032]'s profile image [expired user #9032] posted 9 years ago Permalink
+1 for SQLite Support
rustyx's profile image rustyx posted 9 years ago Permalink
+1 +2 +3 +4 +5 for SQLite support happy
[expired user #9020]'s profile image [expired user #9020] posted 9 years ago Permalink
+1+2+3+4+5+6 for SQLite support
Electrosa's profile image Electrosa posted 8 years ago Permalink
Up! :)
bean's profile image bean posted 8 years ago Permalink

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

[expired user #8934]'s profile image [expired user #8934] posted 8 years ago Permalink

+1 for SQLite

fbachofner's profile image fbachofner posted 8 years ago Permalink

Agreed!

+1 for SQLite

jfalch's profile image jfalch posted 8 years ago Permalink

will not happen.

rustyx's profile image rustyx posted 8 years ago Permalink

Why not?

[expired user #9613]'s profile image [expired user #9613] posted 7 years ago Permalink

Is there no plan for this?

ansgar's profile image ansgar posted 7 years ago Permalink

No plan for SQlite. Sorry.

zejur's profile image zejur posted 7 years ago Permalink

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's profile image baraniello posted 7 years ago Permalink

:)

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

jbrimble's profile image jbrimble posted 7 years ago Permalink

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

[expired user #10844]'s profile image [expired user #10844] posted 7 years ago Permalink

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's profile image holgerflick posted 7 years ago Permalink

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's profile image AKR posted 7 years ago Permalink

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.

[expired user #9484]'s profile image [expired user #9484] posted 7 years ago Permalink

+1

[expired user #11175]'s profile image [expired user #11175] posted 6 years ago Permalink

Hell, sorry but i will just pile on.

+1 (times a lot)

This would be great.

ansgar's profile image ansgar posted 6 years ago Permalink

Feel free to put some flesh into the ticket:

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

aikona's profile image aikona posted 6 years ago Permalink

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's profile image fbachofner posted 6 years ago Permalink

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's profile image ansgar posted 6 years ago Permalink

"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's profile image fbachofner posted 6 years ago Permalink

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's profile image jbrimble posted 6 years ago Permalink

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

ctrlbreak's profile image ctrlbreak posted 5 years ago Permalink

+1 million for SQLite support.

Also, you should accept Bitcoin donations so I can send some funds your way. Cheers!

HerrimanCoder's profile image HerrimanCoder posted 5 years ago Permalink

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.

1 attachment(s):
  • sqlite
AKR's profile image AKR posted 5 years ago Permalink

The main thing in desire of support SQLite in the HeidiSQL:

  1. All in one program.
  2. All the power and convenience of HeidiSQL to work with SQLite Therefore, I am still behind the implementation of support for SQLite into HeidiSQL.
ansgar's profile image ansgar posted 4 years ago Permalink

SQLite - done :)

baraniello's profile image baraniello posted 4 years ago Permalink

Great !

ctrlbreak's profile image ctrlbreak posted 4 years ago Permalink

Awwwww Yiiiissssss!!!! Thank you!

HerrimanCoder's profile image HerrimanCoder posted 4 years ago Permalink

Very cool!!

ctrlbreak's profile image ctrlbreak posted 4 years ago Permalink

Very deserving of a donation as well ;-) It would be super cool if you accepted Bitcoin (BTCPAY server - Cut out the middle-man), but alas, Paypal it is.

Cheers!

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