Unfortunately I've got an error when opening our db (SQLite Root 1.9.7.4):
Traceback Info:
Traceback (most recent call last):
File "core.pyo", line 2731, in OnOpenDialogXOpenDb
KeyError: u'converter'
System Information:
Timestamp: 2012-03-05 11:47:17.465000
Operating System: Windows NT 6.1 (build 7601, Service Pack 1)
Python Version: 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32
bit (Intel)]
wxPython Version: 2.8.12.1 (msw-unicode)
wxPython Info: (__WXMSW__, wxMSW, unicode, wx-assertions-on, SWIG-1.3.29)
Python Encoding: Default=ascii File=mbcs
wxPython Encoding: cp1252
System Architecture: 32bit AMD64
Byte order: little
Frozen: windows_exe
I'm getting "file is encrypted or is not a database". But the database
was created using amalgated SQLite (3.7.9), compiled with VS2010:
// This was put on top of our sqlite3.c
#define SQLITE_DEFAULT_PAGE_SIZE 65536
#define SQLITE_MAX_DEFAULT_PAGE_SIZE 65536
#define SQLITE_THREADSAFE 0
#define SQLITE_DEFAULT_MEMSTATUS 0
#define SQLITE_OMIT_SHARED_CACHE 1
#define SQLITE_OMIT_DEPRECATED 1
#define SQLITE_OMIT_UTF16 1
--------------------------------------------------------
We have one more DB that is similar to the one above, but with lots of
TRIGGERS (thousands), and tables with thousand of columns.
That DB uses the .NET SQLIte (not sure which version).
It crashes SQLIte Root right away.
On 3/5/2012 5:50 AM, Rob Richardson wrote:
Our company typically uses SQLite Spy for managing SQLite databases. I keep
hoping to find something better, because SQLite Spy does not offer the ability
to edit a table inside a grid. The only way to update data is to use an SQL
UPDATE statement. But nothing else offers the speed of displaying data for a
decent-sized table. The table we most often have to show contains three
columns, and data taken once a minute and saved for thirty days.
I've seen a couple of announcements recently about SQLite Root, and it looks
like it may be worth trying next time I get a little time. But in the
meantime, I'm wondering what others think. Is it a good product?
RobR
-----Original Message-----
From: sqlite-users-bounces-czdrofg0bjidnm+yrof...@public.gmane.org
[mailto:sqlite-users-bounces-czdrofg0bjidnm+yrof...@public.gmane.org] On Behalf
Of Fabio Spadaro
Sent: Monday, March 05, 2012 3:51 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Sqlite Root also available for Linux
Announcement of the release Sqlite Root<http://www.sqliteroot.com/> now
available for Linux.
Any feedback is appreciated.
--
Fabio Spadaro
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
