Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Sqlite support?

MikeSchinkel's profile image MikeSchinkel posted 12 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's profile image ansgar posted 12 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's profile image MikeSchinkel posted 12 years ago
Interesting. What specific functionality does Zeos provide?


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
ansgar's profile image ansgar posted 12 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's profile image MikeSchinkel posted 12 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's profile image ansgar posted 12 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's profile image MikeSchinkel posted 12 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's profile image MeisterLampe posted 8 years ago
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 8 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's profile image rspadim posted 5 years ago
+1 !


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
ialopezg's profile image ialopezg posted 5 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's profile image baraniello posted 4 years ago
+1;

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

I hate playing around with the Firefox plugin all the time...
maflorezp's profile image maflorezp posted 4 years ago
+1 for SQLite Support
user23424's profile image user23424 posted 4 years ago
+1

SQLite is often used for web stuff, but all the graphical tools for it are complete crap.
b3wii's profile image b3wii posted 4 years ago
+1 for SQLite Support
rustyx's profile image rustyx posted 4 years ago
+1 +2 +3 +4 +5 for SQLite support happy
softwareguy74's profile image softwareguy74 posted 4 years ago
+1+2+3+4+5+6 for SQLite support
Electrosa's profile image Electrosa posted 4 years ago
Up! :)
bean's profile image bean posted 4 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's profile image mikemvpi posted 4 years ago

+1 for SQLite

fbachofner's profile image fbachofner posted 4 years ago

Agreed!

+1 for SQLite

jfalch's profile image jfalch posted 4 years ago

will not happen.

rustyx's profile image rustyx posted 4 years ago

Why not?

Cronus's profile image Cronus posted 3 years ago

Is there no plan for this?

ansgar's profile image ansgar posted 3 years ago

No plan for SQlite. Sorry.

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

:)

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

jbrimble's profile image jbrimble posted 2 years ago

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

fork's profile image fork posted 2 years 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's profile image holgerflick posted 2 years 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's profile image AKR posted 2 years 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's profile image become posted 2 years ago

+1

maxsnts's profile image maxsnts posted 2 years ago

Hell, sorry but i will just pile on.

+1 (times a lot)

This would be great.

ansgar's profile image ansgar posted 2 years ago

Feel free to put some flesh into the ticket:

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

aikona's profile image aikona posted 1 year 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's profile image fbachofner posted 1 year 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's profile image ansgar posted 1 year 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's profile image fbachofner posted 1 year 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's profile image jbrimble posted 1 year ago

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

ctrlbreak's profile image ctrlbreak posted 6 months ago

+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 months ago

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 months ago

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.

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