Re: [sqlite] SQLite Tools

2009-08-25 Thread Mohit Sindhwani
BareFeet wrote:
> Hi Barton,
>
>   
>> I saw all the tools listed on the SQLite wiki.  I was hoping that I  
>> could solicit opinions on the various ones there to save me the time  
>> of trying all of them.
>> 
>
> I've tried several and posted a fairly detailed comparison at:
> http://www.tandb.com.au/sqlite/compare/?ml
>
>   
>>> is there a SQLite centric utility to do a wide range of admin tasks  
>>> and to elegantly document the data base structure?
>>>   
>
> What admin tasks exactly are you after?
also, what constitutes elegant documentation?

Cheers,
Mohit.
8/26/2009 | 12:27 PM.

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


Re: [sqlite] SQLite Tools

2009-08-25 Thread BareFeet
Hi Barton,

> I saw all the tools listed on the SQLite wiki.  I was hoping that I  
> could solicit opinions on the various ones there to save me the time  
> of trying all of them.

I've tried several and posted a fairly detailed comparison at:
http://www.tandb.com.au/sqlite/compare/?ml

>> is there a SQLite centric utility to do a wide range of admin tasks  
>> and to elegantly document the data base structure?

What admin tasks exactly are you after?

Tom
BareFeet

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


Re: [sqlite] SQLite Tools

2009-08-25 Thread Kit
2009/8/25 Barton Torbert :
> I am looking for one of two things.  The first thing would be a tool to  
> easily synchronize data and structure between SQLite and Access.   I want to 
> be able to do something in one system and have it exported to the other.
> Bart

http://www.sqlite.org/cvstrac/wiki?p=ConverterTools
-- 
Kit
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite Tools recommended: SQLite Manager

2009-08-25 Thread Barton Torbert
I use this tool now for basic data management.  But I am looking for a tool 
that will help with documentation.
 
Bart
 



From: sqlite-users-boun...@sqlite.org on behalf of J Glassy
Sent: Tue 8/25/2009 8:43 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite Tools recommended: SQLite Manager



