[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-06-03 Thread Jean Chevalier
Check out cubeSQL Admin from sqlabs.com.? This turns SQLite into a
server; you can use the cubeSQL ODBC driver to connect to it from other
computers, among other methods.

[1] https://github.com/planetopendata/awesome-sqlite


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-06 Thread Justin Clift
On 4 May 2015, at 18:52, Scott Doctor  wrote:

> The day I can open source my rent, groceries, car repairs, is when everything 
> else can be free.

Rent and groceries... yeah, good luck there. ;)

But car repairs might actually come along at some point (decade or two?)
if the 3D printing scene goes big. :)

(and "... 3D printed groceries ..." hrmm ;>)

+ Justin


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-06 Thread Scott Doctor

That will be the day I can hit print on my computer and a Roast 
Beef Sandwich, with lettuce, tomato, onion, cheddar, and a smear 
of mustard on Marble Rye comes out my printer, all while driving 
my flying car (it is 2015, where is my flying car?)


Scott Doctor
scott at scottdoctor.com
--

On 5/6/2015 8:11 AM, Justin Clift wrote:
> On 4 May 2015, at 18:52, Scott Doctor  wrote:
> 
>> The day I can open source my rent, groceries, car repairs, is when 
>> everything else can be free.
> Rent and groceries... yeah, good luck there. ;)
>
> But car repairs might actually come along at some point (decade or two?)
> if the 3D printing scene goes big. :)
>
> (and "... 3D printed groceries ..." hrmm ;>)
>
> + Justin
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>



[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-05 Thread Gerald Bauer
Hello,

> what is the difference between major and minor?

  To quote from the pull request [1]:

The idea is major are kind of "A" league and minor "B" league. For
something more concrete - the tool is "A" league if it is open source
(and works ;-)). Another is how popular (hard to say). Not sure if
that makes sense.

  Cheers.

[1] https://github.com/planetopendata/awesome-sqlite/pull/1


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-05 Thread Drago, William @ CSG - NARDA-MITEQ
Under SQLite Admin Tools what is the difference between major and minor?

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com



> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Gerald Bauer
> Sent: Tuesday, May 05, 2015 7:05 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Awesome SQLite List - Collection of SQLite
> Goodies Started - Contributions Welcome
>
> Hello,
> >   It seems to me that it would be useful to include them, flagged as
> > "commercial only".
>
>   Due to popular demand I started a "commercial only" awesome sqlite
> list [1]. For now entries are free (as in beer)  ;-)  Cheers.
>
> [1] https://github.com/planetopendata/awesome-
> sqlite/blob/master/COMMERCIAL.md
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-05 Thread Gerald Bauer
Hello,
>   It seems to me that it would be useful to include them, flagged as
>  "commercial only".

  Due to popular demand I started a "commercial only" awesome sqlite
list [1]. For now entries are free (as in beer)  ;-)  Cheers.

[1] https://github.com/planetopendata/awesome-sqlite/blob/master/COMMERCIAL.md


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-05 Thread Niall O'Reilly
On Mon, 04 May 2015 17:15:17 +0100,
Gerald Bauer wrote:
> 
>   Note: For now commercial only tools (e.g. SQLite Analyzer) will NOT
> get include - sorry. If you want to get it included, buy a sponsored
> link or a beer for everyone on the mailing list! Just kidding ;-)

  It seems to me that it would be useful to include them, flagged as
  "commercial only".

  Best regards
  Niall O'Reilly



[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Daniel Sjödin
Hi,

There is also a VBA wrapper that I've tested. Maybe the usage is a bit
narrow but it shows how broad sqlite is.

https://sqliteforexcel.codeplex.com/

Regards,
Daniel
Hello,
  Thanks for the additions to the awesome-sqlite [1] list.  I added
the ODBC and JDBC drivers to a new middleware section, and the R
driver to a new language binding section, and the R data frame package
to a misc section.

  Note: For now commercial only tools (e.g. SQLite Analyzer) will NOT
get include - sorry. If you want to get it included, buy a sponsored
link or a beer for everyone on the mailing list! Just kidding ;-)

  Cheers.

