Hello 'Liters!
I'd like to move to SQLite from Postgres, but have two quick questions.
I'm a social scientist looking to manipulate a large dataset (5 billion
transactions, 700gb). I do not need multiple connections, and will only
ever run one query at a time.
I started in Postgres, but
On 4/5/2014 12:33 PM, da...@dandymadeproductions.com wrote:
The assumption is that the networked database, datasource, could be on
the local lan or Internet.
So am I to understand that you indeed are concerned (1) that the pipe
could be slow, and (2) that the server may be heavily loaded?
On 4/4/2014 1:21 PM, da...@dandymadeproductions.com wrote:
On working with the MyJSQLView database GUI access tool it has been
determined that a local file/memory database would be valuable to
perform recurring analysis on datasets from the connected datasource.
Sqlite is being considered as
Hello,
On working with the MyJSQLView database GUI access tool it
has been determined that a local file/memory database would
be valuable to perform recurring analysis on datasets from
the connected datasource. Sqlite is being considered as the
local database.
All the underlining code has been
Hello,
I'm currently working on a feature to MyJSQLView that allows DB to DB table
creation for use with creating in memory or local file data for anaylsis.
The feature is really being made to facilitate the oposite of your goal
of SQLite to PostgreSQL, but rather PostgreSQL/MySQL/Other to
Subject: Re: [sqlite] Dynamically generate SQL statements for SQLite
Message-ID: 1379089163135-71243.p...@n5.nabble.com
Content-Type: text/plain; charset=us-ascii
I agree with the other poster. You can just use any string manipluation
routines you like to assemble the SQL into a string and
AND name='MyTable'
danap.
Vijay Khurdiya wrote:
How to get details of constraints associated with Data in SQLite3.
There is no API to get individual properties; you have to look up the
original SQL statement:
SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'MyTable
MyJSQLView Version 3.44 Released
The MyJSQLView project is pleased to release v3.44 to the public. The
release's main composition is for the support of an additional database,
but in so doing expands the capability to use external data sources for
plugins. Modifications have been coded in to
application can generate a table DDL definition which I
pretty sure does properly identify primary foreign keys for a table.
Please see:
http://code.google.com/p/myjsqlview/
Code-- source-- utilities--
TableDefinitionGenerator.createSQLiteTableDefinition()
danap
MyJSQLView
Be sure to install Xerial JDBC jar in jre/lib/ext/
http://myjsqlview.org
http://www.xerial.org
danap.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Well its been a while since I did a search on it, but a few years ago
the best current one I could come up with is the xerial.org SQLiteJDBC.
My project, MyJSQLView, uses this to provide a GUI to a SQLite database
File.
Dana M. Proctor
MyJSQLView Project Manager
Howdy!
What driver are people
MyJSQLView Version 3.40 Released
The MyJSQLView project is pleased to release v3.40 to the public. The
release marks a major reorganizational effort to the source code and
plugin management. Though the public will notice little with regard
to the source subpackaging the plugin management changes
directory
to have it loaded automatically.
danap.
MyJSQLView
http://myjsqlview.org
SQLite JDBC
http://www.xerial.org/trac/Xerial
/wiki/SQLiteJDBC#WhatisdifferentfromZentussSQLiteJDBC
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
I'm working on getting the Mac version of the SQLite ODCB connector fully
functional. I'm having some problems getting examples of lots of
different data
types - for instance, my northwind copy has a decimal stored as a varchar.
Does anyone have a small test DB they would be willing to part
, but of course these are server based not like SQLite.
danap.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
MyJSQLView Version 3.35 Released
The MyJSQLView project is pleased to release v3.35 to the public. The
release is a maintenance update to address several issues that manifest
themselves when using the SQL Query Bucket and Query Frame. Drops to the
Query Bucket from the main summary table fail to
Currently the MyJSQLView application uses the Xerial SQLiteJDBC
interface to interact with a SQLite database. Does anyone know
of a more native type of JDBC interface mechanism that Java may
use to access a SQLite database?
The project would really like to be able to create a local file
or memory
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
them or make a plugin. If you need additional help let me know I
may have some other projects that do have a image viewer that I could steer
you to.
danap
MyJSQLView - myjsqlview.org
SQLiteJDBC - xerial.org
___
sqlite-users mailing list
sqlite-users
the Java source
to view them or make a plugin. If you need additional help let me know I
may have some other projects that do have a image viewer that I could steer
you to.
danap
MyJSQLView - myjsqlview.org
SQLiteJDBC - xerial.org
___
sqlite-users
MyJSQLView Version 3.33 Released
The MyJSQLView project is pleased to release v3.33 to the public. The
release includes improvements in the efficiency of use for the SQL Query
Bucket and an Aggregation/GROUP BY feature for the Advanced Sort/Search
Form. The new release also brings a new default
.
http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC#WhatisdifferentfromZentussSQLiteJDBC
danap.
I'm after an application which will allow me to enter data into a sqlite
database using a 'grid' layout of the data. I.e. I want the existing
contents of the database displayed as a table and I want
version 3.7.2 3.7.9.
danap.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
3.7.2 3.7.9.
danap.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
?
SQLite version 3.7.2 3.7.9.
danap.
--
Message: 24
Date: Fri, 11 Nov 2011 16:10:04 +
From: Black, Michael (IS) michael.bla...@ngc.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Subject: Re: [sqlite] GROUP BY With ASC/DESC
Message-ID
MyJSQLView Version 3.31 Released
The MyJSQLView project is pleased to release v3.31 to the public.
Included with this update is several corrections for bugs involved
with the import of large SQL dumps and table definition generation
for unique keys. A multi-language PDF export inclusion is now
The MyJSQLView project has released a preliminary production version to
address several reported problems with the application. Since this release
is to correct these bugs a more fully vetted release will be forth coming
by the end of the month or early next.
The release Version 3.30 corrects the
27 matches
Mail list logo