Hello Barton,
 Here is one suggestion to try: SQL Manager.
 I use SQLite Manager (by Mrinal Kant
(http://sqlite-manager.googlecode.com <http://sqlite-manager.googlecode.com/> ) 
and find it extremely useful.
It is developed in Xulrunner, Gecko, thus runs only under
Mozilla/Firefox. That said, it runs essentially as a stand alone
application, and at v.0.5.1 is fairly robust and stable at this point.
There are only a few common features that SQLite Manager omits or
doesn't do well, but it is very dynamically managed and new features
do get implemented from time to time. Give it a try if you use
Firefox.

cheers,
Joe Glassy

On Tue, Aug 25, 2009 at 8:37 AM, Barton Torbert<btorb...@fbdover.com> wrote:
> I saw all the tools listed on the SQLite wiki.  I was hoping that I could 
> solicit opinions on the various ones there to save me the time of trying all 
> of them.
>
> Bart
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Kees Nuyt
> Sent: Tue 8/25/2009 8:28 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SQLite Tools
>
>
>
> On Tue, 25 Aug 2009 09:00:46 -0500, "Barton Torbert"
> <btorb...@fbdover.com> wrote:
>
>
>> Hello,
>>
>> I have just started to use SQLite and am looking for
>> tools to manage my databases with.
>>
>> Right now my development group is manually importing
>> our SQLite databases into Access so to use the latter
>> to document table relationships, create ERDs, etc.
>> This is the painful way to do this, so I am looking for
>> tools to make life easier.
>>
>> I am looking for one of two things.  The first thing
>> would be a tool to  easily synchronize data and
>> structure between SQLite and Access.   I want to be
>> able to do something in one system and have it exported
>> to the other.
>
> Perhaps an ODBC driver would help.
> http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
> http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
>
>> Otherwise, is there a SQLite centric utility to do a
>> wide range of admin tasks and to elegantly document the
>> data base structure?
>
> If there is, it should be listed here:
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> --
>  (  Kees Nuyt
>  )
> c[_]
> ___
> 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
>



--
---
Joseph Glassy
Lead Software Engineer (contractor)
NASA Measures (Freeze/Thaw),Rm CFC 424
College of Forestry and Conservation
Univ. Montana, Missoula, MT 59812
Tel: 406-243-6318 Cellular: 406-544-3315
and:
Research Analyst/Programmer
University of Montana NSF EPSCoR Program
Davidson Honors College Room 013
Missoula, MT 59812
um.gla...@gmail.com
Campus phone 243-6337   Cell(406) 544-3315
___
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] SQLite Tools recommended: SQLite Manager

2009-08-25 Thread J Glassy
Hello Barton,
 Here is one suggestion to try: SQL Manager.
 I use SQLite Manager (by Mrinal Kant
(http://sqlite-manager.googlecode.com) and find it extremely useful.
It is developed in Xulrunner, Gecko, thus runs only under
Mozilla/Firefox. That said, it runs essentially as a stand alone
application, and at v.0.5.1 is fairly robust and stable at this point.
There are only a few common features that SQLite Manager omits or
doesn't do well, but it is very dynamically managed and new features
do get implemented from time to time. Give it a try if you use
Firefox.

cheers,
Joe Glassy

On Tue, Aug 25, 2009 at 8:37 AM, Barton Torbert<btorb...@fbdover.com> wrote:
> I saw all the tools listed on the SQLite wiki.  I was hoping that I could 
> solicit opinions on the various ones there to save me the time of trying all 
> of them.
>
> Bart
>
>
> 
>
> From: sqlite-users-boun...@sqlite.org on behalf of Kees Nuyt
> Sent: Tue 8/25/2009 8:28 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] SQLite Tools
>
>
>
> On Tue, 25 Aug 2009 09:00:46 -0500, "Barton Torbert"
> <btorb...@fbdover.com> wrote:
>
>
>> Hello,
>>
>> I have just started to use SQLite and am looking for
>> tools to manage my databases with.
>>
>> Right now my development group is manually importing
>> our SQLite databases into Access so to use the latter
>> to document table relationships, create ERDs, etc.
>> This is the painful way to do this, so I am looking for
>> tools to make life easier.
>>
>> I am looking for one of two things.  The first thing
>> would be a tool to  easily synchronize data and
>> structure between SQLite and Access.   I want to be
>> able to do something in one system and have it exported
>> to the other.
>
> Perhaps an ODBC driver would help.
> http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
> http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
>
>> Otherwise, is there a SQLite centric utility to do a
>> wide range of admin tasks and to elegantly document the
>> data base structure?
>
> If there is, it should be listed here:
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> --
>  (  Kees Nuyt
>  )
> c[_]
> ___
> 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
>



-- 
---
Joseph Glassy
Lead Software Engineer (contractor)
NASA Measures (Freeze/Thaw),Rm CFC 424
College of Forestry and Conservation
Univ. Montana, Missoula, MT 59812
Tel: 406-243-6318 Cellular: 406-544-3315
and:
Research Analyst/Programmer
University of Montana NSF EPSCoR Program
Davidson Honors College Room 013
Missoula, MT 59812
um.gla...@gmail.com
Campus phone 243-6337   Cell(406) 544-3315
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] SQLite Tools

2009-08-25 Thread Barton Torbert
I saw all the tools listed on the SQLite wiki.  I was hoping that I could 
solicit opinions on the various ones there to save me the time of trying all of 
them.
 
Bart
 



From: sqlite-users-boun...@sqlite.org on behalf of Kees Nuyt
Sent: Tue 8/25/2009 8:28 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLite Tools



On Tue, 25 Aug 2009 09:00:46 -0500, "Barton Torbert"
<btorb...@fbdover.com> wrote:


> Hello,
>
> I have just started to use SQLite and am looking for
> tools to manage my databases with.
>
> Right now my development group is manually importing
> our SQLite databases into Access so to use the latter
> to document table relationships, create ERDs, etc.
> This is the painful way to do this, so I am looking for
> tools to make life easier.
>
> I am looking for one of two things.  The first thing
> would be a tool to  easily synchronize data and
> structure between SQLite and Access.   I want to be
> able to do something in one system and have it exported
> to the other.

Perhaps an ODBC driver would help.
http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

> Otherwise, is there a SQLite centric utility to do a
> wide range of admin tasks and to elegantly document the
> data base structure?

If there is, it should be listed here:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

--
  (  Kees Nuyt
  )
c[_]
___
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] SQLite Tools

2009-08-25 Thread Kees Nuyt
On Tue, 25 Aug 2009 09:00:46 -0500, "Barton Torbert"
 wrote:


> Hello,
> 
> I have just started to use SQLite and am looking for
> tools to manage my databases with.
> 
> Right now my development group is manually importing
> our SQLite databases into Access so to use the latter
> to document table relationships, create ERDs, etc.
> This is the painful way to do this, so I am looking for
> tools to make life easier.
> 
> I am looking for one of two things.  The first thing
> would be a tool to  easily synchronize data and
> structure between SQLite and Access.   I want to be
> able to do something in one system and have it exported
> to the other.

Perhaps an ODBC driver would help.
http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
 
> Otherwise, is there a SQLite centric utility to do a
> wide range of admin tasks and to elegantly document the
> data base structure?

If there is, it should be listed here:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
 
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users