[sqlite] Time Precision

ime, in milliseconds, a 13 digit value. I would assume a more appropriate precision for a scientific community. Looking briefly at the c library for strftime() it does not seem to provide the possibility for a millisecond precision? STRFTIME('%ms'), Integer or TIME(D), 13 digits, Text. da

Re: [sqlite] column types and constraints

ith FLEXIBILITY! If you wish a more constrained light RDBMS then H2, HSQL, and others are available. I'm just happy at least I get a column affinity for type checking to give some sanity. Thank you. danap. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] column types and constraints

ty and assume thats what is going to be stored there. danap. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite for single user data manipulation

> 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

Re: [sqlite] Database to SQLite Population

> 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

Re: [sqlite] Database to SQLite Population

> 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

[sqlite] Database to SQLite Population

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

Re: [sqlite] Direct PostgreSQL to SQLite connection?

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

Re: [sqlite] Dynamically generate SQL statements for SQLite

> 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

Re: [sqlite] Getting Constraints Details

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 = 'ta

[sqlite] MyJSQLView Version 3.44 Released

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

Re: [sqlite] Help needed with query to tell a FK from a PK

perhaps this may help. The MyJSQLView 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.cr

[sqlite] Subject: Re: Simple SQLite-based spreadsheet?

I think there's an opportunity > here. > > Thank you. Or perhaps 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

Re: [sqlite] Subject: SQLite driver for Java

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

[sqlite] MyJSQLView Version 3.40 Released

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

Re: [sqlite] How do you load a ".csv" and skip the first line?

DBC must be used as the commnuncation interface to the SQLite database file. Add it to your java/lib/ext directory to have it loaded automatically. danap. MyJSQLView http://myjsqlview.org SQLite JDBC http://www.xerial.org/trac/Xerial /wiki/SQLiteJDBC#WhatisdifferentfromZentussSQLiteJDBC __

Re: [sqlite] JDBC Drivers--which one?

ine with other databases, 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

Re: [sqlite] Example database with lots of "types"?

> 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

[sqlite] MyJSQLView Version 3.35 Release

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

[sqlite] Java JDBC type Interface to SQLite

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

Re: [sqlite] GUI for SQLite

> Message: 8 > Date: Wed, 7 Mar 2012 21:47:28 + > From: "Rose, John B" > To: "sqlite-users@sqlite.org" > Subject: [sqlite] GUI for SQLite > Message-ID: > Content-Type: text/plain; charset="us-ascii" > > We are new to

Re: [sqlite] SQLite, portable, image store

blob, pictures, I have seen some. You could modify 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 __

Re: [sqlite] sqlite-users Digest, Vol 50, Issue 26

View does not have a image viewer for the blob, pictures, I have seen some. You could modify 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 ste

[sqlite] MyJSQLView Version 3.33 Released

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

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

. 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 a

[sqlite] GROUP BY With ASC/DESC

part? SQLite 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

Re: [sqlite] GROUP BY With ASC/DESC

MIT 50 OFFSET 0 > > when either ASC or DESC is used with the GROUP BY clause. > > Is this a bug or a query statement inaccuracy on my part? > > SQLite version 3.7.2 & 3.7.9. > > danap. > > -- > > Message: 24 > Date: Fri, 1

[sqlite] GROUP BY With ASC/DESC

part? SQLite 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

[sqlite] MyJSQLView Version 3.31 Released

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

[sqlite] MyJSQLView Version 3.30 Released

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