Re: [sqlite] Displaying row count

2018-10-31 Thread Don V Nielsen
I really enjoy using JetBrains DataGrip. It connects to everything and has great intellisense, find and replace tools, sql templates, all the goodies a big IDE brings to the table. On Wed, Oct 31, 2018 at 11:05 AM Dominique Devienne wrote: > On Wed, Oct 31, 2018 at 3:55 PM Clemens Ladisch >

Re: [sqlite] Regarding CoC

2018-10-22 Thread Don V Nielsen
I really feel for you, DRH. You tried covering all the bases, unfortunately, you going to get tagged out at everyone because everybody is referee and they all follow their own rules.This goes straight to your first point, "What is professional to some might be unprofessional to others." This akin

Re: [sqlite] A SQL statement reformatter

2018-09-28 Thread Don V Nielsen
Slick. That line width slider feature is something we don't get using Poor Man's Sql Formatter. Thanks! On Thu, Sep 27, 2018 at 7:03 PM Simon Slavin wrote: > For those times when you have to understand a poorly-formatted SQL > statement: > > > > I seem to prefer 'full'

Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-30 Thread Don V Nielsen
This is what I was trying to remember. It is for calling LE Cobol, but it demonstrates the use of the CEEENTRY and CEETERM macro that are used to establish the environment without having to use a LE C stub program. I used to use the Cobol stub method in the past.

Re: [sqlite] sqlite on IBM z/OS Unix

2018-08-30 Thread Don V Nielsen
"Having successfully ported sqlite to z/OS Unix as a 32 bit app" Totally Awesome! Do I have a solution? No. But I'll bet John McKown will. I believe he is a guru with the mainframe. It is not SqlLite. It is that communication mechanism between the non-LE program calling into the LE environment.

Re: [sqlite] Add Column with "If Not Exists"

2018-08-01 Thread Don V Nielsen
This makes me feel there is a lot of pain coming in the future. Given an update statement for n dbs of unknown state, When a db lacks columns necessary to successfully execute the sql Then add the columns to the db I'm trying to imagine how to keep n remote dbs in a known state, say z, when

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

2018-06-18 Thread Don V Nielsen
Any thought, comments, or observations of using Slack? On Fri, Jun 15, 2018 at 1:25 PM J. King wrote: > On June 15, 2018 12:17:31 PM EDT, dmp > wrote: > >> Mailing lists are now back on-line and once again accepting > >> subscriptions. I have implemented measures to block the subscription >

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

2018-06-14 Thread Don V Nielsen
> Do we need any further evidence that the heart of man is deceitful above all things, and desperately wicked? Per Keith Metcalf: "The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume." On Thu, Jun 14, 2018 at 12:38 PM R Smith

Re: [sqlite] Newbie help

2018-06-08 Thread Don V Nielsen
> the monitoring program is constantly launching sqlite3.exe with new commands or files of commands So the monitoring program has the ability to interact with the outside world when something changes? Can you write a service that listens for activity from our monitoring program, and the service

Re: [sqlite] random rows

2018-06-01 Thread Don V Nielsen
?? SELECT * FROM table WHERE id IN (SELECT id FROM table ORDER BY RANDOM() LIMIT x) Maybe. It is more memory efficient then trying to sort the entire lot of data. On Thu, May 31, 2018 at 7:13 PM Torsten Curdt wrote: > I need to get some random rows from a large(ish) table. > > The following

Re: [sqlite] Lots of enhancements coming to version 3.24.0 - please test

2018-05-08 Thread Don V Nielsen
Two thumbs up, Dan. Thanks for the clarification. On Tue, May 8, 2018 at 11:11 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 05/08/2018 11:04 PM, Don V Nielsen wrote: > >> " UPDATE <https://www.sqlite.org/draft/lang_update.html> avoids writing >>>

Re: [sqlite] Lots of enhancements coming to version 3.24.0 - please test

2018-05-08 Thread Don V Nielsen
> " UPDATE avoids writing database pages that do not actually change. For example, "UPDATE t1 SET x=25 WHERE y=?" becomes a no-op if the value in column x is already 25." I have a ridiculous assertion concerning this, but please here me out. Given

Re: [sqlite] JDBC driver experience

2018-04-18 Thread Don V Nielsen
1. Xerial 2. Couple years? 3. None. But I am just a dumb user. I use JetBrains IDE's (RubyMine, Rider, Datagrip). The IDE's provide direct access to the datasource for looking at the db, manipulating data, manipulating tables. That sort of stuff. Never once have I had an issue with the driver

Re: [sqlite] Are you getting spam when you post to sqlite-users ?

