Re: [sqlite] GUI for SQLite

[jorje]

RSmith wrote
> Well you need to "buy" a $0.00 registration key, for which you need to
> fill in an inordinate amount of personal and contact 
> information (just like buying other things online). The sort of event that
> promises Inbox spam aplenty and is too much hassle for 
> most casual onlookers - but it does promise some sort of interoperability
> between SQLite and MySQL etc.
> (Haven't used it, so just mentioning what it claims).
> 
> 
> On 2013/06/26 17:34, Paolo Bolzoni wrote:
>> So... no? It is gratis, but not open. thanks.
>>
>> On Wed, Jun 26, 2013 at 5:28 PM, Michael Black 

> mdblack98@

>  wrote:
>>> Free doesn't necessarily mean open source
>>>
> 
> ___
> sqlite-users mailing list

> sqlite-users@

> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


 Actually if to install vstudio and start, it offers dialog register.
I was asked only for name and email. In less of minute I have got letters
with serials.

IF you very worry about own security/spam you always can use nospam service
and provide some fake name.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/GUI-for-SQLite-tp11673p69800.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite (nobre)

[jorje]

 Hi Joe,

It works quite good for me. It can be installed even from Mac App Store
here:
https://itunes.apple.com/us/app/valentina-studio/id604825918?ls=1=12 

BTW, you can look how it looks on Mac on this video:
http://www.youtube.com/watch?v=1wAd1IrwKAs 

Although something should be improved yet. For example, it not reacts on
horizontal scroll on trackpad. As I have hear they going switch to QT very
soon, and this should resolve such mac issues.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/Re-GUI-for-SQLite-nobre-tp69784p69799.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite (nobre)

[joe.fis...@tanguaylab.com]

SQLite Expert (Windows) is good and I've been using it for the last 2 
years but unfortunately it only does (Windows).

Although, it also runs good in WINE on Linux.
I've recently started using Valentina Studio (Linux/Windows/Mac) because 
I need to also run on native Linux, and if I get rich I'll buy a Mac.

Could someone report back any feedback on how it runs under Mac?
http://www.valentina-db.com/en/all-downloads


Joe Fisher
Oregon State University

---
Subject: Re: [sqlite] GUI for SQLite
Message-ID: <1372448971371-69729.p...@n5.nabble.com>
Content-Type: text/plain; charset=us-ascii
I've been impressed by sqliteexpert Personal Edition (for Windows)
I haven't found a great one for OSX yet.
-

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

Re: [sqlite] GUI for SQLite

[nobre]

I've been impressed by sqliteexpert Personal Edition (for Windows)
I haven't found a great one for OSX yet.



--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/GUI-for-SQLite-tp11673p69729.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite

[Ben]

That first link is *well* out of date and the second only compares three 
editors. I don't believe there is a comprehensive comparison anywhere right now.

- Ben


On 26 Jun 2013, at 17:46, "Rose, John B" <jbr...@utk.edu> wrote:

> fyi
> 
> http://www.barefeetware.com/sqlite/compare/?ml/
> 
> http://devtest.ws.utk.edu/tutorials/sqlite/gui/
> 
> ____
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
> behalf of Rob Richardson [rdrichard...@rad-con.com]
> Sent: Wednesday, June 26, 2013 12:40 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] GUI for SQLite
> 
> Not all of us.  Thanks for the list.
> 
> RobR, SQLiteSpy user and about to find Navicat.
> 
> ___
> 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] GUI for SQLite

[Rose, John B]

fyi

http://www.barefeetware.com/sqlite/compare/?ml/

http://devtest.ws.utk.edu/tutorials/sqlite/gui/


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Rob Richardson [rdrichard...@rad-con.com]
Sent: Wednesday, June 26, 2013 12:40 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] GUI for SQLite

Not all of us.  Thanks for the list.

RobR, SQLiteSpy user and about to find Navicat.

___
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] GUI for SQLite

[Rob Richardson]

Not all of us.  Thanks for the list.

RobR, SQLiteSpy user and about to find Navicat.

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

Re: [sqlite] GUI for SQLite

[Rose, John B]

We have tried Firefox SQLite Manager, SQLite DB Browser and Navicat. 

They all seem fine and Navicat seems good as a paid option with more features 
than the other two.


From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on 
behalf of Rob Willett [rob.sql...@robertwillett.com]
Sent: Wednesday, June 26, 2013 11:49 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] GUI for SQLite

