Re: [sqlite] What do people think of SQLite Root?

[Don V Nielsen]

Thumbs up on SqliteExpert.  I use it too.  Very nice.

dvn

On Tue, Mar 6, 2012 at 7:20 PM, Stephen Chrzanowski wrote:

> I use SQLite Expert.  There is a fee for the professional version, but it
> is one time, all updates are free.
>
> http://www.sqliteexpert.com/
>
>
> On Tue, Mar 6, 2012 at 1:43 PM, Fabio Spadaro  >wrote:
>
> > Hi.
> >
> > Il giorno 06 marzo 2012 17:31, Kit  ha scritto:
> >
> > > > Announcement of the release Sqlite Root 
> > >  now available for Linux.
> > > > Any feedback is appreciated.
> > > > Fabio Spadaro
> > >
> > > Two big problems:
> > > - license
> > > - size
> > >
> > > This software is unusable for me.
> > > --
> > > Kit
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> >
> > What do you mean by "size".
> >
> > --
> > Fabio Spadaro
> >
> > Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
> > www.sqliteroot.com
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Stephen Chrzanowski]

I use SQLite Expert.  There is a fee for the professional version, but it
is one time, all updates are free.

http://www.sqliteexpert.com/


On Tue, Mar 6, 2012 at 1:43 PM, Fabio Spadaro wrote:

> Hi.
>
> Il giorno 06 marzo 2012 17:31, Kit  ha scritto:
>
> > > Announcement of the release Sqlite Root 
> >  now available for Linux.
> > > Any feedback is appreciated.
> > > Fabio Spadaro
> >
> > Two big problems:
> > - license
> > - size
> >
> > This software is unusable for me.
> > --
> > Kit
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
> What do you mean by "size".
>
> --
> Fabio Spadaro
>
> Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
> www.sqliteroot.com
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Fabio Spadaro]

Hi.

Il giorno 06 marzo 2012 17:31, Kit  ha scritto:

> > Announcement of the release Sqlite Root 
>  now available for Linux.
> > Any feedback is appreciated.
> > Fabio Spadaro
>
> Two big problems:
> - license
> - size
>
> This software is unusable for me.
> --
> Kit
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>

What do you mean by "size".

-- 
Fabio Spadaro

Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
www.sqliteroot.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Kit]

> Announcement of the release Sqlite Root   now 
> available for Linux.
> Any feedback is appreciated.
> Fabio Spadaro

Two big problems:
- license
- size

This software is unusable for me.
-- 
Kit
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[John Drescher]

> Download the latest version Sqlite Root 1.9.7.6 
>

BTW, if you press Help then log in windows 7 using that version I get
a crash as well.



Traceback Info:
Traceback (most recent call last):
  File "core.pyo", line 2481, in actionLog
  File "framelog.pyo", line 99, in addTextFromLog
  File "codecs.pyo", line 881, in open
IOError: [Errno 2] No such file or directory: 'main.log'

System Information:
Timestamp: 2012-03-06 11:15:51.424000
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

John
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Fabio Spadaro]

Hi.

Il giorno 05 marzo 2012 20:50, Dimiter 'malkia' Stanev
ha scritto:

>
>
> 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+yROfE0A@public.**gmane.org[mailto:
>> sqlite-users-bounces-**CzDROfG0BjIdnm+yROfE0A@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>
>>   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
>

Download the latest version Sqlite Root 1.9.7.6 

-- 
Fabio Spadaro

Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
www.sqliteroot.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Ralf Junker]

On 05.03.2012 18:45, Rob Richardson wrote:

> I can't get to www.yunqa.de now.  I tried in IE8 and FireFox.

Most strange. Luckily, search engines find plenty of SQLiteSpy download
alternatives. Here is one of the more well known ones:

http://www.softpedia.com/get/Internet/Servers/Database-Utils/SQLiteSpy.shtml

Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Rob Richardson]

We're running 1.5.5.  We don't keep up with updates very well.  We're lucky 
we're not using MS Visual Studio 6 any more.  We're up to 2008!  Woohoo!

I can't get to www.yunqa.de now.  I tried in IE8 and FireFox.

RobR


-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Ralf Junker
Sent: Monday, March 05, 2012 10:37 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What do people think of SQLite Root?

On 05.03.2012 16:11, Rob Richardson wrote:

> With the latest version, I think you can.

SQLiteSpy grid editing has been around for years, it is available since version 
1.6.0., 7 Feb 2007.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Ralf Junker]

On 05.03.2012 16:11, Rob Richardson wrote:

> With the latest version, I think you can.

SQLiteSpy grid editing has been around for years, it is available since
version 1.6.0., 7 Feb 2007.

> But I haven't been able to get the latest version.  The link you
> provided does not work for me. Do you know any site other than
> yunqa.de where the latest SQLite can be downloaded?

SQLiteSpy downloads might be available from various portals. But usually
http://www.yunqa.de works just fine. Just try again later.

Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Rob Richardson]

With the latest version, I think you can.  But I haven't been able to get the 
latest version.  The link you provided does not work for me.  Do you know any 
site other than yunqa.de where the latest SQLite can be downloaded?

RobR

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of Ralf Junker
Sent: Monday, March 05, 2012 9:48 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] What do people think of SQLite Root?

On 05.03.2012 14:50, Rob Richardson wrote:

> I keep hoping to find something better, because SQLiteSpy does not 
> offer the ability to edit a table inside a grid.

Not quite true. SQLiteSpy can edit table cells inside a grid.

Double-click the table-icon in the schema treeview to display the table.
When you then select a table cell in the grid and press F2, the edit window 
will pop up.

See feature item 2 and the screenshot at 
http://yunqa.de/delphi/doku.php/products/sqlitespy/index

Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Bart Smissaert]

On 3/5/12, Fabio Spadaro  wrote:
> Hi.
> Il giorno 05 marzo 2012 14:50, Rob Richardson  ha
> scritto:
>
>> ... I keep hoping to find something better, because SQLite Spy does not
>> offer the ability to edit a table inside a grid ...
>> RobR
>>
>
> With sqlite root is possbile to edit the table inside a grid and foreign
> keys.
> --
> Fabio Spadaro
>
> Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
> www.sqliteroot.com
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Fabio Spadaro]

Hi.
Il giorno 05 marzo 2012 14:50, Rob Richardson  ha
scritto:

> ... I keep hoping to find something better, because SQLite Spy does not
> offer the ability to edit a table inside a grid ...
> RobR
>

With sqlite root is possbile to edit the table inside a grid and foreign
keys.
-- 
Fabio Spadaro

Try Sqlite Root a GUI Admin Tools for manage Sqlite Database:
www.sqliteroot.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Ralf Junker]

On 05.03.2012 14:50, Rob Richardson wrote:

> I keep hoping to find something better, because SQLiteSpy does not
> offer the ability to edit a table inside a grid.

Not quite true. SQLiteSpy can edit table cells inside a grid.

Double-click the table-icon in the schema treeview to display the table.
When you then select a table cell in the grid and press F2, the edit
window will pop up.

See feature item 2 and the screenshot at
http://yunqa.de/delphi/doku.php/products/sqlitespy/index

Ralf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What do people think of SQLite Root?

[Jean-Denis MUYS]

On 5 mars 2012, at 14:50, 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

I use MesaSQLite, which I find nice enough 
(http://www.desertsandsoftware.com/?realmesa_home)

Regards,

Jean-Denis

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] What do people think of SQLite Root?

[Rob Richardson]

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-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.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   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