2018-04-18 Thread Don V Nielsen
And my dating success rate has dropped dramatically On Wed, Apr 18, 2018 at 8:54 AM, José María Mateos wrote: > On Tue, Apr 17, 2018, at 17:39, Simon Slavin wrote: > > Dear list-posters, > > > > Are you getting a new dating-spam each time you post to this list ? If > > you

Re: [sqlite] Documentation update

2018-04-09 Thread Don V Nielsen
I'm adding to my bucket list meeting some of you in person. On Mon, Apr 9, 2018 at 5:58 AM, Niall O'Reilly wrote: > On 9 Apr 2018, at 11:02, R Smith wrote: > > > Gentlemen - shall we call pistols at dawn to settle this? > > Or my favourite duel: Face-pulling at midnight.

Re: [sqlite] Documentation update

2018-04-08 Thread Don V Nielsen
"to be", or not "to be" :) On Sun, Apr 8, 2018 at 7:08 PM, Don V Nielsen <donvniel...@gmail.com> wrote: > "For the purposes of unique indices, all NULL values are considered [to] > different from all other NULL values and are thus unique."

[sqlite] Documentation update

2018-04-08 Thread Don V Nielsen
"For the purposes of unique indices, all NULL values are considered [to] different from all other NULL values and are thus unique." I think it should read "...NULL value are considered different..." https://www.sqlite.org/lang_createindex.html dvn ___

Re: [sqlite] SQLite equivalent of SQL Over(Partition)

2018-04-06 Thread Don V Nielsen
That seems like an odd application of OVER (Partition by). Is there some performance reason one would want to do DISTINCT OVER (PARTITION BY) instead of a simple GROUP BY Sites.Customer, Sites.Digit, Count()? On Fri, Apr 6, 2018 at 12:20 PM, Simon Slavin wrote: > On 5 Apr

Re: [sqlite] non-returned column aliases for repeating expressions?

2018-03-24 Thread Don V Nielsen
I'm not the sharpest tool in the shed, here, but a couple of observations / ideas. First, why in the ORDER clause use _3 and then "id" instead of _1? Using one alias and not the other is inconsistent and could be confusing. Personally, I would have did the following. Acquire the data using the

Re: [sqlite] Can this be done with SQLite

2018-01-22 Thread Don V Nielsen
Cecil, you need to make a backup of the values before they are altered, and then alter them from the backup. That way, by the time you have come full circle, you are not working with the changed values. On Mon, Jan 22, 2018 at 4:11 PM, Cecil Westerhof wrote: >

Re: [sqlite] Infinite loop when updating indexed with case and where clause

2018-01-16 Thread Don V Nielsen
Off topic question regarding fix: "0!=(wctrlFlags & WHERE_ONEPASS_MULTIROW)" Is there a performance bonus or compiler optimization if one compares a target constant to a source condition versus comparing a target condition to a source constant, as in "(wctrlFlags & WHERE_ONEPASS_MULTIROW)!=0"?

Re: [sqlite] Move to Github!!?

2017-12-26 Thread Don V Nielsen
> What's not so easy to replace is the Git integration in my editor (Visual Studio Code) Same here, but I use JetBrains products. I put a bug in the ear of JetBrains. At least its something. Have a good one, all On Tue, Dec 26, 2017 at 9:27 AM, J. King wrote: > I use Git,

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

2017-11-14 Thread Don V Nielsen
Ruby on Rails On Tue, Nov 14, 2017 at 10:09 AM, Drago, William @ CSG - NARDA-MITEQ < william.dr...@l3t.com> wrote: > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On > > Behalf Of Bart Smissaert > > Sent: Monday, November 13, 2017

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
A good StackOverflow post on adapting in C# for use in Linq queries: https://stackoverflow.com/questions/24229785/sqlite-net-sqlitefunction-not-working-in-linq-to-sql/26155359#26155359 On Fri, Nov 10, 2017 at 8:31 AM, Don V Nielsen <donvniel...@gmail.com> wrote: > Brent Ashley has a

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
I'd take regular expressions, sure, but, how do you get SQLite syntax > to take that on? > > On Fri, Nov 10, 2017 at 8:45 AM, Don V Nielsen <donvniel...@gmail.com> > wrote: > > Assuming you are looking for "Abc" or "Def" anywhere in the argument, how > >

Re: [sqlite] Simple Search using LIKE or something else

2017-11-10 Thread Don V Nielsen
Assuming you are looking for "Abc" or "Def" anywhere in the argument, how about regular expression? (Abc|Def) On Thu, Nov 9, 2017 at 3:00 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 11/9/17, 2:51 PM, "sqlite-users on behalf of Stephen Chrzanowski" < >

