Re: [sqlite] [EXTERNAL] Re: Patch: VTable Column Affinity Question and Change Request

Hick Gunter wrote on Thursday, February 6, 2020 3:32 AM >We are almost exclusively using virtual tables to allow queries against our >internal data sources, >which are C language structs and thus strictly typed. The column affinities >provided by the VTab >implementations are used for

Re: [sqlite] FW: Questions about your "Performance Matters" talk re SQLite

Keith Medcalf Sent Saturday, January 04, 2020 3:29 PM >So I conclude that SERIALIZED/MULTITHREAD makes very little difference >and that MEMSTATUS ON/OFF makes a huge difference. Since the That's a potentially very useful observation! Is any of this available to JDBC users?

Re: [sqlite] Performance vs. memory trade-off question

ction heap space will be reduced. Is that correct? Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject

Re: [sqlite] Safe saving of in-memory db to disk file

. That sounds really intriguing- does it significantly speed up queries coming in through the SQLite engine? Or the speed bump is only if accessing from the C++-native side? Is there any literature out there or tips y

Re: [sqlite] Bug in table_info pragma

Please disregard, apologies for the noise. From: "Nelson, Erik - 2" Sent: May 17, 2019 8:17 AM To: sqlite-users@mailinglists.sqlite.org Subject: [External email from sqlite-users-boun...@mailinglists.sqlite.org] Re: [sqlite] Bug in table_info pragm

Re: [sqlite] Bug in table_info pragma

We need to get these into the hive database, if that's helpful From: Simon Slavin Sent: May 17, 2019 8:16 AM To: SQLite mailing list Subject: Re: [sqlite] Bug in table_info pragma On 17 May 2019, at 12:06pm, J. King wrote: > Then there would be no

Re: [sqlite] SETting a value to a field with multiple conditions

I maintained an in-house sqlite patch that did this for a number of years... just made the buffer a little bigger, printed something like " set tt.<==HERE" It was quite useful for helping application users self-serve their own query problems. -Original Message- From: sqlite-users

Re: [sqlite] Retrieve tables accessed by query

ry key, field1, field4); CREATE TABLE tbl2 (rowid integer primary key, field3, field2); sqlite> -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Nelson, Erik - 2 Sent: Tuesday, February 12, 2019 2:29 PM To: SQLite mailing list

Re: [sqlite] Retrieve tables accessed by query

hinking of something else here) -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Nelson, Erik - 2 Sent: Tuesday, February 12, 2019 1:00 PM To: SQLite mailing list Subject: Re: [sqlite] Retrieve tables accessed by query Clemens Ladisch Sent

Re: [sqlite] Retrieve tables accessed by query

here the tables *don't exist*. For example, I have a query and I want to find out which tables the query makes so I can create only those. This query is obviously not valid in the current database... will it still (for example) call the authorizer interface

[sqlite] sqlite as 'streaming mode' query engine?

Sqlite aggregation functions receive one call for each row in the underlying results set. Has anyone on the list done a virtual table that's a based on a stream? Something conceptually along the lines of Insert row a Insert row b begin aggregation on rows a, b insert row c insert row d update

Re: [sqlite] Is it possible to conditionally insert a record?

Can you use something along the lines of this? insert into max_value select value as "value" from source_table order by value desc limit 1; Shane Dev Sent: Wednesday, January 10, 2018 11:49 AM To: SQLite mailing list Subject: [sqlite] Is it possible to

Re: [sqlite] C++ compiler

Eli Sent: Saturday, December 30, 2017 6:36 AM >It would be awesome if SQLite could compile as a part of bigger C++ project. >Right now there is a bunch of pointer casting errors, that can be fixed in >a matter of hour IMHO. I don't have any trouble using it as part of a larger C++ project.

[sqlite] Committing and memory usage

Does committing reduce memory usage on a memory database with pragma journal_mode=off? I see advice to do periodic commits in order to reduce memory usage, but I'm wondering if that also applies to memory databases with journaling off.

Re: [sqlite] Move to Github!!?