Well I just simply downloaded my free copy from the Apple App store. I entered 
absolutely zero information (apart from Apple knowing everything about men 
anyway). Can't say I've been plagued by spam from other vendors who have 
provided free downloads but there's a first time for everything.

It looks a very interesting product, it seems to do an awful lot (to my wholly 
untutored ignorant eye) and hasn't crashed in the last ten minutes. I like the 
ER diagrams you can make with it.

I'm not complaining and if I like it enough I might even buy the Pro version if 
I need the functionality.

BTW just for forms sake, I have zero connections with this company and until I 
saw this e-mail didn't even know this product existed.

Rob.

On 26 Jun 2013, at 16:42, RSmith <rsm...@rsweb.co.za> wrote:

> Well you need to "buy" a $0.00 registration key, for which you need to fill 
> in an inordinate amount of personal and contact information (just like buying 
> other things online). The sort of event that promises Inbox spam aplenty and 
> is too much hassle for most casual onlookers - but it does promise some sort 
> of interoperability between SQLite and MySQL etc.
> (Haven't used it, so just mentioning what it claims).
>
>
> On 2013/06/26 17:34, Paolo Bolzoni wrote:
>> So... no? It is gratis, but not open. thanks.
>>
>> On Wed, Jun 26, 2013 at 5:28 PM, Michael Black <mdblac...@yahoo.com> wrote:
>>> Free doesn't necessarily mean open source
>>>
>
> ___
> 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] GUI for SQLite

[Simon Slavin]

On 26 Jun 2013, at 4:42pm, RSmith  wrote:

> Well you need to "buy" a $0.00 registration key, for which you need to fill 
> in an inordinate amount of personal and contact information (just like buying 
> other things online). The sort of event that promises Inbox spam aplenty and 
> is too much hassle for most casual onlookers - but it does promise some sort 
> of interoperability between SQLite and MySQL etc.
> (Haven't used it, so just mentioning what it claims).

Unlike many of you I have a job which pays me money.  I can afford to buy 
stuff.  I would sooner just give someone five clams for something than give 
them (tacit) permission to use my email address for anything at all.  
Unfortunately, the systems that accept money from you tend to want your email 
address too, so they can send you a receipt.  And that has stopped me from 
buying stuff from some suppliers because again I’m unwilling to give them my 
email address.

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

Re: [sqlite] GUI for SQLite

[Rob Willett]

Well I just simply downloaded my free copy from the Apple App store. I entered 
absolutely zero information (apart from Apple knowing everything about men 
anyway). Can't say I've been plagued by spam from other vendors who have 
provided free downloads but there's a first time for everything.

It looks a very interesting product, it seems to do an awful lot (to my wholly 
untutored ignorant eye) and hasn't crashed in the last ten minutes. I like the 
ER diagrams you can make with it.

I'm not complaining and if I like it enough I might even buy the Pro version if 
I need the functionality. 

BTW just for forms sake, I have zero connections with this company and until I 
saw this e-mail didn't even know this product existed.

Rob.

On 26 Jun 2013, at 16:42, RSmith  wrote:

> Well you need to "buy" a $0.00 registration key, for which you need to fill 
> in an inordinate amount of personal and contact information (just like buying 
> other things online). The sort of event that promises Inbox spam aplenty and 
> is too much hassle for most casual onlookers - but it does promise some sort 
> of interoperability between SQLite and MySQL etc.
> (Haven't used it, so just mentioning what it claims).
> 
> 
> On 2013/06/26 17:34, Paolo Bolzoni wrote:
>> So... no? It is gratis, but not open. thanks.
>> 
>> On Wed, Jun 26, 2013 at 5:28 PM, Michael Black  wrote:
>>> Free doesn't necessarily mean open source
>>> 
> 
> ___
> 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] GUI for SQLite

[RSmith]

Well you need to "buy" a $0.00 registration key, for which you need to fill in an inordinate amount of personal and contact 
information (just like buying other things online). The sort of event that promises Inbox spam aplenty and is too much hassle for 
most casual onlookers - but it does promise some sort of interoperability between SQLite and MySQL etc.

(Haven't used it, so just mentioning what it claims).


On 2013/06/26 17:34, Paolo Bolzoni wrote:

So... no? It is gratis, but not open. thanks.

On Wed, Jun 26, 2013 at 5:28 PM, Michael Black  wrote:

Free doesn't necessarily mean open source



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

Re: [sqlite] GUI for SQLite

[Paolo Bolzoni]

So... no? It is gratis, but not open. thanks.

On Wed, Jun 26, 2013 at 5:28 PM, Michael Black <mdblac...@yahoo.com> wrote:
> Free doesn't necessarily mean open source
>
> http://www.valentina-db.com/en/get-free-studio
>
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paolo Bolzoni
> Sent: Wednesday, June 26, 2013 10:26 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] GUI for SQLite
>
> Are you sure it is free? I cannot find the code...
>
>
> ___
> 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] GUI for SQLite