Re: [sqlite] How to create primary key from two another PK's?

2017-10-23 Thread Don V Nielsen
Just asking some leading questions. You have students. And students have work pieces. You are then creating a list "uniqueworkpiece" showing the work pieces associated to each student. Your primary key will ensure the uniqueness of the student to work piece. Do you also need to ensure that the

Re: [sqlite] Possible bug with strftime('%s') < strftime('%s')

2017-10-11 Thread Don V Nielsen
sqlite> select datetime('now', '+300 seconds') < datetime('now'); > 0 > > sqlite> select datetime('now', '-300 seconds') < datetime('now'); > 1 > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf

Re: [sqlite] Possible bug with strftime('%s') < strftime('%s')

2017-10-11 Thread Don V Nielsen
So strftime always returns TEXT. Correct? It was the application of +300 to that result that changed the type to INTEGER. And had "+300 seconds" been applied as a modifier in the strftime function, then the addition would have occurred before producing the result, with the result being type TEXT.

Re: [sqlite] bug: failure to write journal reported as "disk I/O error"

2017-09-27 Thread Don V Nielsen
I'm sorry gentlemen, but the argument has gotten thick and petulant. Every complaint and response is resolving down to a mainframe line of thought (thank God), which few today are willing to accept. That is, the SQLite software is kept compatible with its root. How many System 370 Cobol programs

Re: [sqlite] Please remove me from the mailing list

2017-09-13 Thread Don V Nielsen
SWEET MOTHER OF MOSES. I saw "Please remove me from your list" with Simon Slavin's name next to it. I nearly had a heart attack. On Wed, Sep 13, 2017 at 9:39 AM, Simon Slavin wrote: > > > On 13 Sep 2017, at 2:44pm, Dan K McCormick wrote: > > >

Re: [sqlite] Sharing data between desktop and Android

2017-09-06 Thread Don V Nielsen
I use an app called AirDroid: https://www.airdroid.com/ It goes beyond copying files to/from phone and pc, but it is one of its functionalities. On Wed, Sep 6, 2017 at 6:08 AM, Cecil Westerhof wrote: > 2017-09-06 12:54 GMT+02:00 Andy Ling : > > > >

Re: [sqlite] My 1st C++ SQLite3 program

2017-08-28 Thread Don V Nielsen
database_name is never assigned a value? In SQLite3_RDB::SQLite3_RDB() it is spelled databese_name? On Sat, Aug 26, 2017 at 10:28 PM, Simon Slavin wrote: > > > On 27 Aug 2017, at 2:34am, Papa wrote: > > > Why do I get this error message? > > Try having

Re: [sqlite] GROUP_CONCAT separator and DISTINCT

2017-08-25 Thread Don V Nielsen
I think David Blake is suggesting that GROUP_CONCAT intuitively suggests it should take the separator argument, regardless of DISTINCT being present. It is logical that it should, given GROUP_CONCAT takes two arguments, not one. The second argument defaults to a comma when omitted. The presence of

Re: [sqlite] Tutorials, books, video about SQLite

2017-08-09 Thread Don V Nielsen
Safari Books Online. I believe there are a number of SQLite title there. On Wed, Aug 9, 2017 at 2:06 PM, Lars Frederiksen wrote: > Hi > > > > I would appreciate very much if you clever people out there have some > booktitles or links to tutorials (websites, video etc) about

Re: [sqlite] Poll: Include the recent sqlite3_column_name() fix in the upcoming 3.20.0 release?

2017-07-31 Thread Don V Nielsen
Merge it now. As stated in documentation: "The SQLite documentation clearly states that, if there is no AS clause, the names of output columns are indeterminate, arbitrary, and subject to change." It would be my hope that legacy applications exploiting the returned column name given said

Re: [sqlite] A Descending Auto Increment Key

2017-07-20 Thread Don V Nielsen
On the heel of this is a grammatical error: "declared type "INTEGER" includes an "PRIMARY KEY DESC" clause". It should read "includes a "primary...". On Wed, Jul 19, 2017 at 11:03 PM, Keith Medcalf wrote: > > AUTOINCREMENT can only be used with INTEGER PRIMAY KEY columns in

Re: [sqlite] Version 3.20.0 coming soon...

2017-07-14 Thread Don V Nielsen
> perhaps the devs can invent some other namespace Seconded. I would like to think the devs, themselves, would like to create some sort of namespace or isolation for the structures created by the extensions. A little more gusto in the name, rather than STMT, would always be appreciated. imo On

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

