Re: [sqlite] Fossil Public Accounts

J. King, on Tuesday, October 1, 2019 10:02 AM, wrote... > > On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera, on > > > >Is there a Fossil public account site like git? I believe there are a > >lot of people that can use something like that. Thoughts? Or not. [clip] > >

[sqlite] Fossil Public Accounts

Is there a Fossil public account site like git? I believe there are a lot of people that can use something like that. Thoughts? Or not. josé ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Fossil Public Accounts

On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera wrote: > >Is there a Fossil public account site like git? I believe there are a >lot of people that can use something like that. Thoughts? Or not. > >josé >___ >sqlite-users mailing list

Re: [sqlite] Newbie Issues with COLLATE

Thanks, Richard and Keith for your very helpful information. I suspected that programmers could "hide" custom collations away from prying eyes using the API. I've scanned all files in the software's Program folder using a content search for those collation names (Super Finder XT) and found

Re: [sqlite] Import XLS file?

You might like to consider the xlsx virtual table I wrote last year: https://github.com/jakethaw/xlsx_vtab Note that this only works for xlsx files, and may have unexpected results in some circumstances (e.g. merged cells). On Wed, Oct 2, 2019 at 4:39 AM Winfried wrote: > > Hello, > > I need

Re: [sqlite] Lookup join

Thanks Keith! I have spent several days trying to tune my query towards expected performance, without luck. I somehow missed your fairly straight forward solution. I still have some problems making sqlite use the correct indexes, but this can at least be fixed by well-placed INDEXED-BY-hints. The

Re: [sqlite] Lookup join

It may not be perfect, but it is impressive. Impressive and frustrating are not mutually exclusive :) Anyway, I'm probably not a typical sqlite user. I use sqlite as a simple indexing system, where all reads are expected to hit an index and return instantly. For this project, direct control over

Re: [sqlite] Lookup join

I have run analyze on production data, that should work better, right? Or do you propose to "trick" the query-planner using some kind of staging-data? Anyway, I use INDEXED BY hints now, and this solves my problem. Fredrik On Tue, Oct 1, 2019 at 8:57 PM Simon Slavin wrote: > When trying to

[sqlite] extension_functions.c - node_iterate blows stack

Hi all, I ran into an issue with the extension-functions.c file posted here, in that iterating through the binary tree representation for mode/median/quartile isn't done in a tail recursive way, which can cause a stack frame violation:

Re: [sqlite] Import XLS file?

Simon Slavin-3 wrote > 1) export your XLS data in CSV format > 2) Use the SQLite shell tool to import the CSV data into your database Thanks. Is there a free (beer|speech) tool to convert an XLS file into CSV, for Windows or Linux that you would recommend? -- Sent from:

[sqlite] Newbie Issues with COLLATE

(System environment: Windows 10 using sqlite-tools-win32-x86-329.zip, running SQLite3.exe as administrator) I'm a newbie to SQLite but not to SQL. Apologies in advance if this has been covered in the Archives and I just haven't found it after two days of searching. I'm trying to use

Re: [sqlite] Import XLS file?

On 1 Oct 2019, at 7:47pm, Winfried wrote: > I need to import an XLS file into SQLite. I recommend a two-part solution, because so many programs understand CSV file format. 1) export your XLS data in CSV format 2) Use the SQLite shell tool to import the CSV data into your database For part 2,

[sqlite] Option --disable-static-shell breaks .dbinfo command

Hello, When building with the --disable-static-shell configure option from the autoconf release package, it looks like the sqlite default CFLAGS only get passed into direct gcc invocations and not the libtool invocations. One consequence of this is that ".dbinfo" doesn't work because

Re: [sqlite] Fossil Public Accounts

On Oct 1, 2019, at 8:02 AM, J. King wrote: > > On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera > wrote: >> >> Is there a Fossil public account site like git? Git doesn’t provide public accounts. There are a number of *proprietary web services* that offer Git hosting, but don’t

Re: [sqlite] Import XLS file?

