Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLite support #12

Open
the-liquid-metal opened this issue Nov 18, 2017 · 11 comments
Open

SQLite support #12

the-liquid-metal opened this issue Nov 18, 2017 · 11 comments
Labels

Comments

@the-liquid-metal
Copy link

@the-liquid-metal the-liquid-metal commented Nov 18, 2017

Expected behavior

I would like to see HeidiSQL handle sqlite seamlessly like already supported db.

Current behavior

currently, HeidiSQL can't handle SQLite at all.

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Nov 26, 2017

Does SQLite have some SQL API? If not, then HeidiSQL might be the wrong client for it, as everything is based on SQL here. Also, I need a 32bit + 64bit Windows library/dll to support it. Probably you can put some stuff here to get started here.

@tomasfejfar

This comment has been minimized.

Copy link

@tomasfejfar tomasfejfar commented Dec 25, 2017

I'm not sure about what you're asking. There is C API to SQLite - usually, you bundle the DLL (http://www.sqlite.org/download.html) and use it from your code. Then you can connect (https://sqlite.org/capi3ref.html#sqlite3_open) and call SQL as you would with MySQL or any other RDBMS if I understand it correctly. (pardon me if I'm totally off, as I've never developed desktop apps seriously - only playing with buttons and alerts :D)

@UweRupprecht

This comment has been minimized.

Copy link

@UweRupprecht UweRupprecht commented Jan 16, 2018

I worked with sqlite3 with delphi (using directly the API and also using ZEOS). So theres should be not that big problem on integrate it to HeidiSQL. Precompiled dll's are available at sqlite.org :)

I think this will be a greate advance for Heidi, cause a lot of developers use sqlite, as you do not need to
setup and install a whole serversoftware. You can just use the dll :)

@igitur

This comment has been minimized.

Copy link
Contributor

@igitur igitur commented Jan 22, 2018

Slightly off-topic question: I understand that ZeosLib was long ago, but then removed. Am I right? And why was that decision taken?

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

@ansgarbecker ansgarbecker commented Jan 22, 2018

Yes, very early versions of HeidiSQL made use of ZeosLib until I removed that in Sep 2009 in e2674ca. There were quite a few features I could not implement with Zeos, so I decided to write my own, more lightweight abstraction layer, which was added in 12a8e2e.

@rentalhost

This comment has been minimized.

Copy link
Collaborator

@rentalhost rentalhost commented Feb 12, 2018

About the SQL API support, I think that it is available here in C/C++. But I don't have sure if it is compatible with Delphi.

The biggest problem with SQLite is that it have a lot of database limitations like, for instance, do not support ALTER TABLE. Which imples to the need to create a new temp table with the "final state" of modifications, query old table with the existing columns, copy to new table, remove old table and rename new.

So if you intends to implements a SQLite support (and I really hope that you do that), maybe you should create a secret option to enable it while it is developed, once that it will cause a lot of bugs on initial development.

@UweRupprecht

This comment has been minimized.

Copy link

@UweRupprecht UweRupprecht commented Feb 13, 2018

Yes, the ALTER TABLE statement is very limited. As you said, you can work around this limitationl, so this should not be that big deal :)

@dcanoh

This comment has been minimized.

Copy link

@dcanoh dcanoh commented Apr 29, 2018

Hi, Egmond.
I am also interested in SQLite with HeidiSQL.
I would like to hear from you some kind of proposal for me to help to incorporate this support.
I can share some info about your questions:

Does SQLite have some SQL API? .... as everything is based on SQL here. 
.... 32bit + 64bit Windows library/dll to support it. 
.... some stuff here to get started .....

Tell me how we can proceed.

You can find me in cano.hernan, in gmail.

HERNAN CANO M
Systems Analyst

@penCsharpener

This comment has been minimized.

Copy link

@penCsharpener penCsharpener commented Apr 29, 2018

I'm using the DB Browser for SQLite which does a good job but the HeidiSQL UI is better so if it was possible to support SQLite, that would be great.

@FBachofner

This comment has been minimized.

Copy link

@FBachofner FBachofner commented May 3, 2018

HeidiSQL forum poster aikona (Eric) doesn't have a Github account but made a useful post which I am excerpting here to help move forward the conversation.

"Delphi uses Firedac as data access library and Firedac supports SQLite."

It seems considering adopting this library (if not already the case) could help with bringing SQLite support to HeidiSQL . . .

@erdincgc

This comment has been minimized.

Copy link

@erdincgc erdincgc commented Nov 9, 2019

We all waiting for the great HeidiSQL's Sqlite support :) ... It will come true one day :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
10 participants
You can’t perform that action at this time.