2017-06-08 Thread Don V Nielsen
"CREATE TABLE meta_comments" Simon, isn't your approach the most logical solution rather than incorporating a comment column into the master? Once incorporated, wouldn't you be opening yourself up to a litany of "Not the way we work", "We need feature x to be useful", "What if we want a null

Re: [sqlite] sqlite3 feature or regression

2017-03-08 Thread don v nielsen
Vermes, I'm late to the party but would still like to comment. The problem is the ruby code, not sqlite. The following is what you coded in the Ruby: db.execute("select szamla,megnevezes from proba") do |row| In some shape or fashion, the result set is getting mangled by the update. When

Re: [sqlite] UNION

2017-03-03 Thread don v nielsen
Might I suggest: https://www.w3schools.com/sql/ dvn On 03/01/2017 09:02 AM, jose isaias cabrera wrote: Ryan, I just want to thank you for your kindness and display of goodwill to mankind. This is a great response. I even learned something from this post. Thanks so much for your responses.

[sqlite] Fossil documentation edit

2017-02-15 Thread don v nielsen
On page http://fossil-scm.org/index.html/doc/trunk/www/quickstart.wiki it reads: " To merge two branches back together, firstupdate to the branch you want to merge into.Then do amerge another branch

Re: [sqlite] Using CSV.c

2017-01-10 Thread Don V Nielsen
I would recommend using a script or batch file to automate the process using the command line tool. It would be easier to maintain and remove a level or two of complexity. On Tue, Jan 10, 2017 at 4:03 AM, tbuck...@frontier.com < tbuck...@frontier.com> wrote: > Hello,I am having a little trouble

Re: [sqlite] Bad query plan selection only with "LEFT JOIN"

2017-01-06 Thread Don V Nielsen
In the below view, what is "a"? A FROM is not defined. -- -- Ideally I want to write the next query using the previous view -- CREATE VIEW if not exists "despesas_master_list_view_tidy" AS SELECT a.*, b.name as modalidade_licitacao, c.name as credor, d.* LEFT JOIN

Re: [sqlite] Commit ad601c7962 degrade performance in a client program

2017-01-05 Thread Don V Nielsen
I loved this remark posted in the bugzilla chain: "(... Fossil? where do people find these version control systems?)" On Thu, Jan 5, 2017 at 2:09 AM, Richard Hipp wrote: > On 1/3/17, Jianxun Zhang wrote: >> I am working in Yocto project. We have

Re: [sqlite] date-2.2c tests fail for sqlite-3.16.1 on Fedora / i686

2017-01-05 Thread Don V Nielsen
Graham, you may be on to something: "I don't know what the tests are doing, but could it be connected with the fact that a leap-second was added as we changed from 2016 to 2017". I noticed a whole bunch of rspec tests (my projects completely unrelated to sqlite) failing with microsecond

Re: [sqlite] Possible bug with union and join.

2016-12-27 Thread Don V Nielsen
Thanks for the correction/information! Merry Christmas and Happy New Year to you. On Tue, Dec 27, 2016 at 9:48 AM, Richard Hipp <d...@sqlite.org> wrote: > On 12/27/16, Don V Nielsen <donvniel...@gmail.com> wrote: >> Theory related question. I'm being argumentative, I kn

Re: [sqlite] Possible bug with union and join.

2016-12-27 Thread Don V Nielsen
Theory related question. I'm being argumentative, I know. But this issue is in the same category as one discussed weeks ago. SQLite is, in a sense, typeless. All data is stored as text (ignore blob). Correct? It is when one casts a column to something other than text that triggers SQLite to treat

Re: [sqlite] Speaking of Ruby & Sqlite...a weekend oddity for someone

2016-12-10 Thread Don V Nielsen
out how to reinitiate the rake compile task after making the following update, then test. BINARY_VERSION = "3.15.2.0" URL_VERSION= "3150200" URL_PATH = "/2016" On Fri, Dec 9, 2016 at 5:27 PM, Roger Binns <rog...@rogerbinns.com> wrote: > On 09/12/16 14:0

[sqlite] Speaking of Ruby & Sqlite...a weekend oddity for someone

2016-12-09 Thread Don V Nielsen
I have an odd problem. It involves Linux & Windows, and it involves the ruby gem sqlite3. I've already contacted that author/maintainer of the gem, but I have not heard back in several weeks. I have a sql file that contains a ctas statement that employs cte with statements. On Windows, the sql

Re: [sqlite] using sqlite extensions within Ruby

2016-12-08 Thread Don V Nielsen
Documentation update to https://sqlite.org/sessionintro.html: "The session extension provide a mechanism". Should that read, "The session extension provides a mechanism"? dvn On Thu, Dec 8, 2016 at 9:23 AM, Don V Nielsen <donvniel...@gmail.com> wrote: > Like