On 1 Oct 2019, at 7:58pm, Winfried wrote: > Is there a free (beer|speech) tool to convert an XLS file into CSV, for > Windows or Linux that you would recommend? Not really the topic of this forum. XLS is Microsoft Excel format. Excel has an 'export as CSV' feature. So if you used Excel to

Re: [sqlite] Newbie Issues with COLLATE

On 10/1/19, Jim and Carol Ingram wrote: > QUESTION > ONE: Are these "LOCALE_..." collations custom collations developed by the > software programmers, Yes. The application is using the sqlite3_create_collation() API (https://www.sqlite.org/c3ref/create_collation.html) to create a new collating

Re: [sqlite] Lookup join

Richard Hipp, on Tuesday, October 1, 2019 02:05 PM, wrote... > > On 10/1/19, Fredrik Larsen, on > > > > The declarative model of SQL is nice, but when you care about performance, > > it quickly gets frustrating and time consuming. > > In a perfect world, the query planner would recognize your

Re: [sqlite] Lookup join

On Tuesday, 1 October, 2019 11:58, Fredrik Larsen wrote: >Thanks Keith! I have spent several days trying to tune my query towards >expected performance, without luck. I somehow missed your fairly straight >forward solution. I still have some problems making sqlite use the >correct indexes, but

Re: [sqlite] Import XLS file?

On Oct 1, 2019, at 12:46 PM, Simon Slavin wrote: > > 1) export your XLS data in CSV format > 2) Use the SQLite shell tool to import the CSV data into your database Beware that SQLite’s CSV import requires that the imported data have the same number of columns as the table you’re importing it

Re: [sqlite] Lookup join

When trying to make SQLite pick the right index, please use this sequence. 1) Create your indexes. 2) Put typical example data in your table. 3) Use the ANALYZE command 4) Delete the test data and put in real data (optional) You can do (1) and (2) in any order. But having data in the table

Re: [sqlite] Lookup join

On 10/1/19, Fredrik Larsen wrote: > > The declarative model of SQL is nice, but when you care about performance, > it quickly gets frustrating and time consuming. In a perfect world, the query planner would recognize your intent and do the right thing. You would be able to write the query any

Re: [sqlite] Lookup join

Yes, your note about DESC ordering is the only thing missing now, and then everything will be perfect :) I have a build of sqlite with the GROUP-BY-DESC patch applied, but not able to test now. But previous testing using very similar queries did work fine so don't expect any problems. Now all my

Re: [sqlite] Lookup join

On 1 Oct 2019, at 8:15pm, Fredrik Larsen wrote: > I have run analyze on production data, that should work better, right? Yes, that is the best way to do it. I've been given some databases where the data saved by ANALYZE shows it was run with empty tables. So I sometimes warn people that

Re: [sqlite] Fossil Public Accounts

Warren Young, on Tuesday, October 1, 2019 12:38 PM, wrote... > > On Oct 1, 2019, at 8:02 AM, J. King, on > > > > On October 1, 2019 9:13:47 a.m. EDT, Jose Isaias Cabrera, on > >> > >> Is there a Fossil public account site like git? > > Git doesn’t provide public accounts. I don't use Git. :-) >

Re: [sqlite] Newbie Issues with COLLATE

On Tuesday, 1 October, 2019 11:22, Jim and Carol Ingram wrote: >I'm trying to use SQLite3.exe (the command-line executable) to do some >data mining of a database generated by a commercial software product that >incorporates the .dll version (I can see sqlite3.dll in its Program Files >folder).

[sqlite] Import XLS file?

Hello, I need to import an XLS file into SQLite. The web site doesn't seem to show how, and searching the archives here didn't help. FWIW, the data are in the file's first sheet, while other sheets only contain text

Re: [sqlite] Lookup join

> On Oct 1, 2019, at 1:05 PM, Richard Hipp wrote: > Alas, SQLite's query planner is not perfect. ...files bug report... “lacking perfection.” ;-) -j ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org