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

[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] 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] SQLite Expert

2011-10-31 Thread Don V Nielsen
I use the free version of sqlite expert. I use sqlite for my IO handling. Having the power of sql available to test values, generate counts, etc... is indispensable. On Sun, Oct 30, 2011 at 2:50 PM, Abair Heart wrote: > Hi all, > > Searching the archives implies, that

[sqlite] UPDATE

2011-10-31 Thread Don V Nielsen
I need help with a complex UPDATE. I want to update each row in a table, calculating an average, and then apply that value back into a column of the same row. Is this possible with Sqlite? Below is code that should work with SqlServer; its UPDATE supports a FROM statement. UPDATE m SET rtwgt =

Re: [sqlite] UPDATE

2011-11-01 Thread Don V Nielsen
Tandetnik <itandet...@mvps.org> wrote: > Don V Nielsen <donvniel...@gmail.com> wrote: > > I need help with a complex UPDATE. I want to update each row in a table, > > calculating an average, and then apply that value back into a column of > the > > same row. Is this

Re: [sqlite] Slow INDEX

2011-11-02 Thread Don V Nielsen
I would like to stick my neck out over the chopping block and agree. My experience is the opposite, but appears to support Puneet's assertion. With me, it takes my C# application 12 seconds to pass 103,00 records and insert 98,000 rows into the db from it. The next time I run the application

[sqlite] Using "sub-select" to return limit

2011-11-03 Thread Don V Nielsen
Given the following, I get an error that f.zip does not exist. Obviously, I am mentally missing something contextually, but I'm not getting it. Would someone work through the scope of things in this select. select p.*,pr.rowid from pool_wi as p inner join add_priorities as pr on pr.prty =

Re: [sqlite] sql server management studio like tool for SQLite

2011-11-03 Thread Don V Nielsen
If you are looking to manage a database file, such as view the contents of tables, write and test scripts for processing, etc...there are a number of management packages. I like using Sqlite Expert. If you are looking for something that is going to do DTS, bulk imports, etc...I don't know what

Re: [sqlite] Using "sub-select" to return limit

2011-11-04 Thread Don V Nielsen
ly SQL. You have to select > data from your table of limits into your programming language, iterate > through results and for each row issue separate select statement with > appropriate limit (which will be a constant not a nested select > query). > > > Pavel > > > On Th

Re: [sqlite] Proper way to change temp directory

2011-11-21 Thread Don V Nielsen
In Ruby (just for giggles), its Dir.chdir('dir text') {|dir| # do your sort stuff here } # previous directory restored when logic block is completed On Sun, Nov 20, 2011 at 3:50 AM, Yang Zhang wrote: > Cool beans, perhaps this should be added to the docs! > > On

[sqlite] Confused by DELETE statement error

2011-11-21 Thread Don V Nielsen
I'm confused by the error message, "near 'order' : syntax error", with the following statement. The same statement, beginning with "select *" in place of "delete", will function fine. delete from seg_ny_adds where needid = 90 order by prty desc limit (select count() from seg_ny_adds where needid

[sqlite] Looping select

2011-11-29 Thread Don V Nielsen
This one is weird. And I don't know exactly what I have the ability to provide you for information. Below is the C# code I use to execute a query. And below that is what is ultimately translated and executed. The c# application appears to get hung up and loops. It burns cpu, but never stops.

Re: [sqlite] Looping select

2011-11-30 Thread Don V Nielsen
There is too much ambiguity with regards to needid; poor coding|edit checking on my part. When I label everything properly, then the query runs successfully (darn fast, too). I also changed the replacement tag @depth to @dpth. When I was examining everything with notepad++, it highlighted

Re: [sqlite] SQLite with Vis. Studio C# Entity Framework 4.1

2011-12-14 Thread Don V Nielsen
While I love working with C# and Sqlite, I'm quite an amateur at it even though I'm doing some sophisticated programming for my employer. And even less at exploiting the capabilities of Visual Studio in helping me. Below is a very typical routine for me. I use string.Format a lot to assemble

Re: [sqlite] SQLite with Vis. Studio C#

2011-12-16 Thread Don V Nielsen
My application never uses a DataSet. I push all db responsibility to sqlite. It returns DbDataReaders when I need to recurse through results. On Thu, Dec 15, 2011 at 1:40 PM, Jeff Matthews wrote: > Regarding my earlier question as to .NET SQlite syntax, I was wondering if >

Re: [sqlite] FW: Which version of SQLite?

2011-12-16 Thread Don V Nielsen
Ruby is awesome, especially when working with Sqlite...using ActiveRecord. But its I/O is really slow, so propagating a database is not its thing. dvn On Wed, Dec 14, 2011 at 8:32 PM, Nataraj S Narayan wrote: > Hi > > I am also an ex-clipper. I miss the old 'code blocks'

Re: [sqlite] Parameters are not allowed in views

2011-12-22 Thread Don V Nielsen
Where can I learn more about "restrict it". I'm not familiar with the syntax for using the question mark. Is there a specific part of the documentation that explains it and how it works? Thanks, dvn On Wed, Dec 21, 2011 at 5:00 PM, Petite Abeille wrote: > > On Dec

Re: [sqlite] Optimizing a query with range comparison.

2011-12-27 Thread Don V Nielsen
I do something similar, where the ranges are zip codes. However, my tableb is arranged vertically with one key (zip code) and one value (geographic zone). I would then join the two tables using the zip code, rather than trying to identify the zip code within a range of zip codes in tableb.

[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] 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
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] 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] 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
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
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-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-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-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] 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
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] 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] 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] 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] 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 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 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] 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] 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] 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] C# amalgamation hand holding requested