Re: [sqlite] using sqlite extensions within Ruby

2016-12-08 Thread Don V Nielsen
Like you, I like ruby and working with sqlite via sqlite3 gem. So you have recompiled sqlite3 with the sessions extension. Correct? And this modified sqlite3 is the nearest sqlite3 available in your execution path. Correct? The sqlite_ruby library is an interface to sqlite3...the base model.

Re: [sqlite] like operator

2016-12-05 Thread Don V Nielsen
Igor, I'm not sure if you gain anything from"length(lower(name))". Just "length(name)" would suffice. On Mon, Dec 5, 2016 at 10:11 AM, Dominique Devienne wrote: > On Mon, Dec 5, 2016 at 4:24 PM, Igor Tandetnik wrote: > > > On 12/5/2016 10:19 AM, Igor

Re: [sqlite] Problem with CASE in WHERE clause

2016-12-04 Thread Don V Nielsen
Sorry, but the whole scenario is messy, at best. The column is declared bool, and then a string '1' is assigned to it. The case lacks an else, so it resulting in one of two types: a string when true and an integer when false. Correct? And then on top of that, as Simon pointed out, the column

Re: [sqlite] Table name syntax

2016-11-21 Thread Don V Nielsen
> And since the "*" forms are considered bad style I have done this, not knowing it is bad style. Can you provide some reasons why it is bad? I can assume, "Applications are supposed to be controlled environments, and using tbl.* introduces uncertainty outside the applications control." But are

Re: [sqlite] Strange problem with using random with a table

2016-11-11 Thread Don V Nielsen
Does the same thing happen if you select from Psalms, or Thessalonians, instead of Proverbs? Sorry. Little religion humor. Too early in the morning and I haven't had my coffee, yet. On Fri, Nov 11, 2016 at 4:34 AM, Cecil Westerhof wrote: > 2016-11-11 11:22 GMT+01:00

Re: [sqlite] Autoincrement sequence not updated by UPDATE

2016-10-31 Thread Don V Nielsen
> It guess it comes down to what one wants from "INTEGER PRIMARY KEY AUTOINCREMENT" What I would want, ...expect, is that a primary key autoincrement column would be left completely alone. And if was altered, it was altered on accident. I always thought "integer primary key" was synonymous with

Re: [sqlite] Development environment reccomendation

2016-10-25 Thread Don V Nielsen
Ruby to script out and automate the process. Could use Sinatra as a lightweight web interface, or go Rails for a full blown web service. On Mon, Oct 24, 2016 at 5:02 AM, Simon Slavin wrote: > > On 24 Oct 2016, at 6:26am, Philip Rhoades wrote: > > >

Re: [sqlite] Import 5000 xml files in a sqlite database file

2016-10-25 Thread Don V Nielsen
Ruby scripting language, using Nokogiri library to parse the html. On Sun, Oct 23, 2016 at 11:12 AM, Preguntón Cojonero Cabrón < preguntoncojon...@gmail.com> wrote: > Scripting powershell? C#? > > El 23/10/2016 18:04, "Sylvain Pointeau" > escribió: > > > hello, > > >

Re: [sqlite] .mode column .width .separator

2016-10-14 Thread Don V Nielsen
default The above f) & g) are not currently required of the user. It's messy when one thinks about it. dvn On Fri, Oct 14, 2016 at 2:27 PM, Don V Nielsen <donvniel...@gmail.com> wrote: > Thanks, David. I can read C, but I don't know how to compile it. :( Just > not a language I have lea

Re: [sqlite] .mode column .width .separator

2016-10-14 Thread Don V Nielsen
way you're wanting it to. > > Of course since I don't know C, by doing that I have no clue what else I > might just have broken which relied on the old format, but hey :) > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] &

Re: [sqlite] .mode column .width .separator

2016-10-14 Thread Don V Nielsen
pare to write in > specified format, write header > INSERT INTO mainframe_file SELECT ...; -> stuff in data, write record > DROP TABLE mainframe_file; -> close the file, write trailer record if > required > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun.

Re: [sqlite] .mode column .width .separator

2016-10-13 Thread Don V Nielsen
, 2016 at 3:31 PM, John McKown <john.archie.mck...@gmail.com> wrote: > On Thu, Oct 13, 2016 at 2:42 PM, Don V Nielsen <donvniel...@gmail.com> > wrote: > > > Thanks, but it appears that ".mode column" triggers it, and .separator > does > > not appear t

Re: [sqlite] .mode column .width .separator

