SQLite editor for OS X?

Databases
1

Hi,
Does anyone know of a good app to view and edit encrypted SQLite databases?
I am looking for something around $15, as I only use it very occasionally to check / edit the odd database columns etc - nothing more complex than that.

Thanks.

2

I use http://sourceforge.net/projects/sqlitebrowser/ because it was free.

3

Don’t think that supports encrypted SQLite databases :frowning:

4

I do not know about that actually.

5

Navicat Essentials is $20, but I am not sure if it supports encrypted databases. I have Navicat, Pro version or whatever it is called. There is not other database editor as far as I am concerned.

6

The problem is, it will definitely need to read encrypted databases too :frowning:
Thanks for the info though.

7

Right, you can check it out on their web site, they probably state somewhere if it does or doesn’t. I am not sure.

8

Oh dear - does not support encrypted databases :frowning:
Thanks anyway.

9

I just checked the help file for the regular SQLite version and it says it does support encrypted databases. Navicat is a little pricey, but it is just incredibly intuitive to use in my opinion. I tried a bunch of cheap and free ones and just didn’t like them. A DB editor is just one of those tools that are tough to do with out because you use them so much.

10

i use SQLiteManager from SQLabs since 2005. Just check and i see option to set the encryption and when i open the data file, it ask for password.

The price though is more than what you want.

11

Richard,
are you referring to SQLiteManager for OS X - 49 dollars?
Is that the version you have, and it can def open encrypted?

Merv,
Were you referring to Navicat for SQLite - Standard, for 99 dollars?

Thanks guys.

12

HI Richard,

yes… i am referring to SQLiteManager for $49. if you like to make sure, please PM me the link for data file and the password and see if i can open for you.

13

Thanks Richard - I will do that as soon as I get the chance. Much appreciated :slight_smile:

14

you are welcome

15

No, I just checked, I have the enterprise version. But I just looked at their comparison chart:

http://www.navicat.com/products/navicat-for-sqlite-feature-matrix

and it looks like the $20 essentials versions supports encrypted database connections.

16

Thats weird, I downloaded the Navicat for SQLite trial, and it couldn’t open my encrypted database file?

17

Navicat only supports AES-128 through wxSQLite3, not AES-256 or RC4.

Looks like SQLiteManager is the best solution or you could roll your own. It is a great learning experience.

18

Can you try this and tell me if it opens your encrypted db. MesaSQLite:
http://www.desertsandsoftware.com/download_DEMOS.php?file=MesaSQLite426.zip

19

http://www.sqlabs.com/sqlitemanager.php
Provides encryption supported by CubeSQL and SQLite

20

What I meant to write was : " … supported by cubeSQL (SQLite) and Xojo