2012-01-20 Thread Don V Nielsen
I need help using the amalgamation in my projects. I simply do not know what steps to take in VS to implement it. I have some fairly elaborate projects that I have been redeveloping to use sqlite instead of .net structure and memory functions. One project is complete, but it uses the sqlite

Re: [sqlite] C# amalgamation hand holding requested

2012-01-24 Thread Don V Nielsen
Ok. So I am doing things correctly. I am already doing things correctly. I am using the provided .NET dll. I copy it to my local project. And when that project moves to production, it will be in the project's .bin folder. I should not have to worry about the dll hell associated with HP and

Re: [sqlite] C# amalgamation hand holding requested

2012-01-25 Thread Don V Nielsen
entist > > > > Advanced Analytics Directorate > > > > Advanced GEOINT Solutions Operating Unit > > > > Northrop Grumman Information Systems > > > > > > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@s

Re: [sqlite] support of %y in strftime()

2012-02-03 Thread Don V Nielsen
But if we don't start worrying about the year 10,000 now, then we'll end of having another disaster like Y2k. Oh yeah, that amounted to big fat thud. Never mind. :) On Fri, Feb 3, 2012 at 8:39 AM, Black, Michael (IS) wrote: > Non-standard ISO formatalready doable

Re: [sqlite] Inserts get slower and slower

2012-02-09 Thread Don V Nielsen
I've noticed a similar thing happening. The first 1/3rd loads quickly; the remain 2/3rds stagnates. It appears that there is some kind of bottleneck happening. I thought it was the SAN. My application begins a transaction, does all its inserts, and then commits. There could be millions in the

Re: [sqlite] SQLite shell dot commands

2012-02-24 Thread Don V Nielsen
Please, I don't mean this to be offensive. I'm not. It was suggested that the syntax "[Ben's table]" is cumbersome. What is really cumbersome, in my opinion, is the table name itself. The table name includes an white space (space) and a delimiting character (apostrophe.) The simple table name

Re: [sqlite] Inserts get slower and slower

2012-02-24 Thread Don V Nielsen
hael D. Black > > Senior Scientist > > Advanced Analytics Directorate > > Advanced GEOINT Solutions Operating Unit > > Northrop Grumman Information Systems > > ____________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] > on

Re: [sqlite] Limit on the Compound Select Statements

2012-02-24 Thread Don V Nielsen
Would it make more sense to put the values into a text file and import the text file? It separates the data from the application, and simplifies making future changes to the list. On Thu, Feb 23, 2012 at 1:52 PM, Abhinav Upadhyay < er.abhinav.upadh...@gmail.com> wrote: > On Thu, Feb 23, 2012 at

Re: [sqlite] Inserts get slower and slower

2012-02-24 Thread Don V Nielsen
• CDG.UtiI.FL_FirstLogic.Parse_FmtDef.Parse(RecordString) 0.62 % [Native or optirnized code] 191 ms 4 Thread #2 • 30,628 ms 100.00 % [Native or optimized code] 30,628 ms On Thu, Feb 23, 2012 at 4:02 PM, Don V Nielsen <donvniel...@gmail.com>wrote: > Follow-up on this issue. > > This morning I used a JetBrains

Re: [sqlite] read each line in sqlite database

2012-03-01 Thread Don V Nielsen
I think Simon's solution is in error, and Igor's is correct. In Simon's case, Slevel will be set to 1 if price1 is greater than 30. However, the original c function would set Slevel to 2 because price1 is greater than 12 and it is greater than 30. Two increments of i are executed in that

Re: [sqlite] read each line in sqlite database

2012-03-01 Thread Don V Nielsen
Ya know, if you ever wanted to deviate from the SQL standard, a handy upgrade to the CASE statement would permit split conditions on the case and when statement, as in: Case price1 when > 12 then 1 when > 30 then 2 else 0 end dvn On Thu, Mar 1, 2012 at 12:43 PM, Don V Nielsen <

Re: [sqlite] What do people think of SQLite Root?

2012-03-07 Thread Don V Nielsen
Thumbs up on SqliteExpert. I use it too. Very nice. dvn On Tue, Mar 6, 2012 at 7:20 PM, Stephen Chrzanowski wrote: > I use SQLite Expert. There is a fee for the professional version, but it > is one time, all updates are free. > > http://www.sqliteexpert.com/ > > > On

Re: [sqlite] why one row's results isn't the same between program and command shell

2012-03-21 Thread Don V Nielsen
Doh! Know the feeling. Well! On Wed, Mar 21, 2012 at 2:38 PM, Simon Slavin wrote: > > On 21 Mar 2012, at 7:35pm, Adam DeVita wrote: > > > Sorry for false alarm. Please disregard this thread: > > > > Solution: make sure you quit everything and

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

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

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

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

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

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

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

  1   2   >