2016-10-13 Thread Don V Nielsen
as literal characters. I've attempted: 0x0D0x0A, 0x0D0A, 0Dx0Ax. Nothing appears to work. dvn On Thu, Oct 13, 2016 at 2:11 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 13 Oct 2016, at 7:51pm, Don V Nielsen <donvniel...@gmail.com> wrote: > > > The .s

Re: [sqlite] .mode column .width .separator

2016-10-13 Thread Don V Nielsen
limit 10 ; On Thu, Oct 13, 2016 at 2:02 PM, Don V Nielsen <donvniel...@gmail.com> wrote: > These are simply blanks, 0x20, use to create separation of the output > columns. I'm assuming this is an inherent behavior for readability. If the > output was not being directed to the output

Re: [sqlite] .mode column .width .separator

2016-10-13 Thread Don V Nielsen
of the preprocessed data) and post processing (having to pass 10g of text data to removed blanks -- which is dangerous on its own.) dvn On Thu, Oct 13, 2016 at 1:56 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 13 Oct 2016, at 7:51pm, Don V Nielsen <donvniel...@g

[sqlite] .mode column .width .separator

2016-10-13 Thread Don V Nielsen
I am using the command line shell SQLite 3.14.2 2016-09-12. I'm working with mainframe data in a fixed format. I would like to use .mode column to create my output text file in a fixed layout. I set all my column widths using .width. I then output my data to a file. Unfortunately, there are two

[sqlite] Help needed for COPY Command.

2016-03-28 Thread Don V Nielsen
You need to handle the load yourself. Since you are talking bulk load, a scripting language is probably out of the question because they are too slow. I used C# with the System.Data.Sqlite binary. The db handling you need to worry about is the following: connection to db prepare an insert

[sqlite] sqlite fixed data loading extension

2016-03-27 Thread Don V Nielsen
of a simple mind. On Fri, Mar 25, 2016 at 4:48 PM, James K. Lowden wrote: > On Fri, 25 Mar 2016 06:49:22 -0500 > Don V Nielsen wrote: > > > I have a need for something that can parse and load into sqlite tables > > fixed length data. > > Insert your own

[sqlite] sqlite fixed data loading extension

2016-03-25 Thread Don V Nielsen
I have a need for something that can parse and load into sqlite tables fixed length data. I know sqlite has a csv import, so I would like to duplicate that kind of functionality handling fixed columnar data. I thought an extension would be perfect so I could specify something as simple as "sqlite3

[sqlite] SQLite Pronunciation

2016-03-17 Thread Don V Nielsen
> appear to know slightly what I was talking about O, I'm confident that I'm not the only one that relates to that assertion On Thu, Mar 17, 2016 at 12:25 PM, wrote: > > On 3/16/16, Daniel Telvock wrote: > > > >> I was at the Investigative Reporters and Editors Conference last week > >>

[sqlite] SQLite Pronunciation

2016-03-17 Thread Don V Nielsen
WHAT A GREAT VIDEO. Thanks for sharing. Everyone I work with...or worked with...that sees me work with SQLite (sequel lite to me) asks...what is that? why are using that? I love it. It is the best configuration manager. On Wed, Mar 16, 2016 at 2:09 PM, Jay Kreibich wrote: > > > IIRC, the

[sqlite] Parsing the contents of a field

2016-01-13 Thread Don V Nielsen
You will thank yourself by using a scripting language such Ruby, php, or python. Is there a reg ex library for sqlite that could be employed? On Tue, Jan 12, 2016 at 11:42 PM, audio muze wrote: > I have a table of roughly 500k records with a number of fields > containing delimited text that

[sqlite] website documentation wording

2015-12-04 Thread Don V Nielsen
Tangeant off this note, kind of a history question. "an SQLite". I personally would write "a SQL" because it is "sequel" to me. When did SQL--sequel become SQL--ess queue ell? I always remember it as being sequel, and it rolls off the tongue easier. And as sequel, it would be "a SQLite".

[sqlite] sqlite window functions extension?

2015-10-16 Thread Don V Nielsen
I'm disappointed. I killed it after 1.5hrs, and suspected everything you explained in the other thread. It is always true. Que Sera Sera dvn On Fri, Oct 16, 2015 at 2:33 PM, Igor Tandetnik wrote: > On 10/16/2015 3:23 PM, Don V Nielsen wrote: > >> limit ( >>SEL

[sqlite] sqlite window functions extension?

2015-10-16 Thread Don V Nielsen
and [a].crrt = [addresses].crrt limit ( SELECT net_non_pieces FROM crrt_net_non [b] WHERE [b].zip = zip AND [b].crrt = crrt ) ); commit; On Fri, Oct 16, 2015 at 9:24 AM, Don V Nielsen wrote: > The final solution at this point is Ruby. I really want to p