to use a third party ticket system, fossil i missing >one of its big advantages. I'm no Fossil expert, but it does seem to have a ticketing system. Is there something in particular functionality missing? Erik -- This message

[sqlite] journal mode and transactions

The transactions documentation (https://sqlite.org/lang_transaction.html) states >If PRAGMA journal_mode is set to OFF (thus disabling the rollback journal file) then the behavior of the ROLLBACK command is undefined. Does that correspondingly mean there's no performance benefit to wrapping

[sqlite] generic advice for insert performance in-memory database optimization

I've got an in-memory database with a single table that I need to fill with ~500 million rows. There are no indexes and the table definitions is create table data(id int, path int, month int, val1 double, val2 double, val3 double... val20 double) I'm running on linux with the OS page size

Re: [sqlite] Kind of function out of common table expression

Yannick Duchêne Sent: Wednesday, December 20, 2017 5:23 PM >I wonder is there is a way with SQLite3, to reuse a often used and >moderately long common table expression without the need to copy/paste it in >every query text it is used in. I use a C preprocessor for this and pass the queries

Re: [sqlite] reate index implies analyze?

Great explanation, thanks -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Hick Gunter Sent: Wednesday, December 20, 2017 10:41 AM To: 'SQLite mailing list' Subject: Re: [sqlite] [EXTERNAL]

Re: [sqlite] [EXTERNAL] performance impact of index creation order

this would not be a first order performance issue in any event. I was just curious if anyone had insight into the relative merits of varying the index creation order. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von

[sqlite] performance impact of index creation order

Assuming that table 'data' is completely constructed, does index creation order have any performance ramifications? For example, would it be reasonable to assume that the order of these two statements has no performance impact? (all fields are integer in this case) create unique index

[sqlite] create index implies analyze?

If I am finished making inserts into a table, does the act of creating an index also populate the index? That is, do I need to separately run 'analyze'? My impression was that there was no need to call analyze unless rows had been inserted after index creation.

Re: [sqlite] Odd question

Mark Sent: Tuesday, December 19, 2017 1:32 AM On Mon Dec 18, 2017 at 04:48:27PM +, Nelson, Erik - 2 wrote: > Nomad Sent: Sunday, December 17, 2017 4:11 PM > >On Sat Dec 16, 2017 at 07:53:22PM +, Nelson, Erik - 2 wrote: > > >> Select 1 as value from (insert into

Re: [sqlite] Odd question

Keith Medcalf Sent: Monday, December 18, 2017 2:31 PM ...snipped a lot... >>Right, all of the statements are step'd regardless of the result of >>sqlite3_column_count(). SQLITE_DONE is returned from the first >>step() for insert queries. >>In pseudocode, it's >>prepare("insert...") //okay

Re: [sqlite] Odd question

Keith Medcalf Sent: Monday, December 18, 2017 1:07 PM To: SQLite mailing list Subject: Re: [sqlite] Odd question >>I investigated a further while exploring some of the list >>suggestions. The app halts with an error unless >>sqlite3_column_count() > 0.

Re: [sqlite] Odd question

Kees Nuyt Sent: Monday, December 18, 2017 12:51 PM On Sat, 16 Dec 2017 21:43:44 +, "Nelson, Erik - 2" <erik.l.nel...@bankofamerica.com> wrote: >> I'm using an application that I can't change. >> I can give it multiple queries to run but the >> a

Re: [sqlite] Odd question

Keith Medcalf Sent: Sunday, December 17, 2017 4:30 PM >How do you know the insert is not working? Have you verified that the data is >not being inserted or are you simply relying on a popup provided by the >application? If the later, you should be aware that the application can >pop-up

Re: [sqlite] Odd question

Peter Da Silva Sent: Monday, December 18, 2017 12:24 PM >What I don’t understand is this app that’s making SQLite calls, so it’s using >the SQLite library, and it’s expecting a result from updates and inserts? Yes, exactly. The app designers assumed that rows are returned from every

Re: [sqlite] Odd question

Nomad Sent: Sunday, December 17, 2017 4:11 PM >On Sat Dec 16, 2017 at 07:53:22PM +, Nelson, Erik - 2 wrote: >> For unfortunate reasons, I need a query that does an insert and also >> returns at least one row... for example, something along the lines of >> Select 1

Re: [sqlite] Odd question

Nelson, Erik - 2 Sent: Saturday, December 16, 2017 5:27 PM >Petern wrote on Saturday, December 16, 2017 4:53 PM >>Re: Nelson "odd". This will make the desired (?) side effect happen: >>.load eval.so >>SELECT coalesce(eval('INSERT INTO table1 VALUES(a, b,

Re: [sqlite] Odd question

Simon Slavin wrote on Saturday, December 16, 2017 5:15 PM >>On 16 Dec 2017, at 9:43pm, Nelson, Erik - 2 <erik.l.nel...@bankofamerica.com> >>wrote: >> I'm using an application that I can't change. I can give it multiple >> queries to run but the application assume

Re: [sqlite] Odd question

Petern wrote on Saturday, December 16, 2017 4:53 PM Re: Nelson "odd". This will make the desired (?) side effect happen: >.load eval.so >SELECT coalesce(eval('INSERT INTO table1 VALUES(a, b, c)'), 1) AS value; >If INSERT references columns from an outer scope then use printf() inside the

Re: [sqlite] Odd question

org] On Behalf Of Nelson, Erik - 2 >Sent: Saturday, 16 December, 2017 12:53 >To: SQLite mailing list >Subject: [sqlite] Odd question > >For unfortunate reasons, I need a query that does an insert and also >returns at least one row... for example, something along the lines of >

[sqlite] Odd question

For unfortunate reasons, I need a query that does an insert and also returns at least one row... for example, something along the lines of Select 1 as value from (insert into table1 values(a, b, c)) Or Select coalesce((insert into table1 values(a, b, c)), 1) as value I've tried a number of

Re: [sqlite] Need SQLite datafiles to be locked on OS level(Windows)

Simon Slavin wrote on Monday, November 27, 2017 12:39 PM > Subject: Re: [sqlite] Need SQLite datafiles to be locked on OS level(Windows) > > On 27 Nov 2017, at 4:51pm, Joe Mistachkin wrote: > > > Judging from the description so far, I think that both SQLite and > >

Re: [sqlite] Need SQLite datafiles to be locked on OS level (Windows)

Jirí Matejka Sent on Friday, November 24, 2017 3:45 AM >but this does not prevent reading and modifying the file from other >processes while they are open by SQLite in our process. Does antivirus or Windows randomly modify other applications' files? It seems like no program could reliably

[sqlite] SQLITE_DETERMINISTIC sticky in sqlite3_create_function?

If I'm redefining a user-defined function as SQLITE_DETERMINISTIC before each query, will the function still get called for subsequent queries? For example, if I had void user_func(sqlite3_context *context, int argc, sqlite3_value **argv){ return random() } sqlite3_create_function(db,

[sqlite] extension to query/set environment variables?

Hello, I could imagine a virtual table that held all the environment variables, or a user-defined function to get or set environment variables. Does anyone know of anything in the wild along these lines? I know how I would implement it, wanted to see if someone else already had. Erik

Re: [sqlite] sqlite3_create_function xFinal argument called when there's an error?

error? > > Nelson, Erik - 2 wrote: > > for aggregate functions, is xFinal called if there's an error? > > Yes; it's always called when SQLite cleans up the context. > > >Clemens wrote: Thanks! In that case, should any result be set in xFinal? Like sqlite3_result_e

[sqlite] sqlite3_create_function xFinal argument called when there's an error?

-1); If that error happens, does percentFinal still get called to clean up the memory? Or does it leak? Thanks Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is priv

Re: [sqlite] sqlite3 feature or regression

Thanks for taking the time to send in the report and thanks to all who investigated it. The robust discussion demonstrates the passion of the sqlite community, and I enjoy thinking about the various points as they are made. From: [Vermes Mátyás

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

of use to a mobile device on the download page, and it seems like mobile devices (at least ones with small screens) are not well suited to reading technical documentation, no matter how 'responsive'. Erik -- This message, a

[sqlite] Issue with entity framework

You cannot use EF Model First with SQLite, no tooling has been made available for that Mvh / Regards Erik Ejlskov Jensen http://twitter.com/erikej ___ sqlite-users mailing list sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

As an alternative to the System.data.sqlite design tools (depending on your requirements) you can use my free VS extension "SQLite Toolbox" https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/ Mvh / Regards Erik Ejlskov Jensen http://twitter.

[sqlite] error messages from SQLite

I've seen a small patch along the lines of this used. I'm sure it could be improved, but it seems like it often would give a bit more context. Token msg; msg.z = pParse->zTail; msg.n = pParse->sLastToken.z - pParse->zTail + pParse->sLastToken.n; if(msg.n > 36) { msg.z = msg.z +

[sqlite] Problem with accumulating decimal values

Frank Millman Friday, December 11, 2015 9:21 AM > > I am having a problem accumulating decimal values. > > sqlite> UPDATE fmtemp SET balance = balance + 123.45; SELECT bal FROM > sqlite> fmtemp; > 6049.049 > > Can anyone explain what is going on, and is there a way to avoid it? >

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

Richard Hipp Sent: Tuesday, November 10, 2015 2:41 PM > > http://engineering.microsoft.com/2015/10/29/sqlite-in-windows-10/ Congratulations! -- This message, and any attachments, is for the intended recipient(s) only, may

[sqlite] field name in UDF

Stephan Beal Sent: Saturday, November 07, 2015 3:54 AM > On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 < > erik.l.nelson at bankofamerica.com> wrote: > > > I have a user-defined function something like > > > > void quarter_sqlite3(sqlite3_context *context, int

[sqlite] field name in UDF

Stephan Beal wrote on Friday, November 06, 2015 1:00 PM > On Fri, Nov 6, 2015 at 6:50 PM, Nelson, Erik - 2 wrote: > > > I have a user-defined function something like > > > > void quarter_sqlite3(sqlite3_context *context, int argc, > sqlite3_value > > **argv); >

[sqlite] field name in UDF

I have a user-defined function something like void quarter_sqlite3(sqlite3_context *context, int argc, sqlite3_value **argv); for each sqlite3_value being passed in, it would sometimes be helpful to have the associated field (if any) that the value is associated with. Is there any way to

[sqlite] accessing database from Lua and C

Simon Slavin wrote on Sunday, October 25, 2015 6:59 AM > On 25 Oct 2015, at 10:05am, Lev wrote: > > > Untill now my architecture does all the SQLite work in C, and pass > > simple variables on Lua's stack. > > > > Today morning I've got an idea to push only the database connection > object. > >

[sqlite] UPDATE silently failing

Hugues Bruant wrote on Wednesday, September 23, 2015 2:06 AM > > > in some cases the SIndex captured inside the first lambda (UPDATE > > > statement) appeared to be null even though it wasn't null in the > > > enclosing scope (setVersion_) > > > > Interesting (and disturbing) result. Is this with

[sqlite] UPDATE silently failing

R.Smith wrote on Tuesday, September 22, 2015 10:08 AM > > On 2015-09-22 03:58 PM, Hugues Bruant wrote: > > SIndex sidx is just a boxed immutable integer. Its value is bound to > > the UPDATE and the trace shows it to be 0 But the log line printed > > when the number of rows updated is zero

[sqlite] Feedback request: JSON support in SQLite

t() already has the functionality, I've found that the json_array_* functions can be complemented by a json_array_index() function that returns the value at a given index into the array. Erik -- This message, and any attachments, is f

[sqlite] Lua inside SQLite

Abilio Marques wrote on Sunday, August 23, 2015 4:42 PM > > 3. Lua can return arrays. Also, Lua can return multiple values. Tried > to take advantage of those facts, but while reading the SQLite API > documentation, found no function where I could map multiple values as > the return of a

[sqlite] Determine query type

> users-bounces at mailinglists.sqlite.org] On Behalf Of Scott Hess wrote on > Thursday, August 06, 2015 1:11 PM > > Also consider https://www.sqlite.org/c3ref/stmt_readonly.html > > On Thu, Aug 6, 2015 at 10:08 AM, Stephan Beal > wrote: > > > On Thu, Aug 6, 2015 at 6:57 PM, Ben Newberg >

[sqlite] SQLite Entity Framework Provider

Joe, There are a number of interfaces that you need to implement in order to support migrations. You can look at the SQL Server and the SQL Server Compact providers in the EF source. Feel free to contact me directly. Ideally, the source code for System.data.sqlite should be hosted on

[sqlite] SQLite EF provider

Hi Michel. A fully featured EF provider is available from DevArt. https://www.devart.com/dotconnect/sqlite/ /Erik Sendt fra Windows Mail

[sqlite] User-defined types -- in Andl

e are perfectly productive using C/C++. Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms

[sqlite] SQLite to SQL Server

-4afb-b5e9-6e74d369f7a1/view/Reviews Mvh / Regards Erik Ejlskov Jensen http://twitter.com/erikej

[sqlite] Getting a crash on 32-bit Linux

Ron Aaron wrote on Tuesday, April 14, 2015 1:51 PM >Something is very wrong, then. The file I downloaded from the sqlite.org >site, and unzipped, has these: >-rw-r--r--@ 1 ron staff 5507061 Apr 8 17:38 sqlite3.c Can you confirm that this file came from the .zip file, not the .gz file? >>

[sqlite] Database connection from within Visual Studio

Yes, there a several things that could be done, given statistics on number of downloads. A simple fix could be to reverse the order of the .net framework versions listed, so list 4,5,1 at the top and 2,0 at the bottom. And then Group all downloads for a Framework version together, instead of

[sqlite] Database connection from within Visual Studio

Maybe a smaller number of downloads and a more readable download page would improve the user experience here. Mvh / Regards Erik Ejlskov Jensen http://twitter.com/erikej

[sqlite] SQLite Toolbox - free Visual Studio extension

I have recently released this free VS addin, also Works with the free VS 2013 Community edition. Blog post: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Channel 9 video: http://channel9.msdn.com/Shows/Visual-Studio-Toolbox/SQL-Server-Compact-and-SQLite-Toolbox

Re: [sqlite] Looking for SQLite schema doc generator (in

Thanks, I simply adapted this: https://sqldbdoc.codeplex.com/ And you can modify the xlst file if you have the guts Sendt fra Windows Mail Fra: gerald.ba...@gmail.com Sendt: ‎tirsdag‎, ‎3‎. ‎februar‎ ‎2015 ‎18‎:‎29 Til: Erik Ejlskov Jensen Cc: rsm...@rsweb.co.za, sqlite-users

Re: [sqlite] Looking for SQLite schema doc generator (in

Thanks, I simply adapted this: https://sqldbdoc.codeplex.com/ And you can modify the xlst file if you have the guts Sendt fra Windows Mail Fra: gerald.ba...@gmail.com Sendt: ‎tirsdag‎, ‎3‎. ‎februar‎ ‎2015 ‎18‎:‎29 Til: Erik Ejlskov Jensen Cc: rsm...@rsweb.co.za, sqlite-users

Re: [sqlite] Looking for SQLite schema doc generator (in

You can use my Visual Studio addin: SQLite Toolbox to do this: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Sendt fra Windows Mail ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Looking for SQLite schema doc generator (in

You can use my Visual Studio addin: SQLite Toolbox to do this: http://erikej.blogspot.dk/2014/08/sqlite-toolbox-40-visual-guide-of.html Sendt fra Windows Mail ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Shell tool improvement request

an I can't imagine another import like the one above > existing in real life, but certainly an actual unclosed quote might be > a common mistake in some new export system (which maybe one is > designing for ones

Re: [sqlite] sqlite3_bind_text and strings that look like numbers

Simon Slavin wrote on Tuesday, January 06, 2015 3:00 PM > > On 6 Jan 2015, at 7:49pm, Nelson, Erik - 2 > <erik.l.nel...@bankofamerica.com> wrote: > > > Is there any way to force the bind_text() to store the input text > verbatim? > > Another possibility is tha

Re: [sqlite] sqlite3_bind_text and strings that look like numbers

Richard Hipp wrote Tuesday, January 06, 2015 3:04 PM > On 1/6/15, Nelson, Erik - 2 <erik.l.nel...@bankofamerica.com> wrote: > > > > converts the value to a textual scientific notation representation, > > like > > Nope. SQLite is not doing this. Something else is

[sqlite] sqlite3_bind_text and strings that look like numbers

This is part of a larger application, but what I *think* is happening is using a table definition like create table tester(id text collate nocase) and a prepared statement like insert into tester values(?) then calling bind something like this pseudocode sqlite3_bind_text(stmt, column,

Re: [sqlite] VACUUM requires 6.7 times space ?

Simon Slavin wrote on Monday, January 05, 2015 10:40 AM > > On 5 Jan 2015, at 2:43pm, Nelson, Erik - 2 > <erik.l.nel...@bankofamerica.com> wrote: > > > RSmith wrote on Monday, January 05, 2015 7:43 AM > > > >> I haven't done this, but I seem to remember th

Re: [sqlite] VACUUM requires 6.7 times space ?

RSmith wrote on Monday, January 05, 2015 7:43 AM > > On 2015/01/05 13:32, Dan Kennedy wrote: > > On 01/05/2015 06:22 PM, Simon Slavin wrote: > >> I have a database file which is 120GB in size. It consists of two > huge tables and an index. //... > > Probably running out of space wherever temp

Re: [sqlite] Whish List for 2015

) or some instructions for manual > compilation? 'We' is my dev team. There's no open source project, it's just a part of our internal application. I don't have a makefile or instructions- it may not be a good fit for your situation. Erik --

Re: [sqlite] Whish List for 2015

enough, as the recipient > also need to install other components besides SQLite3. FWIW, we just compile the lua interpreter together with sqlite3. Installing the resulting binary should take care of both of your requirements. Erik -

Re: [sqlite] Counting rows

unt the rows in less than a few hours ? > Might it be possible to write a trigger that keeps track of insertions/deletions and updates a counter in another table? As another data point, I tested an 8 GB database on a SAN that has about 14 million rows, count(*) takes about 7

Re: [sqlite] Serializing an object's vector or array using sqlite3 in c++

ost speed-and-size happy and can > easily be saved as a BLOB in any RDBMS (including SQLite) but the I serialize into binary BLOBs using the Boost Serialization library. It's probably not worth adding Boost to your project j

Re: [sqlite] query REAL without trailing decimal and zero?

Richard Hipp wrote on Monday, September 15, 2014 3:16 PM > On Mon, Sep 15, 2014 at 3:02 PM, Nelson, Erik - 2 < > erik.l.nel...@bankofamerica.com> wrote: > > > When I query a field defined with type 'real', I get '.0' appended to > > the results for whole numbers

[sqlite] query REAL without trailing decimal and zero?

luded. http://en.wikipedia.org/wiki/Printf_format_string#Type Any tips would be appreciated! Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confiden

Re: [sqlite] Request to change int parameter to size_t parameter / potential bug on iOS (64 bit)

> Roger Binns wrote on Sunday, September 07, 2014 2:30 PM > On 07/09/14 11:19, Richard Hipp wrote: > > Please use a cast to silence the compiler warnings. > "(int)sizeof(...)" > > instead of just "sizeof(...)". > > That isn't safe for correctly written 64 bit apps. For example they > could end

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

Bob Moran wrote on: Friday, September 05, 2014 12:07 AM > On Wed, Sep 3, 2014 at 1:29 PM, Nelson, Erik - 2 < > erik.l.nel...@bankofamerica.com> wrote: > > > Bob Moran wrote on Wednesday, September 03, 2014 12:45 PM > > > > > > One added note: My GUI is using

Re: [sqlite] Problems uploading CSV into sqlite3 DB

Carlos A. Gorricho (HGSAS) wrote on Friday, September 05, 2014 4:17 AM >So, any ideas on how to solve this issue will be more than welcome. I have >tried several shortcuts...none works. >Latest was to install an Ubuntu 14.04 Virtual Machine on my Mac, via Parallels >software. > Maybe line

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

*** Returns str as a const char *. This is equivalent to str.toLocal8Bit().constData(). The char pointer will be invalid after the statement in which qPrintable() is used. This is because the array returned by toLocal8Bit() will fall out of scope. Your str is likely po

Re: [sqlite] Window functions?

Stephan Beal wrote on Monday, August 25, 2014 3:26 PM > > For the small percentage of users who need it (or would even know how > to apply it). i've been following this list since 2006 or 2007 and i > recall this topic having come up only a small handful of times, which > implies that only a

Re: [sqlite] Importing ~1000 CSV files faster

Joe Fisher wrote on Tuesday, August 19, 2014 5:11 PM > I use the temp table because every CSV files has a header with the > column names. Can you just import the files, header row and all, into your destination table and just delete the 2000 header rows at the end?

Re: [sqlite] Vacuum command fails

doesn't have enough space, the VACUUM will fail. Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to imp

Re: [sqlite] Vacuum command fails

generated in /tmp, then /tmp needs to have sufficient free space. In my experience, /tmp is frequently too small to vacuum large databases. The tmp location can be controlled by a (deprecated, IIRC, and hopefully never removed) pragma. Erik -

Re: [sqlite] Performace problem with SELECT after normalization

Hello Clemens, Friday, July 4, 2014, 1:43:47 PM, you wrote: CL> Erik Jensen wrote: >> > If the list of categories does not change, you could assign the >> > category IDs so that they have the same order as the names. >> >> Yes, that was my idea too i

Re: [sqlite] Performace problem with SELECT after normalization

Hello Clemens, thanks for your response. >> But in 1.4m entries, the "category" field only had around 7000 >> different entries, this was a big waste of space. >> >> So i split it up into two tables: >> >> CREATE TABLE categories ( >> id INTEGER NOT NULL PRIMARY KEY, >> name TEXT NOT NULL

[sqlite] Performace problem with SELECT after normalization

Hello. I'm pretty much an SQL newbie, so please bear with me. I have a performance problem after normalizing a table. First i had a single flat table, that looked like this: CREATE TABLE products ( id INTEGER NOT NULL PRIMARY KEY, category TEXT NOT NULL DEFAULT '', weight INTEGER NOT

Re: [sqlite] Is 32bit SQLite limited to 1900mb RAM in windows?

QLite is cleanly addressing the larger space. Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important ter

Re: [sqlite] detect database/table/field use

Roger Binns wrote on Thursday, June 26, 2014 5:38 PM > >On 26/06/14 12:58, Nelson, Erik - 2 wrote: > > I'd like to record which databases/tables/fields are accessed. Is > > there any not-too-difficult way of doing this? > > The authorizer interface will address your iss

[sqlite] detect database/table/field use

hook might be either in the lookupName() function or the internals of the Parse structure. Anyway suggestions would be appreciated. Erik -- This message, and any attachments, is for the intended recipient(s) only, may

[sqlite] Google Stuff

office). Changing 'https' to 'http' works. I'm not sure if this is new, just the first time I've noticed it. Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information

[sqlite] More context on parse error

I've mentioned before on the list that a bit more context in parse error messages would be helpful in our application. I hacked something quick that seems to work for us, posting it in case anyone else finds it useful or would like to improve on it.

Re: [sqlite] Send Mail from sqlite

d function and call that from a trigger? Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important

Re: [sqlite] locked database?

ng statement! Thanks much. Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditio

[sqlite] locked database?

. Or maybe there's something else it could be? Any suggestions would be welcome. Thanks Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential

[sqlite] getting more context on SQL parse errors

give a better idea of where to look for the SQL error. Thanks Erik -- This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary

  1   2   >