Re: [sqlite] DRH interview on why/how SQLite succeeded

DRH sounds so much more human in the podcast than the DRH I have assembled in my head from reading this mailing list. :) On Wed, Feb 19, 2020 at 11:39 AM Simon Slavin wrote: > > > Podcast / transcription of DRH interview: > > " We talked to Richard about the

Re: [sqlite] New word to replace "serverless"

As R Smith pointed out, you already have a good description in your existing documentation: "SQLite is a self-contained, server-free, zero-configuration ... " I would also throw in the term "library", because it is what it is. Sqlite is just non-executable code that doesn't function on it's own.

Re: [sqlite] Last record

Keith, what if one has a peanut allergy? On Tue, Oct 15, 2019 at 1:33 PM Jose Isaias Cabrera wrote: > > > Keith Medcalf, on Tuesday, October 15, 2019 02:26 PM, wrote... > > > > > > On Tuesday, 15 October, 2019 09:35, Philippe RIO, on > > > > >A short question : how could I know if I am reading

Re: [sqlite] Last record

Pardon me for being thick. But the end of what? The end of the sqlite file? The end of a table? The end of a select? I always thought there was no such thing as "a start or an end" as the database is basically air until you request something from it. Even when you have something, it could change

Re: [sqlite] Programming methodology (was DEF CON (wasL A license plate of NULL))

If I were to have coded that junk (and I do see it too many times to count), I would have coded it even junkier, as in bool is_true (bool tf) { if (tf == true) return true; else return false; } If it's single statement following an if and that statement isn't beyond 80 characters, I will

Re: [sqlite] Grammar police

Not to be argumentative with Keith, as I'm have the sinking feeling that slitting my own throat would be a more pleasurable experience. But, here it goes: A *lexicon* is a list of words that belong to a particular language. Sometimes, *lexicon* is used as another word for *thesaurus* (see below)

Re: [sqlite] Grammar police

Sorry. This was in the Quirks, Caveats page, #2. On Thu, Jul 11, 2019 at 9:57 AM Don V Nielsen wrote: > " An application interact with the database engine using function calls, > not be sending messages to a separate process or thread." > > "

[sqlite] Grammar police

" An application interact with the database engine using function calls, not be sending messages to a separate process or thread." "An applications [interacts] ..., [not by]... ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Making blob as a sqlite database.

Sorry to bother, Mohd. What is your use case? I mentioned this to developers around me and they are intrigued. You are storing a database file as blob in a database? We are curious as to the application. I am assuming the database being stored is a collection of sensor or event data? On Fri, Apr

Re: [sqlite] Documentation correction

On the heel of Tom's input is the fragment " then that name always refers the explicitly declared column". Should that be " then that name always refers *to* the explicitly declared column"? On Mon, Apr 15, 2019 at 3:32 PM wrote: > Hi, I just wanted to point out a minor discrepancy in the docs

Re: [sqlite] Can I get help with db design for SQLite use?

> Do be aware that almost all of us are just users like you. And be aware these guys are freakin brilliant. No lie. On Tue, Apr 2, 2019 at 10:26 AM Simon Slavin wrote: > On 2 Apr 2019, at 3:48pm, Tom Browder wrote: > > > I need help with a db design to be modeled for use with SQLite. The >

Re: [sqlite] Is there a tool to convert `where`s to equivalent `join`s?

> So for learning sake, is there a tool that converts a query using `WHERE` to a query (that yields identical results) using JOINs? I'm not aware of a tool, but I would assert that not using a tool is for learning sake. Recoding by hand is going to be your best learning experience. Note: there

Re: [sqlite] SQlite.NET.chm

Is the chm file on a server? I remember this problem from years ago...I haven't used a chm file in a long time. Unblocking did not fix it while it resided on the server. However, copying it locally and unblocking it did work. Hope this helps, dvn On Wed, Jan 9, 2019 at 11:29 AM Rizzuto, Raymond

Re: [sqlite] Grouping guidance

Two thumbs up on Igor. They say the quickest way to the correct answer is to post the wrong answer on the internet. Hypothesis just proven. On Thu, Dec 13, 2018 at 3:00 PM Igor Tandetnik wrote: > On 12/13/2018 3:41 PM, Igor Tandetnik wrote: > > On 12/13/2018 3:27 PM, Don V Niel

Re: [sqlite] Grouping guidance

Making a mountain out of a mole hill, but isn't the solution more complex that that? The description has to be Foo & Bar. But if given the following, then the simple answer dies. create table requests (request,task,description); insert into requests values ('REQ0090887','TASK0236753','Foo'),

Re: [sqlite] Displaying row count

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

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

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

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

"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"

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

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

> 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

> 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

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

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

> " 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

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 ?

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

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

"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

"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)

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?

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

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

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!!?

> 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

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

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

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

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?

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')

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')

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"

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

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

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

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

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

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?

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

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

> 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!!

"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

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

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

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

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"

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

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

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.

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.

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

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

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

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

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

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

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

> 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

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

> 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

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

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

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

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

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

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

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

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

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.

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

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

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

> 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

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

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

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?

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?

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

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?

, 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?

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?

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?

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?

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?

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?

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

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

  1   2   >