[sqlite] Puzzled about table alias and where they are accessible

2015-10-16 Thread Don V Nielsen
Given the following: select * from tmp_addresses [x] where rowid in ( select rowid from tmp_addresses [a] where a.version_id = '0060' and [a].zip = [x].zip and [a].crrt = [x].crrt limit ( SELECT net_non_pieces FROM crrt_net_non [b] WHERE [b].zip =

[sqlite] sqlite window functions extension?

2015-10-16 Thread Don V Nielsen
, Don V Nielsen wrote: > I'm surprised that and extension for this type of functionality has not > been been developed by someone with the c/c++. It's seems like a natural > fit. I wish I had the kind of ability & smarts to do it. > > On Thu, Oct 15, 2015 at 9:04 AM, Igor

[sqlite] sqlite window functions extension?

2015-10-15 Thread Don V Nielsen
I'm surprised that and extension for this type of functionality has not been been developed by someone with the c/c++. It's seems like a natural fit. I wish I had the kind of ability & smarts to do it. On Thu, Oct 15, 2015 at 9:04 AM, Igor Tandetnik wrote: > On 10/15/2015 9:36 AM

[sqlite] sqlite window functions extension?

2015-10-15 Thread Don V Nielsen
I will get to that some time today. On Wed, Oct 14, 2015 at 9:21 PM, Igor Tandetnik wrote: > On 10/14/2015 9:29 PM, Don V Nielsen wrote: > >> But I am having problems with the LIMIT statement. It throws an exception >> no matter what table alias is used: X or x2. It

[sqlite] sqlite window functions extension?

2015-10-14 Thread Don V Nielsen
ed, Oct 14, 2015 at 6:08 PM, Igor Tandetnik wrote: > On 10/14/2015 6:24 PM, Don V Nielsen wrote: > >> zip crrt version_id NUM segment >> [truncated num 1..38] >> 53001 R501 0060 39xx >> 53001 R501 0060 40xx >> 53001

[sqlite] sqlite window functions extension?

2015-10-14 Thread Don V Nielsen
ing without it. On Wed, Oct 14, 2015 at 4:27 PM, R.Smith wrote: > > > On 2015-10-14 11:20 PM, Don V Nielsen wrote: > >> X has columns zip & crrt, just like crrt_net_non. These form a composite >> key identifying groups within x. A value "53001.R501" wou

[sqlite] sqlite window functions extension?

2015-10-14 Thread Don V Nielsen
group sequence, then update a code of the first 42 rows of that sorted group, and then doing this until crrt_net_non is exhausted. On Wed, Oct 14, 2015 at 4:03 PM, Igor Tandetnik wrote: > On 10/14/2015 4:49 PM, Don V Nielsen wrote: > >> What am I looking to do? Using a table X, I've

[sqlite] sqlite window functions extension?

2015-10-14 Thread Don V Nielsen
Is there an extension to sqlite the provide window functions such as row_number over and partition? There are plenty of googles seeking said functionality. What am I looking to do? Using a table X, I've built a summary table, calculating a value called net_non_pieces. net_not_pieces is a qty

[sqlite] Using CTE with INSERT

2015-10-13 Thread Don V Nielsen
experience, dvn On Tue, Oct 13, 2015 at 8:28 AM, Don V Nielsen wrote: > The syntax "WITH p AS (SELECT 1) INSERT INTO t(x) SELECT * FROM p;" throws > the same exception: "[2015-10-13 08:20:22] [1] [SQLITE_ERROR] SQL error or > missing database (near ")": syn

[sqlite] Using CTE with INSERT

2015-10-13 Thread Don V Nielsen
The syntax "WITH p AS (SELECT 1) INSERT INTO t(x) SELECT * FROM p;" throws the same exception: "[2015-10-13 08:20:22] [1] [SQLITE_ERROR] SQL error or missing database (near ")": syntax error)" On Tue, Oct 13, 2015 at 8:17 AM, Clemens Ladisch wrote: > Don V

[sqlite] Using CTE with INSERT