[Michael Black]

Free doesn't necessarily mean open source

http://www.valentina-db.com/en/get-free-studio


-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paolo Bolzoni
Sent: Wednesday, June 26, 2013 10:26 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] GUI for SQLite

Are you sure it is free? I cannot find the code...


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

Re: [sqlite] GUI for SQLite

[Paolo Bolzoni]

Are you sure it is free? I cannot find the code...

On Wed, Jun 26, 2013 at 6:28 AM, jorje <sabojor...@hotmail.com> wrote:
>  Take a look on a free gui tool -- Valentina Studio. Amazing product!  IMO
> this is the best manager for SQLite for all platforms.
> http://www.valentina-db.com/en/valentina-studio-overview
>
>
>
>
> --
> View this message in context: 
> http://sqlite.1065341.n5.nabble.com/GUI-for-SQLite-tp11673p69626.html
> Sent from the SQLite mailing list archive at Nabble.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] GUI for SQLite

[jorje]

 Take a look on a free gui tool -- Valentina Studio. Amazing product!  IMO
this is the best manager for SQLite for all platforms.  
http://www.valentina-db.com/en/valentina-studio-overview




--
View this message in context: 
http://sqlite.1065341.n5.nabble.com/GUI-for-SQLite-tp11673p69626.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] GUI for SQLite

[Alek Paunov]

On 08.03.2012 15:13, gregorinator wrote:

I've been happy with SQLite Studio:

http://sqlitestudio.one.pl/


Just tried Sqlite Studio following your advice - Great tool:

 * open source
 * implemented in scripting language (Tcl/Tk)
 * available as single executable
 * SQL editor with highlighting and autocompletion
 * browsing big tables
 * convenient editing of the data directly in the result grid
 * user defined functions in tcl and sql, plugins
 * many, many other features ...

I was Sqlite Manager user past years (Firefox plugin) but now I think I 
have a better tool :-)


Thank you Pawel!
Alek

P.S. If anyone have troubles to use the app on Fedora/CentOS, feel free 
to drop me a line.

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

Re: [sqlite] GUI for SQLite

[danap]

> Message: 8
> Date: Wed, 7 Mar 2012 21:47:28 +
> From: "Rose, John B" <jbr...@utk.edu>
> To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org>
> Subject: [sqlite] GUI for SQLite
> Message-ID: <cb7d419f.20e24%jbr...@utk.edu>
> Content-Type: text/plain; charset="us-ascii"
>
> We are new to SQLite and have experimented with a few GUIs, Firefox
> plugin, SQLite DB Browser, and Navicat. Is there a single GUI that is
> considered the best, with the most features?
>
> Thanks

Guess I can't speak for which SQLite GUI is best, but I have been
working on supporting SQLite with MyJSQLView. Got most of the basic
features in place like add, editing, deleting, import and export
of data. In addition I have created a plugin environment for the
application to support various analysis. Currently the app comes
with two a TableFieldProfiler and Heatmap plotter. You can create
your own plugin, tutorial outlines how.

Plugin Use Examples:

Table Field Pattern Analysis Map:
http://dandymadeproductions.com/projects/MyJSQLView/analysis/latitude_pattern.html

Ocean Temperatures Heat Map:
http://dandymadeproductions.com/temp/ocean_temperatures.jpg

MyJSQLView requires the Java Runtime Environment 1.5+, SQLiteJDBC,
and is free open source tool.

See http://www.xerial.org for SQLiteJDBC. Install into jre/lib/ext/

Dana M. Proctor
MyJSQLView Project Manager
myjsqlview.org

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

Re: [sqlite] GUI for SQLite

[Fabio Spadaro]

