Re: [sqlite] Regarding CoC

Code Of Conduct, misplaced disposition on the individuals of an organization rather than the results of their work on intent. I have had a simple statement with my open source software downloads for years. "Dandy Made Productions would like to assure individuals that any applications downloaded

Re: [sqlite] Windows app to read SQLite DB, and launch web browser when dbl-clicking a record?

> I have a bunch of hyperlinks in an SQLite database, and need to read each > page for validation before deleting the record. > To make it easier, the DB manager should launch the default web browser when > I double click on a column that contains a hyperlink. > Before I build a GUI, is there a

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

>> On Oct 9, 2018, at 7:19 PM, Warren Young wrote: >> >> The arguments about mailing lists vs forums have all been had. > It’s not clear why this entire conversation is presented in such stark terms: LIST > *OR* FORUM. Puzzling. > > If this is all driven by DRH edict that “all things shall run

Re: [sqlite] Ajqvue v2.10 Released

> Looks good. > > Would pronouncing ajqvue -- achoo? -- send Mr. Mxyzptlk back to the 5th > dimension for 90 days? > Ned Perhaps if it was said three times while clicking your heels together. Ajqvue - A Java Query Vue danap. ___ sqlite-users mailing

[sqlite] Ajqvue v2.10 Released

Ajqvue Version 2.10 Released The Ajqvue project is pleased to release v2.10 to the public. The release is minor in nature with a new feature to allow opening local file databases in the Login Frame via a file chooser. Work was also completed to support the DB_to_FileMemoryDB plugin, package

Re: [sqlite] DB To DB Transfer Time

> Why aren't you measuring the time spent only in the SQLite writing thread? > > That would eliminate the overhead from the read-thread(s) and the queue in > the middle, > measuring only work by SQLite, instead of including the *waiting* for work > in the queue. > > I wrote a similarly "piped" ETL

Re: [sqlite] DB To DB Transfer Time

>> On Sep 25, 2018, at 11:14 AM, dmp wrote: >> >> The result for the 50K file db test of SQLite was 370.184 >> seconds. Is this a reasonable transfer speed, given the >> conditions noted? > You haven't specified how much of that time was spent in SQLite. For all

Re: [sqlite] DB To DB Transfer Time

Hello, Thank you for the responses, Stephen and Dominique. I was generally looking for an idea if the transaction time seemed reasonable, given a low end MariaDB server, standard 100Mb LAN, and mid range user processing desktop machine. I realize that the question as answered is; Hard to say!

[sqlite] DB To DB Transfer Time

Hello, I have created a database to database transfer plugin for my application. The plugin is functional and I have collected a log of testing results stored in a SQLite db. The links below are of the database and definition of parameters fields. The main exception, dbTypeMemory, meaning memory

Re: [sqlite] Best practices for forward conversion of database formats?