[1] https://github.com/planetopendata/awesome-sqlite
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Gerald Bauer
Hello,
  Thanks for the additions to the awesome-sqlite [1] list.  I added
the ODBC and JDBC drivers to a new middleware section, and the R
driver to a new language binding section, and the R data frame package
to a misc section.

  Note: For now commercial only tools (e.g. SQLite Analyzer) will NOT
get include - sorry. If you want to get it included, buy a sponsored
link or a beer for everyone on the mailing list! Just kidding ;-)

  Cheers.

[1] https://github.com/planetopendata/awesome-sqlite


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Gerald Bauer
Hello,
  Thanks I've updated the awesome-sqlite list [1] and now includes a
new section on SpatiaLite and more admin tools. Cheers.

[1] https://github.com/planetopendata/awesome-sqlite


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Drago, William @ CSG - NARDA-MITEQ
Here's very good JDBC driver for SQLite:

https://bitbucket.org/xerial/sqlite-jdbc

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com



> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jim Callahan
> Sent: Monday, May 04, 2015 10:14 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Awesome SQLite List - Collection of SQLite
> Goodies Started - Contributions Welcome
>
> ?Readers on GitHub might also be interested in ODBC and JDBC drivers for
> SQLite:
>
> ODBC
> http://www.ch-werner.de/sqliteodbc/
>
> JDBC
> http://www.ch-werner.de/javasqlite/index.html?
>
> Also, a few weeks ago there was a discussion on this list of how to
> call SQLite from C# and an add-in for Microsoft Visual Studio.
>
> Also there is a (very high quality!)  RSQLite interface from the R
> statistical language to SQLite.
>
> RSQLite (on CRAN)
> http://cran.r-project.org/web/packages/RSQLite/index.html
> as well as
>
> sqldf (on CRAN)
> http://cran.r-project.org/web/packages/sqldf/sqldf.pdf
>
> sqldf (on GitHub)
> https://github.com/ggrothendieck/sqldf
>
>
> As I understand there are interfaces from a variety of other languages
> including Python and PHP.
>
> Jim Callahan
> Orlando, FL
>
>
> On Mon, May 4, 2015 at 8:55 AM, Gerald Bauer 
> wrote:
>
> > Hello,
> >   Thanks I've updated the awesome-sqlite list [1] and now includes a
> > new section on SpatiaLite and more admin tools. Cheers.
> >
> > [1] https://github.com/planetopendata/awesome-sqlite
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Scott Doctor

Nothing wrong with a commercial tool. I use, and paid for, many of them. 
After trying everything I could find for a particular problem, open 
source, freeware, trial versions, I chose a commercial program as it was 
more detailed and did want I needed it to do. Their program solved an 
issue for me that the open source, free stuff did not. The day I can 
open source my rent, groceries, car repairs, is when everything else can 
be free.

-
Scott Doctor
scott at scottdoctor.com
-

On 5/4/2015 9:15 AM, Gerald Bauer wrote:
> Hello,
>Thanks for the additions to the awesome-sqlite [1] list.  I added
> the ODBC and JDBC drivers to a new middleware section, and the R
> driver to a new language binding section, and the R data frame package
> to a misc section.
>
>Note: For now commercial only tools (e.g. SQLite Analyzer) will NOT
> get include - sorry. If you want to get it included, buy a sponsored
> link or a beer for everyone on the mailing list! Just kidding ;-)
>
>Cheers.
>
> [1] https://github.com/planetopendata/awesome-sqlite
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>



