Frontend to SQL Lite..

Tim_Lee · July 17, 2019, 10:14pm

Hi Folks.
I’m wondering what everyone uses for a FE to SQL lite? I realize of course we can use code, but I want to develop as if I’m using a Database manager. Then, use xojo to do crud operations with it’s data tools.
Any good FE’s for SQL lite?
Thanks
Tim

DaveS · July 17, 2019, 10:17pm

Personally I love TADPOLE (full disclosure, I am the author as well)

http://www.rdS.com/tadpole/

anon93744516 · July 17, 2019, 10:35pm

SQLiteManager is very good (also built using Xojo, I believe).

DataGrip from JetBrains also connects to SQLite.

I use both. Hope that helps.

James_Dooley · July 17, 2019, 11:29pm

[quote=445663:@Scott Cadillac]SQLiteManager is very good (also built using Xojo, I believe).

DataGrip from JetBrains also connects to SQLite.

I use both. Hope that helps.[/quote]

Same here.

Markus_Winter · July 18, 2019, 2:14am

[quote=445661:@Dave S]Personally I love TADPOLE (full disclosure, I am the author as well)
http://www.rdS.com/tadpole/[/quote]

That the website isnt functional after over half a year is not a good first impression (and I seriously dislike that green duckfrog). Come on, Dave, you can get the basics (informative text with a few screenshots) done in a few hours, so get cracking

Hans-Norbert_Gratzal · July 18, 2019, 4:51am

DataGrip

@Dave
Even not much on the page, I like the clean and smart style!

Tomas_J · July 18, 2019, 5:49am

Navicat… one crossplatform tool to rule them all…

Richard_Duke · July 18, 2019, 7:05am

use it for the last 14 years

Steve_Wilson · July 18, 2019, 7:08am

SQLiteStudio

Jean-Yves_Pochez · July 18, 2019, 7:29am

make your own, you will learn a lot, and it will exactly fit your needs.

Horst_Jehle · July 18, 2019, 7:58am

Open Source:
https://sqlitebrowser.org/

To pay:
MesaSQLite

Wayne_Golding · July 18, 2019, 9:03am

@Dave S did this for you, but @Jean-Yves Pochez makes a point.

Emile_Schwarz · July 18, 2019, 9:23am

and Jean-Luc is not alone doing so

Tomas_J · July 18, 2019, 9:39am

@Jean-Yves Pochez this music list makes you more likeable, at least for me

Jean-Yves_Pochez · July 18, 2019, 10:08am

you’re talking about the music content or the user interface ?

music content is not mine, it’s the chinook database …

John_A_Knight_Jr · July 19, 2019, 4:22am

You will need a Xojo based front end if you need to access Xojo encrypted databases.
It is not compatible with the open source SQLCipher encryption.

Richard_Duke · July 19, 2019, 7:18am

[quote=445893:@John A Knight, Jr]You will need a Xojo based front end if you need to access Xojo encrypted databases.
It is not compatible with the open source SQLCipher encryption.[/quote]

SQLiteManager from SQLabs can handle xojo encrypted db

DaveS · July 19, 2019, 2:15pm

[quote=445893:@John A Knight, Jr]You will need a Xojo based front end if you need to access Xojo encrypted databases.
It is not compatible with the open source SQLCipher encryption.[/quote]
So can Tadpole

Tim_Lee · July 19, 2019, 9:12pm

Thanks everyone. Now I’ll have to try each of them and see what I like best…
Thanks again. You folks rock.
Tim

Tim_Lee · July 19, 2019, 9:18pm

Dave,
Thanks for the link. Is it freeware or ? I just downloaded it, but didn’t see any info? Thanks in advance.
Tim

[quote=445661:@Dave S]Personally I love TADPOLE (full disclosure, I am the author as well)

http://www.rdS.com/tadpole/[/quote]