Randall wrote: ~ ~ > Any application that involves a "persistent" database, i.e., one where the data is > long-lived and expected to exist and evolve over time, sooner or later has the issue > of moving customers from a V1 database to a V2 database. Obviously at least one > technical issue (there

Re: [sqlite] Time Precision

Keith Medcalf wrote: > Are you running Windows or Unix? I am sending this to you as I was just looking > into this again and although SQLite maintains time internally with a millisecond > precision, the API used on Windows to read the time is limited by the Clock > Resolution (usually about 16.5

Re: [sqlite] The upcoming alter table rename column

Still doesn't work when saving directly to file. Nice though. Modified version follows. Thanks. danap. Fixes/Adds: 1. Header comment added --. 2. Added drop IF EXISTS. 3. Each CREATE VIEW added space after AS. 4. Placed end of statement semicolon directly after parenthesis. 5. Has only \n for

[sqlite] Ajqvue Version 2.0 Released

The Ajqvue project is pleased to release v2.0 to the public. The release is a major maintenance, cleanup, and consolidation of the code base. In part most of the work was driven by a DB_to_FileMemoryDB plugin and insuring a more robust handling of SQLite affinity. The sqlite-jdbc library has again

Re: [sqlite] SQLite .dump

Simon Slavin wrote: > I'm sorry, but I don't see a question in your post. As intended. It was just a statement based on observation, with regard to SQLite .dump, my GUI dump, and other database dump outputs. MySQL also uses a short version without specifying column names, but does quotes

[sqlite] SQLite .dump

Hello, Recently in testing my GUI tool I made a comparison from the tool's dump and SQLite's command line .dump tool. Seems .dump uses a short output of skipping the column names. According to some of my research for various databases I use one of these as options for SQL dump output:

[sqlite] (no subject)

On 7/12/18, danap wrote: >> I use a dump >> in my interface which I used with diff to compare changes in my >> personal expense database. This was to insure changes introduced in work >> on the interface were not screwing things up. Very helpful to insure >> your not introducing bugs. D. Richard

Re: [sqlite] Round-tripping SQLite back and forth between text representation.

Randall wrote: > My wishlist is: > (o) Allow humans to view the contents of a DB without custom tools. If what is meant here is a generic tool that opens/views any particular file format, db context here, then there are tools including the generic db gui that I have been working on for years. >

[sqlite] Subject: Re: Date Search

Keith wrote: > Correct. > You have stored integer Unix Epoch timestamps. You cannot do "string" > searches on integers (at least not ones like what you have asked for, > which involves conversion of an integer representing a Unix Epoch offset > to an ISO-8601 string, not to an ordinary "string

Re: [sqlite] Time Precision

danap wrote: > SELECT CAST((SELECT (julianday('now', 'localtime') - > julianday('1970-01-01'))*24*60*60*1000) AS INTEGER); Keith wrote: > Are you sure you want to be mixing up timezones? > > julianday('1970-01-01') returns the julianday timestamp > for 1970-01-01 00:00:00 GMT julianday('now',

[sqlite] Date Search

Given: SELECT STRFTIME('%s', '2018-01-01'); 1514764800 SELECT STRFTIME('%s', '2017-01-01'); 1483228800 CREATE TABLE date_types( id INTEGER PRIMARY KEY, date_type DATE ); INSERT INTO "date_types" ("id", "date_type") VALUES(1, 1514764800); INSERT INTO "date_types" ("id", "date_type")

Re: [sqlite] Time Precision

> Igor wrote: > select (julianday('now') - julianday('1970-01-01'))*24*60*60*1000 > Keith wrote: > select (julianday() - 2440587.5) * 86400.0 Both of these got me on my way, Igor's a little more clearer. I'll doing a little more checking to insure the solution below is correct, but seems good.

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

> Mailing lists are now back on-line and once again accepting > subscriptions. I have implemented measures to block the subscription > robots and to better log subscription activity to better detect future > mischief. > I consider this to be a stop-gap measure that will buy me some time > to

Re: [sqlite] Subject: Re: SQL Date Import

> SQLite doesn't have a DATE type. You can store dates in a SQLite > database as text, or integers or floating point numbers (e.g. "20180602", > a number of days, a number of seconds). But when you ask for a value, > that's what you'll get back. Any interpretation of that value as a > date is

[sqlite] Subject: Re: SQL Date Import

Keith Medcalf wrote: > Yes, and the database will store the data as entered/bound if it > cannot be converted to the requested storage type (column affinity). Yes, that was my understanding and there-lies the problem. A column of type DATE, TIME, or TIMESTAMP that may have NUMERIC and TEXT data.

[sqlite] SQL Date Import

Currently I do not have SQLite setup to run on its own on a computer. I figured the answer to my question would be faster if it was posed to this list. Given: CREATE TABLE exdate ( id INTEGER, mydate DATE NOT NULL, PRIMARY KEY (id) ); Once a number, numeric, is stored. Can a command line

Re: [sqlite] Size of the SQLite library

1. Define in documentation as < 1Mb. (Don't have to visit again.) 2. Continue to strive to keep in the 0.5-1MB range. 3. Add some information on building a MINIMUM size for those concerned that is relatively easy to accomplish without a lot of expertise if possible. danap.

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

Scott Robinson wrote: > What version of SQLite are you using for this? I just did the > following and do not see the string quoted values you are describing: I'm sorry, the example given was just the current one I was using to test the fix. In general I found the application was quoting all

Re: [sqlite] SQLite is a LoC Preferred Format for datasets

Suppose outside the subject of this thread, but in the document. Sustainability factors Self-documentation: "The database format incorporates technical and structural metadata needed to interpret and manipulate the data itself. For example, a database file will include the CREATE TABLE

Re: [sqlite] sqlite-users Digest, Vol 125, Issue 28

> I tried to create a shareable in-memory database as per the documentation > provided on SQLite Site. But I end up finding the solution to the > problem. > > *Here is my code in C#*: > > > var connectionString = "Data > Source=sharedmemdb;Mode=Memory;Cache=Shared"; > > > using (var connection1

Re: [sqlite] How to Handle BigInt

> Also note that if you store your numbers as strings, indexes on those > values will order them as strings. In other words, searching and sorting > will work incorrectly. > It should be possible to get your numbers from a Java numeric variable to > a database numeric value without passing them

Re: [sqlite] How to Handle BigInt

> SQLite integers are all 64 bit - I don't about postgress, so unless > postgress allows integers bigger than 64 bit, and you use them, you should > be OK with your table definitions above. > Paul Hello, That really provides insight to the real issue, I was having and so therefore the question.

[sqlite] How to Handle BigInt

Hello, Given a conversion from a database table that contains BigInt, long, field from PostgreSQL to a SQLite similar table. CREATE TABLE postgresqltypes ( data_type_id serial, bigInt_type bigint) CREATE TABLE sqlitetypes ( data_type_id INTEGER PRIMARY KEY AUTOINCREMENT, int_type

Re: [sqlite] JDBC driver experience

> Are you using SQLite with JDBC? If so, can you please answer a few > questions below? > You can post on this mailing list or send your reply directly to me. 1. Which JDBC are you using? Current Xerial SQLite JDBC https://github.com/xerial/sqlite-jdbc Others that I have tried are a

Re: [sqlite] Free tool to visualize a schema?

> Hi, > I think the visualization of a schema helps to develop a sqlite database. > > I am searching for a free software, like SchemaCrawler. > It is good, but can't show CONSTRAINT and FOREIGN KEY names in the > diagram. > > I just tried out the Sqleton but it can't be start on my system so far.

Re: [sqlite] Many ML emails going to GMail's SPAM

Well I think some have pointed out the issues with a online web forum, logging in, lack of email notifications? Mailing lists are one aspect of the Internet that in the last 25yrs has not disappointed me. Keeping the mailing list seems to work or the irc option perhaps. With that being said I

Re: [sqlite] Best way to develop a GUI front-end

> Date: Mon, 13 Nov 2017 15:54:42 -0600 > From: Balaji Ramanathan > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Best way to develop a GUI front-end > > Hi, > > I have been using SQLite without any programming language so far. I > maintain the data in

Re: [sqlite] SQLite Port/ODBC Driver Question

Hello Vishal, As far as I know the Java version of the Werner javasqlite driver does not use a port and the odbc may not also. I have use this Java driver, but a more current active driver project for Java is at GitHub: https://github.com/xerial/sqlite-jdbc/ As indicated SQLite is local file

[sqlite] Subject: Re: sqlite with Java

> From: Sylvain Pointeau > > Why don't you provide an up-to-date version? this lib seems dead when we > look at the website, also why don't you put the sources on git it would be > easier to contribute or raise a bug if any... > > -- I first supported SQLite in my

Re: [sqlite] confused getting started

> I'm not a computer novice, but also not a nerd/geek. > Been using PCs since the mid 1980s and have used dBase III+ and Approach > previously. > > I can't seem to grasp what I need to download / install to use SQLite? > > Can someone guide me through the process? Looking to use it with >

Re: [sqlite] Quest for "scratch table" implementation in SQLite.

> I'm still trying to figure out a graceful way to implement > a "scratch" database table that has the following properties: > o Can be created on demand while a database connection is open. > o Can include references to other material in the database to > ensure integrity. > o Will be

Re: [sqlite] SQLite3 Tutorial error

> Message: 21 > Date: Wed, 4 Jan 2017 22:10:59 -0600 > From: Ken Wagner > To: SQLite mailing list > Subject: Re: [sqlite] SQLite3 Tutorial error > Yes, I am beginning to understand that. SQLite3 is its own GLOB standard. > I will abide

[sqlite] Ajqvue 1.11 Released

The Ajqvue project is pleased to release v1.11 to the public. The release is a minor one to highlight an update to the QueryBuilder plugin. In addition to the QueryBuilder plugin the application comes with by the HeatMapper, JavaFX Charts, and Table Field Profiler plugins. The SQLite JDBC is an

[sqlite] Ajqvue Version 1.10 Released

Ajqvue Version 1.10 Released The Ajqvue project is pleased to release v1.10 to the public. The release marks a complete code review and cleanup. Updated libraries have also been included with this release along with the Table Field Profiler plugin. There have been many fixes in this release that

[sqlite] MyJSQLView Version 7.08 Released

MyJSQLView Version 7.08 Released The MyJSQLView project is pleased to release v7.08 to the public. The release marks a complete code review and cleanup. Updated libraries have also been included with this release along with the Table Field Profiler plugin. There have been many fixes in this

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

I'm not interested in mobile browsing, just that the site is still acceptable after changes for desktop. I use unconventional browsers included one of my own design. The draft site looks and works fine, is fast for loads, doesn't seem to require scripting, GOOD! danap.

Re: [sqlite] SQL to SQLite

> Thanks Dana, > I think you're talking about doing what I did, but I'm not 100% sure. > Below is my solution. Could you let me know if yours is the same or > something more elegant? Hello, I'm not sure of the programming language, VBasic, ?, but generally looking through it looks like

Re: [sqlite] SQL to SQLite

> Message: 2 > Date: Tue, 19 Jul 2016 15:01:55 -0700 > From: > To: > Subject: [sqlite] SQL to SQLite > Message-ID: <004d01d1e209$2a356360$7ea02a20$@spotlightmusic.com> > Content-Type: text/plain; charset="us-ascii" > > What's

[sqlite] Why is empty string not equal to empty blob?

> You explicitly put strings into both columns. The two values are the same > even though you declared the columns differently. As I told you before, > if you want to see what type something is, use typeof(thing). > > ~ > ~ > ~ > ~ > > Simon. Thank you guys. I follow this list so I

[sqlite] GROUP BY With ASC/DESC

Given the following table: DROP TABLE IF EXISTS key_table5; CREATE TABLE key_table5 ( name TEXT NOT NULL default '', color TEXT default NULL, price REAL default NULL, UNIQUE (name), PRIMARY KEY (color) ); I'm getting the following exception: SQLException: [SQLITE_ERROR] SQL error or missing

[sqlite] MyJSQLView Version 3.23 Released

MyJSQLView Version 3.23 Released The MyJSQLView project is pleased to provide the release of Version 3.23 to the public. The release marks the addition of support for the SQLite database. New to this release of MyJSQLView is also the support for in memory databases that is featured for both the