is with regard to storage
of time, 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
t DB engine that
SQLite seems to satisfy for millions with 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
ck the column affinity 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
> 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 Postgre
> 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 loa
> 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 consid
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 cr
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 somethi
> 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 strin
ND sql NOT NULL 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 sqlit
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 stand
but 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-->
TableDefinitionGe
g... 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
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 peopl
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 b
ntus's SQLite
JDBC 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#WhatisdifferentfromZentu
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
> 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 pa
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 p
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"
> To: "sqlite-users@sqlite.org"
> Subject: [sqlite] GUI for SQLite
> Message-ID:
> Content-Type: text/plain; charset="us-ascii"
>
> We are new to SQLite and have experimented with a few GUIs, Firefox
> plugin, SQLite DB B
e 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
_
yJSQLView 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 coul
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 pl
.
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 display
atement inaccuracy on my 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
ASC ORDER BY name ASC LIMIT 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.
>
> --
>
> Mes
atement inaccuracy on my 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
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
imp
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
30 matches
Mail list logo