2015-10-13 Thread Don V Nielsen
is incorrect, hopefully it conveys what I am trying to accomplish. Can someone assist? Your time and consideration is much appreciated. don v nielsen Note: CTAS would work in this scenario. But I cannot figure out that syntax, as well. insert into vo_crrt_pieces (recid) values ( with -- controls

[sqlite] CSV excel import

2015-07-31 Thread Don V Nielsen
I use the Ruby scripting language and its abundance of libraries to read excel files then write the output to sqlite. Those libraries, whether they r/w csv or excel files are robust, sometime robust beyond belief. They are likely more robust than what applications developers write into their

[sqlite] User-defined types

2015-06-05 Thread Don V Nielsen
> How can you defend SQL syntax other than on grounds of history or standardization? Short answer: QWERTY. Long answer: IBM mainframe DOS -> Z/OS. A 1960's o/s that is still supported by the inner workings of its most modern o/s. There's is nothing wrong with supporting the past. Sometimes

[sqlite] FW: Very poor SQLite performance when using Win8.1 + Intel RAID1

2015-03-26 Thread Don V Nielsen
This discussion, and you guys, are amazing. I am learning so much! On Wed, Mar 25, 2015 at 8:56 PM, Keith Medcalf wrote: > > On Wednesday, 25 March, 2015 10:42, Simon Slavin > said: > > >On 25 Mar 2015, at 1:47pm, Rob van der Stel < > RvanderStel at benelux.tokheim.com> wrote: > > >> One open

Re: [sqlite] Discrepancy with indexing and WHERE clause with AND/OR

2014-11-10 Thread Don V Nielsen
Isn't this the result of the results cache? The two queries are identical. On Mon, Nov 10, 2014 at 9:26 AM, Clemens Ladisch wrote: > RP McMurphy wrote: > > Is there a way we can make the w index work with both queries and not > > have to run external loops to flatten all

Re: [sqlite] SQLite as a meta database

2014-11-05 Thread Don V Nielsen
Wow! Please keep this discussion up-to-date because it is absolutely fascinating what all of you are doing. Thanks, dvn On Wed, Nov 5, 2014 at 8:36 AM, Hugo Mercier wrote: > Hi, > > Le 05/11/2014 14:16, Hick Gunter a écrit : > > Hi, > > > > we have extensive

Re: [sqlite] Single large table vs. several smaller tables

2014-10-09 Thread Don V Nielsen
> concerned with organizational clarity and correctness than efficiency >From my personal experience, Sqlite is so bloody fast I simply side table efficiency until it needs to be looked at. I can load 1.5 million name address records (500 bytes each), a second table of 3 million records (same

Re: [sqlite] Single large table vs. several smaller tables

2014-10-09 Thread Don V Nielsen
I suggest you group columns into a structures that you are comfortable with. I have a name, own a home, and have one car. Everything is singular to me, an individual. So if I have a table Individuals, do I want 25 columns that encompass name, address, year, make, and model of my car, type of

Re: [sqlite] Unhandled Exception: System.TypeInitializationException

2013-04-06 Thread Don V Nielsen
<be...@web.de> wrote: > Am 05.04.2013 22:19, schrieb Don V Nielsen: > > Thanks for reading. I am getting the following error moving a 32 bit >> application from Windows Server 2003 to WS2008. This is a straight copy >> from one computer to another. It runs fin

[sqlite] Unhandled Exception: System.TypeInitializationException

2013-04-05 Thread Don V Nielsen
Thanks for reading. I am getting the following error moving a 32 bit application from Windows Server 2003 to WS2008. This is a straight copy from one computer to another. It runs fine on WS2003 and not so good on WS2008. The application was compiled with VS2005. I do not have a development

Re: [sqlite] Parameterized SQL

2012-06-15 Thread Don V Nielsen
I use Ruby. In the following example I use a replacement tag "#{lvl}" in the scripts. For each of the levels (indv,hhld,resi), I do a substitution against the script and pass the script to sqlite. dbname = File.join('d:','cloveretl','projects','test_ii','data-out-97','test.db') db =

Re: [sqlite] Downgrade support for OS/2?

2012-04-03 Thread Don V Nielsen
Well. I know some banks and some transportation systems still use OS/2. Do they use sqlite? If yes, I'm sure their apps are stable, meaning their sqlite implementation is stable. Does sqlite need to continue for OS/2? Most likely not. Death of a friend. I always liked OS/2. It's still

Re: [sqlite] User input checking

2012-03-23 Thread Don V Nielsen
Ruby on Rails -- ActiveRecord. ActiveRecord prevents sql injections, I think. Using ERB in the html would give you that kind of functionality. Correct? dvn On Fri, Mar 23, 2012 at 2:49 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I also

Re: [sqlite] 64-bit Windows Command Shell

2012-03-22 Thread Don V Nielsen
There is a natural 5th extrapolation: 5) Could sqlite3 take advantage of multiple cpu's by parsing a single task into one thread per cpu and segment data to be worked by each thread? Big league stuff. But I don't think sqlite3 is meant to compete in that market. It already exceeds expectations

  1   2   >