Il giorno 08 marzo 2012 14:13, gregorinator <gregorina...@gmail.com> ha
scritto:

> I've been happy with SQLite Studio:
>
> http://sqlitestudio.one.pl/
>
> One of the things I like about it is that it can do table edits not
> supported by SQLite's ALTER TABLE -- it automatically creates a new
> table and copies the existing data.  Saves me a lot of effort.  Other
> SQLite managers may be able to do this, too -- I don't know -- but
> after using SQLite Studio I would consider this a must-have feature.
>

You might try Sqlite Root <http://www.sqliteroot.com> that can change the
tables by inserting / deleting / modifying fields in any position with the
possibility of keeping the data (via form "keep data" yes or no)
-- 
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] GUI for SQLite

[gregorinator]

I've been happy with SQLite Studio:

http://sqlitestudio.one.pl/

One of the things I like about it is that it can do table edits not
supported by SQLite's ALTER TABLE -- it automatically creates a new
table and copies the existing data.  Saves me a lot of effort.  Other
SQLite managers may be able to do this, too -- I don't know -- but
after using SQLite Studio I would consider this a must-have feature.

gs

On 3/7/12, BareFeetWare <list@barefeetware.com> wrote:
> On 08/03/2012, at 8:47 AM, Rose, John B wrote:
>
>> We are new to SQLite and have experimented with a few GUIs, Firefox
>> plugin, SQLite DB Browser, and Navicat. Is there a single GUI that is
>> considered the best, with the most features?
>
> Some time back, I compared several SQLite GUI editors, mainly for Mac, and
> published at:
> http://www.barefeetware.com/sqlite/compare/?ml
>
> Tom
>
> Tom Brodhurst-Hill
> BareFeetWare
>
> --
> iPhone/iPad/iPod and Mac software development, specialising in databases
> develo...@barefeetware.com
> --
> Twitter: http://twitter.com/barefeetware/
> Facebook: http://www.facebook.com/BareFeetWare
>
> ___
> 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] GUI for SQLite

[BareFeetWare]

On 08/03/2012, at 8:47 AM, Rose, John B wrote:

> We are new to SQLite and have experimented with a few GUIs, Firefox plugin, 
> SQLite DB Browser, and Navicat. Is there a single GUI that is considered the 
> best, with the most features?

Some time back, I compared several SQLite GUI editors, mainly for Mac, and 
published at:
http://www.barefeetware.com/sqlite/compare/?ml

Tom

Tom Brodhurst-Hill
BareFeetWare

--
iPhone/iPad/iPod and Mac software development, specialising in databases
develo...@barefeetware.com
--
Twitter: http://twitter.com/barefeetware/
Facebook: http://www.facebook.com/BareFeetWare

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

Re: [sqlite] GUI for SQLite

[Oliver Peters]

Am 07.03.2012 22:47, schrieb Rose, John B:

We are new to SQLite and have experimented with a few GUIs, Firefox plugin, 
SQLite DB Browser, and Navicat. Is there a single GUI that is considered the 
best, with the most features?


I prefer http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index 
because it's very fast and reliable (but only M$).


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

Re: [sqlite] GUI for SQLite

[J Glassy]

Hello,

 Everyone has their own opinion on which SQLite GUI is 'best'. I've
had the best consistent luck over the years using the SQLite
Manager/Firefox plugin, in terms of a good mix of features and
availability on different platforms.  There may be better ones out
there though, depending on exactly what you use it for.  Your mileage
may vary :)

joe

On Wed, Mar 7, 2012 at 2:47 PM, Rose, John B <jbr...@utk.edu> wrote:
> We are new to SQLite and have experimented with a few GUIs, Firefox plugin, 
> SQLite DB Browser, and Navicat. Is there a single GUI that is considered the 
> best, with the most features?
>
> Thanks
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users




Joseph Glassy
Lead Software Engineer (UM faculty affiliate/contractor)
NASA Measures (Freeze/Thaw),Rm CFC 429
College of Forestry and Conservation
Univ. Montana, Missoula, MT 59812

Lupine Logic Inc.
www.lupinelogic.com
Scientific and Technical Programming
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] GUI for SQLite

[Rose, John B]

We are new to SQLite and have experimented with a few GUIs, Firefox plugin, 
SQLite DB Browser, and Navicat. Is there a single GUI that is considered the 
best, with the most features?

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