[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Jim Callahan
?Readers on GitHub might also be interested in ODBC and JDBC drivers for
SQLite:

ODBC
http://www.ch-werner.de/sqliteodbc/

JDBC
http://www.ch-werner.de/javasqlite/index.html?

Also, a few weeks ago there was a discussion on this list of how to call
SQLite from C# and an add-in for Microsoft Visual Studio.

Also there is a (very high quality!)  RSQLite interface from the R
statistical language to SQLite.

RSQLite (on CRAN)
http://cran.r-project.org/web/packages/RSQLite/index.html
as well as

sqldf (on CRAN)
http://cran.r-project.org/web/packages/sqldf/sqldf.pdf

sqldf (on GitHub)
https://github.com/ggrothendieck/sqldf


As I understand there are interfaces from a variety of other languages
including Python and PHP.

Jim Callahan
Orlando, FL


On Mon, May 4, 2015 at 8:55 AM, Gerald Bauer  wrote:

> Hello,
>   Thanks I've updated the awesome-sqlite list [1] and now includes a
> new section on SpatiaLite and more admin tools. Cheers.
>
> [1] https://github.com/planetopendata/awesome-sqlite
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-04 Thread Steven M. McNeese
Another admin tool is SQLite Analyzer by Kraslabs.com

-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jim Callahan
Sent: Monday, May 4, 2015 9:14 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Awesome SQLite List - Collection of SQLite Goodies 
Started - Contributions Welcome

?Readers on GitHub might also be interested in ODBC and JDBC drivers for
SQLite:

ODBC
http://www.ch-werner.de/sqliteodbc/

JDBC
http://www.ch-werner.de/javasqlite/index.html?

Also, a few weeks ago there was a discussion on this list of how to call SQLite 
from C# and an add-in for Microsoft Visual Studio.

Also there is a (very high quality!)  RSQLite interface from the R statistical 
language to SQLite.

RSQLite (on CRAN)
http://cran.r-project.org/web/packages/RSQLite/index.html
as well as

sqldf (on CRAN)
http://cran.r-project.org/web/packages/sqldf/sqldf.pdf

sqldf (on GitHub)
https://github.com/ggrothendieck/sqldf


As I understand there are interfaces from a variety of other languages 
including Python and PHP.

Jim Callahan
Orlando, FL


On Mon, May 4, 2015 at 8:55 AM, Gerald Bauer  wrote:

> Hello,
>   Thanks I've updated the awesome-sqlite list [1] and now includes a 
> new section on SpatiaLite and more admin tools. Cheers.
>
> [1] https://github.com/planetopendata/awesome-sqlite
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com





[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-03 Thread Jim Callahan
This link lists five SQLite "management tools":
1. SQLite Expert
2. SQLite Administrator
3. SQLite Database Browser
4. SQLite Spy
5. SQLite Manager (Firefox plug-in)
http://www.ginktage.com/2013/08/5-popular-and-free-sqlite-management-tools/

Also there is the Spatialite project which builds a spatial database (ie.
for GIS) on top of SQLite and it has its own GUI:

Spatialite GUI
https://www.gaia-gis.it/fossil/spatialite_gui/index

There are probably many, many more, but this is a start.

Jim Callahan
Orlando, FL

On Sun, May 3, 2015 at 11:28 AM, Gerald Bauer 
wrote:

> Hello,
>
>   I've started yet another awesome collection about  - surprise,
> surprise - SQLite - inspired by the awesome- trend on
> GitHub that collects links on a single page - in Markdown e.g.
> README.md - in a git repo.
>
>What?s news? The awesome-sqlite repo collects SQLite goodies,
> tools, scripts, books, etc. Still early and rough. Anything missing?
> Contributions welcome. Cheers.
>
> [1] https://github.com/planetopendata/awesome-sqlite
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


[sqlite] Awesome SQLite List - Collection of SQLite Goodies Started - Contributions Welcome

2015-05-03 Thread Gerald Bauer
Hello,

  I've started yet another awesome collection about  - surprise,
surprise - SQLite - inspired by the awesome- trend on
GitHub that collects links on a single page - in Markdown e.g.
README.md - in a git repo.

   What?s news? The awesome-sqlite repo collects SQLite goodies,
tools, scripts, books, etc. Still early and rough. Anything missing?
Contributions welcome. Cheers.

[1] https://github.com/planetopendata/awesome-sqlite