Re: [sqlite] New SQLite Forum established - this mailing list is deprecated

Ahthe inevitable becomes reality. I knew when this stuff surfaced a few years back that it was not going to go away, and this outcome was just a matter of time. Not a great a great shock as a life in programming has seen so much change. I don't need to Fossil, because I am one. Also a bit of a

Re: [sqlite] Cascaded delete unexpectedly triggered by upsert

On 8.01.20 01:04, Simon Slavin wrote: > On 8 Jan 2020, at 12:00am, Michael Kappert wrote: > >> REPLACE INTO > > REPLACE INTO is an alias for INSERT OR REPLACE. So you should assume that > the command will do either an INSERT or a REPLACE. > > See the notes about REPLA

[sqlite] Cascaded delete unexpectedly triggered by upsert

------ If I understand correctly, the upsert should behave like UPDATE in the examples above, but it behaves like a DELETE followed by INSERT instead? Best, Michael ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 18 minutes 41 seconds

e the fact that there was, in fact, no year 0. Obviously the character(s) responsible for dates etc were NOT C programmers! On Tue, 31 Dec 2019 at 14:45, Richard Damon wrote: > On 12/30/19 10:10 PM, Pierpaolo Bernardi wrote: > > On Tue, Dec 31, 2019 at 4:07 AM Keith Medcalf > wrote: >

Re: [sqlite] 18 minutes 41 seconds

Great work but pretty much what we have come to expect from DRH and the SQLite team. As we approach the end of yet another year ( and indeed decade ) can I indulge the list in a simple congratulations to all involved and to the outstanding support on offer when a member of this email list. SQLite i

Re: [sqlite] Bug: Table contains two records for the same primary key in .dump output but not in SELECT output

45); > sqlite> SELECT id, typeof(id) FROM test; > id typeof(id) > > 12345 text > 12345 integer > sqlite> SELECT id, typeof(id) FROM test WHERE id = '12345'; > id typeof(id) > > 12345 text > > On Sat, Dec 21, 2019 at 1:26 PM Michael Walker (barrucadu

[sqlite] Bug: Table contains two records for the same primary key in .dump output but not in SELECT output

put being updated, the first copy has the original state. The table has always had a primary key constraint, so I'm not sure how it's ended up in its current state. However, even if there were not a primary key constraint, there do seem to be two very real bugs here: SELECT gives different results to .dump, and .dump is producing output which can't be restored. I'm not sure if you'll be able to make anything of this, as I say I haven't been able to reproduce it from a blank database, but I figure you'll be better at debugging this than me. Thanks -- Michael Walker (http://www.barrucadu.co.uk) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Things you shouldn't assume when you store names

On 11/10/19 1:21 AM, Gary R. Schmidt wrote: So what happens when someone from a family who only uses first- and last-names moves to Kansas? Do they have to make up a middle-name so that he idiots can fill out the forms? I am most definitely not going to take one side or the other. My only

Re: [sqlite] OT!!!!! Understanding the WITH clause

SELECT peace FROM disaster WHERE disaster.cause = 'Windows'; Returns: *nix On Thu, 20 Jun 2019 at 14:26, Sam Carleton wrote: > James, > > That is a really, really interesting quote. it really got me thinking > about peace and the definition of it. It got me thinking so much I wanted > to kno

Re: [sqlite] How many digits do you need ?

Nice one Simon, as a resident Australian (and a lover of levity) I liked your link, which led me on to the data source. I took a pair of those 15 digit coordinates and pumped them into good old Google maps but sadly I was unable to zoom in far enough to see any chlorine atoms. :-(. Shame that. On

Re: [sqlite] GROUP BY and ICU collation

and 'Š' the same is more important than separating them. But when it's just 1 character then they're different. Uh... oh... that might explain things... Then I'll have to re-think things considerably. Thank you all for your input! Michael So 'S' might be befo

Re: [sqlite] GROUP BY and ICU collation

ger1 140 00 r[14]=1 59Integer1 15000 r[15]=1 60Integer1 22000 r[22]=1 61Integer1 23000 r[23]=1 62Goto 0 1 0

Re: [sqlite] Is it possible to concatenate an arbitrary number of columns into one?

As Simon points out there is no SQL solution to your issue. Some sort of external utility processing with things like awk, sed or even cut may assist or for a quick and dirty method you could set the sqlite3 command line utility .separator value to a blank string which may (or may not) provide a te

Re: [sqlite] Regarding CoC

Oh dear, it's all gone...while my devout atheism is generally pleased my somewhat annoying 'free will, free speech ' ethic has rust on it! Richard, it's your joint and it's such a good place, friendly and mostly respectful. My atheism was NOT offended in any way by all that God speak and I do

Re: [sqlite] Regarding CoC

> > I found code of conduct in documentation and I was wondering if it were > true. Checking the version history it appears to have been added on > 2018-02-22. > Sure that publishing date wasn't 2018-04-01? On Wed, 24 Oct 2018 at 08:02, Stefan Evert wrote: > > > On 23 Oct 2018, at 07:04, Paul

Re: [sqlite] Mailing list shutting down...

May I respectfully suggest to everyone that offering solutions, while valuable and helpful, may not be as valuable as the offer of assistance to our listmaster. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqli

Re: [sqlite] Advice for a "how-to" situation.

On 2/15/18 2:55 PM, Simon Slavin wrote: By the way, your use of backticks to identify column names That's a quirk of the "schema" command that I used to export the sample that I'm playing with. However, thanks for the reminder. And thanks to everyone for the advice on how to do this. I'm goi

[sqlite] Advice for a "how-to" situation.

This might be a general RDBMS question but since I'm using sqlite specifically, I hope it passes basic relevancy tests. I have a table defined as: CREATE TABLE "CPUModelDictionary" ( `vendor_id` TEXT, `cpu_family`INTEGER, `cpu_model` INTEGER, `cpuid_l

Re: [sqlite] Minor bug reports during build.

On Fri, Dec 22, 2017 at 10:26 AM, Warren Young wrote: > On Dec 22, 2017, at 7:07 AM, Michael Tiernan > wrote: > > > > "Working as advertised" Okay, that's just funny. That it doesn't build is > > correct? > > It does build. Okay, it does b

Re: [sqlite] Minor bug reports during build.

n MacOSX and doesn't complain about things it can't control. -- << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they please, and men and dogs should relax and get used to the ide

Re: [sqlite] Minor bug reports during build.

I found that if I use "disable-tcl" it builds correctly. (Testing is an issue but that's separate right now. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Minor bug reports during build.

x27;s time! -- << MCT >> Michael C Tiernan.http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they please, and men and dogs should relax and get used to the idea. -Robert A. Heinlein On Dec 21, 2017 2:26 PM, "Warren Young"

Re: [sqlite] Minor bug reports during build.

undefined -o libtclsqlite3.la tclsqlite.lo > \ > libsqlite3.la -L/usr/lib64 -ltclstub8.5 -ldl -lpthread \ > -rpath "/usr/share/tcl8.5/sqlite3" \ > -version-info "8:6:8" \ > -avoid-version > libtool: link: rm -fr .libs/libtclsqlite3.a .libs/

Re: [sqlite] Minor bug reports during build.

Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Minor bug reports during build.

Is there a route for reporting an error for an average user without creating an account and all the overhead of the ticket system? ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/s

Re: [sqlite] Proof that a line has been modified

In the past, I've used the pager to secure data. This involved encrypting the data before writing the data to disk and decrypting when loading from disk but also optionally hashing the page and storing the hash in extra data reserved for each page. If anyone tampered with the data, the hash wo

Re: [sqlite] SPAM-LOW: sqlite-users Digest, Vol 114, Issue 3

I'll take a look. Thanks - Michael Condon Mission Critical Solutions (503)726-4685 Original Message > From: sqlite-users-requ...@mailinglists.sqlite.org > Sent: Saturday, June 03, 2017 5:00 AM > To: sqlite-users@mailinglists.sqlite.org > Subject:

Re: [sqlite] SQLite CVE-2015-6607 (Escalation of privilege issue )

Just amusing, and found while looking for above. Researchers have disclosed a vulnerability in *Android's* SQLite that can > leak sensitive information without an application having adequate > privileges. > ​So when did DRH sell out to Android? :-) From an old (2012) blog report ​HERE

Re: [sqlite] SQLite CVE-2015-6607 (Escalation of privilege issue )

These may enlighten a little..at least it appears to be related? http://www.cvedetails.com/cve/CVE-2015-6607/ IBM report On 17 April 2017 at 22:09, Simon Slavin wrote: > > On 17 Apr 2017, at 10:35am, Saurav Sarkar > wrote

Re: [sqlite] Why isn't my time formatting working?

UmI'm one of those sad old hacks who doesn't store dates at all. Just Years, Months, and Days. You can do just about anything with them stored that way, and in sqlite it seems to matter little whether they are string or numeric columns. Dates are a rubbery concept not well suited to db storage

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

On Mar 7, 2017 6:56 AM, "Brian Curley" wrote: > I have successfully coupled shell scripts and the CLI I'd love to see examples of this sort of use case and I suspect that there's others who would benefit from seeing how others approach solving some of the common problems. Does anyone know where

Re: [sqlite] thousand separator for printing large numbers

Congrats to all contributors to this thread. Robust discussions like this make this my absolute favourite list. For the record I like the OP's suggestion which was more about the features of the printf() function than anything else. Everybody wins though, because of the great discussion and the dif

Re: [sqlite] Simple web query tool

> > Running the sqlite3 command-line shell via cgi works way better than you > may expect. > ​Yay verily, and that is really not doing a great tool justice. I've done a lot of similar things to what Lindsay outlines above both with web and application targets, Often these procedures are set up as

[sqlite] Replicate SQLite and keep sync (every half hour) from PostgreSQL table

I'm able to access a remote PostgreSQL table from my server. However, the PostgreSQL table contains around 50 mio. records, and I have a certain column ID which I only need. I would like to replicate the PostgreSQL table (including a WHERE clause) to a in-memory SQLite database, which will sync/up

[sqlite] Documentation clarification request... (re: Triggers)

but I really don't have the bandwidth to go and clean up the mess I might make if I'm wrong. Thanks for everyone's time! -- << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they plea

Re: [sqlite] SQLite output mode

Just from some quick command line tool playing around, a dirt quick fix presented itself. .mode csv followed by .mode column (following the .mode ascii operation) seems to return the .column mode to normal. This on SQLite 3.16.2 on Linux command line. I'm not suggesting this as a fix as Dr Hipp has

Re: [sqlite] Possible bug when creating a calculated index

Thank you Simon, I do see the inconsistency and thanks for those examples. I had answered previously before I saw your explanation and I now see why there is concern. It certainly appears to be inconsistent given such use cases. On 27 January 2017 at 10:26, Michael Falconer wrote: > Er

Re: [sqlite] Possible bug when creating a calculated index

expecting one. On the other hand if I choose double quotes I'm probably doing something different. Maybe someone else should weigh in and the penny will finally drop if I am missing the point, but I'm still not seeing crawly things. :-) On 27 January 2017 at 10:01, Ersin Akinci wrote:

Re: [sqlite] Possible bug when creating a calculated index

Simon, as I see it there is no problem here. Explicit quoting regardless, the column does not exist and an error is returned, isn't this the expected outcome? In the DRH quoted section a reason is presented as to why no error is returned due to a built in default action. This may or may not be a p

[sqlite] Foreign key integrity checking.

I'm going to assume this has come up before so instead of asking for help, I'll simply ask for pointers to FAQs about some of the more mundane things such as ensuring foreign key integrity and checking for it. Thanks for everyone's time. -- << MCT >&

Re: [sqlite] SQLite3 Tutorial error

UmSnobol? Nope absolutely deny all knowledge. Well.actually, didn't cut any code in it but did hear about Spitbol. No I kid you not, sort of a super Snobol I was led to believe. I was cutting Cobol at the time, eons ago. :-) A colleague told me about it and I took a look but not a close on

Re: [sqlite] Inspect WAL file?

https://www.sqlite.org/src/artifact/ec79959834f7b21f It allows you to look at the WAL.., but not sure if it fits your problem. Michael -- Michael Schlenker Senior Software Engineer CONTACT Software GmbH Tel.: +49 (421) 20153-80 Wiener Straße 1-3 Fax:+49 (421) 20153-41

Re: [sqlite] importing csv

Alan, if you are new to sqlite3 then let me give you a little heads up on something that tripped me up a couple of times in early days. I am assuming you are the command line sqlite3 interface which will require you to set the separator for data imports. .separator , ...is likely what you want i

Re: [sqlite] 64-bit SQLite3.exe

com> wrote: > Yes, it is much faster. The process was done in Excel/Access before and > took ages. I have had processes go from 8 hours before to 30 min now using > SQLite. > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org

Re: [sqlite] SpeedTest1 Comparison of 32 vs 64 bit on Windows 10 13483.15

Nice Keith, and very topical as well as being informative. Note a couple of things that got my curiosity chip activating: *subquery in result set* test produces interesting outcome with the 64 bit version bucking the trend. Any ideas there? Also it would appear *select* clauses demonstrate an abo

Re: [sqlite] 64-bit SQLite3.exe

you using these in an end-user application, i.e. as an interactive response to user actions? I would be curious to know if building intermediate temporary tables is fast enough for returning results for such uses. Thanks, //Mike -- ⊨ Michael Gratton, Percept Wrangler. ⚙ <http://mjog.vee.

Re: [sqlite] Exec vs Prepare, step, finalize.

...as for Stephen, Mr Beal you need to get out more LOL! Little Johnny Tables indeed. Rub it in, why not? LOL On 12 August 2016 at 09:38, Michael Falconer wrote: > Thanks all, > > must admit to being around db's for years but I never did get my head > around the whole injecti

Re: [sqlite] Exec vs Prepare, step, finalize.

Thanks all, must admit to being around db's for years but I never did get my head around the whole injection thing, sad but true. Keith summed it up in usual succinct fashion which when read by one old hack cause much reddening of the facial features. Bugger, says I, that speaks my language and it

Re: [sqlite] Exec vs Prepare, step, finalize.

> > On Aug 10, 2016, at 9:21 PM, Michael Falconer < > michael.j.falco...@gmail.com> wrote: > > > Hi all, > > > > just seeking some opinions, and perhaps some dev indications about > > deprecation, in relation to the sqlite3_exec facility. I kind of like the

[sqlite] Exec vs Prepare, step, finalize.

Hi all, just seeking some opinions, and perhaps some dev indications about deprecation, in relation to the sqlite3_exec facility. I kind of like the callback functionality in certain cases as it is convenient in some circumstances where the sql injection problem is not an issue. Ok I say it is no

Re: [sqlite] 64-bit SQLite3.exe

016 at 10:58, R Smith wrote: > > On 2016/08/10 11:35 PM, Michael Falconer wrote: > >> ...// Ryan is very >> right about the relative ease of such exercises but IMHO wrong that it >> suits all, or even most cases. >> > > Just to be clear - if my post wasn't

Re: [sqlite] 64-bit SQLite3.exe

Great discussion, if somewhat amusing (with a hint of deja vu) for an old hack like myself. I remember discussions like this back in CP/M days when it was a move rom 8 to 16bit. Oh, and it all happened again when 32bit came along and yes now we are into 64bit and it carries on. Simple really, the

Re: [sqlite] DB Partitioning and Performance

the suggestion from R Smith that I filter those sub-selects. Hopefully it works. Thanks Simon and R Smith! On 5/27/16, 5:29 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Simon Slavin" wrote: > >On 27 May 2016, at 3:17am, Michael Hari wrote: > >&g

[sqlite] DB Partitioning and Performance

UNION ALL SELECT * FROM 2015.datatable) You can assume the separate databases have the same indexing as the single db, where it’s indexed by year and quarter. Thanks, Michael ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Attach Database and Database pooling

Never mind, there was an error in my code. On 5/26/16, 11:52 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Michael Hari" wrote: >Hi All, > > > >I’m trying to preallocate about 20 sqlite connections each with the same >“ATTACH DB” command. I’m ge

[sqlite] Attach Database and Database pooling

? Thanks, Michael ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

What about if we shard the tables in the database across multiple databases? Is that possible to do? Does SQLite support the concept of sharding? Thanks, Michael On 5/24/16, 10:20 AM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Simon Slavin" wrote: > >On 2

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

through SQL or scripting? Thanks, Michael On 5/23/16, 1:46 PM, "sqlite-users-boun...@mailinglists.sqlite.org on behalf of Simon Slavin" wrote: > >On 23 May 2016, at 9:08pm, Piyush Shah wrote: > >> We know about sqldiff >> https://urldefens

[sqlite] FTS offsets() reporting SQLITE_CORRUPT with empty string, redux

om here: <https://git.gnome.org/browse/geary/tree/src/sqlite3-unicodesn> For context, the application's bug report is here: <https://bugzilla.gnome.org/show_bug.cgi?id=765515> What can I do to help resolve this bug? //Mike -- ? Michael Gratton, Percept Wrangler. ? <http://mjog.vee.net/>

[sqlite] regression in 3.12.0 vs. 3.11.0, column type information in PRAGMA missing

esult 99% of the time (for our schema). Now we either have to add additional configuration just for SQLite (because similar code works fine for Oracle and MS SQL Server), or hope that case 3 works. btw. would be nice to have an INFORMATION SCHEMA style view for this info instead of a pragma. Michael

[sqlite] Get count of unique values?

Both Igor's and Simon's solutions work on my test system. The only additional comment is that Simon's works in Sqlite as expected. However running the same on PostgreSQL bombs with an error complaining about an sub-query with no name! Interesting? Perhaps watch out for portability with that one. I

[sqlite] Performance comparison between SQLite and SQL Server?

Good thread, which absolutely nails the point 'dev decisions for app cases' make a developers world go round. I personally couldn't think of a greater waste of time than a benchmark comparison between client server rdbms's and sqlite. Do what benefits your case most. The above from Jim pretty much

[sqlite] json_group_array

I just love this list and the contained discussions. Doffing my cap to Keith and his succinct and very useful summary of the subtle differences regarding aggregate type functions. Especially like the nested stuff, which I must admit had not really occurred to me. Nice stuff Keith and thanks for sha

[sqlite] In the case of ZIPVFS

Having just glanced at the documentation for ZIPVFS (didn't even know it existed)... 1) Perhaps using a real-time compression algorithm, something like lz4. It's not clear to me which algorithm ZIPVFS uses by default. 2) Perhaps increasing the cache settings to cache more pages in memory. 3) Per

[sqlite] maybe bug in regexp and replace with newlines?

>/> The statement: />/> select distinct text from v_term_item where replace(lower(text),0x0A,'') REGEXP('.*/some_text/.*'); />/> doesn't work like that: / > Try x'0A' instead (that's a BLOB literal, and should be converted to a > string). 0x0A is an integer, I suspect it gets converted to the str

[sqlite] Missing documentation about BLOB encoding conversions

ed.) Thank you! That's the information that I was looking for. Regards, Michael

[sqlite] Missing documentation about BLOB encoding conversions

The sequence of calls is: 1. sqlite3_step() 2. sqlite3_column_text16() 3. sqlite3_column_bytes() Please see the attached example program. Regards, Michael > What is the exact sequence of calls? > > If you call sqlite3_column_text() on a blob value, the new type will > b

[sqlite] Missing documentation about BLOB encoding conversions

-16 when sqlite3_column_text16() is called. This is quite unexpected, and it would be nice if the rules for BLOB encodings and BLOB encoding conversions were pointed out in the documentation. Regards, Michael

[sqlite] maybe bug in regexp and replace with newlines?

On 12/2/2015 7:54 AM, michael wrote: >>/sqlite3 -header flexsql.db "select distinct replace(lower(text),0x0A,'') >>/>>/from v_term_item where lower(text) REGEXP('.*some_text.*') limit 1;" / >You are removing newlines in the wrong spot. Do it on t

[sqlite] maybe bug in regexp and replace with newlines?

>> sqlite3 -header flexsql.db "select distinct text from v_term_item where >> name='text' and lower(text) REGEXP('.*some_text.*');" >> which doesn't works >REGEXP is not compiled into SQLite by default. >Simon. Yes but in gentoo it is compiled. Only a problem with new lines

[sqlite] maybe bug in regexp and replace with newlines?

I tried sqlite3 -header flexsql.db "select distinct text from v_term_item where name='text' and lower(text) REGEXP('.*some_text.*');" which doesn't works sqlite3 -header flexsql.db "select distinct text from v_term_item where name='text' and lower(text) like '%some_text%';" works so I tried a wo

[sqlite] Casting ctype functions' arguments

Richard Hipp wrote: > On 11/13/15, Michael McConville wrote: > > Hi, everyone. > > > > I've been auditing the OpenBSD codebase for calls to ctype functions > > with potentially signed chars. This is undefined on some platforms. > > I found a number of insta

[sqlite] Casting ctype functions' arguments

g may be changed and mistakes are possible (though unlikely). Here's the relevant CERT entry: https://www.securecoding.cert.org/confluence/display/c/STR37-C.+Arguments+to+character-handling+functions+must+be+representable+as+an+unsigned+char Let me know what you think. Thank

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

Outstanding! it is kudos which is so richly deserved, and IMHO, an example of REAL integrity earned. Over the years I have watched as SQLite developed, learned much from this list, and was impressed by Dr Hipps hands-on leadership in directing development in what he and the team deemed an appropri

[sqlite] factbook.sql World Factbook Country Profiles in SQL (Incl. factbook.db - Single-File SQLite Distro)

Gerald, thanks for this, it looks most interesting on both levels. i.e. The data release and your project work. Thank you for the information and your project. On 2 November 2015 at 01:49, Gerald Bauer wrote: > Hello, > > I've started a new project, that is, /factbook.sql [1] that offers > an

[sqlite] Encrypted or Corrupt File

I am new to this and an amateur to say the least. I'm trying to recover online some chat files. I'm using SQLite manager to read files and the files I was just using yesterday are not opening. file error: either the file is encrypted or corrupt component returned failure code 0x8052000b. Can anyone

[sqlite] Detect if db is already opened by another process?

Am 23.09.2015 um 18:09 schrieb Richard Hipp: > On 9/23/15, Michael Schlenker wrote: >> Hi, >> >> i just wondered if there is an API to detect if a sqlite database file >> is already opened by another process. > > Maybe try to change in or out of WAL mode?

[sqlite] Detect if db is already opened by another process?

. The maintenance tool should not change the DB if the server is running. I could of course do explicit locking via other means to mediate access (actually i do that now, but it is not really elegant), but if there is an SQLite API way to do it, it would be nicer. Any good hints? Michael -- Mi

[sqlite] pragma temp_store = 2 ignored in WinRT App

sed SQLite version: sqlite-winrt81-3081002.vsix Thanks, Michael Geier Graz, Austria

[sqlite] pragma temp_store_directory problem with UTF-8 characters

Vfs, zName, flags, &ret);) maps to winAccess on Windows which checks the file attributes for the readonly flag. * winAccess() calls winConvertFromUtf8Filename(), which seems to have an issue with UTF-8 characters in paths. Used SQLite version: sqlite-winrt81-3081002.vsix Applies to both WinRT (Windows 8.1 App) and .NET 4.5 Thanks, Michael Geier Graz, Austria

[sqlite] Destroy all evidence of a database

Simon, if the data in the database is sensitive, could you encrypt the database (ala something like https://www.zetetic.net/sqlcipher/)? That way if the file is left around for some reason, it's much less of a concern. Your app could generate a new (random) key each time it creates a new dat

[sqlite] Did A Recent Windows & Update Affect SQLite???

Some suggestions: 1) Check your temp folder and remove chaff. 2) Download CCleaner and check your registry integrity. 3) Review updates that have been applied and try removing them one at a time or in a targeted fashion. You should be able to see what updates were applied around the time you th

[sqlite] System.Data.SQLite NuGet

The current NuGet package seems to include SQLite version 3.8.6. Are there plans to update to version 3.8.7? -- Michael Quinlan mquin...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

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

Many of the answers I came across online implied that it wouldn't be as straightforward as serializing ints and strings. On Fri, Nov 21, 2014 at 1:04 AM, Igor Tandetnik wrote: > On 11/21/2014 12:52 AM, Thane Michael wrote: > >> I've been searching for a way to serialize an

[sqlite] Serializiing an object's vector or array in c++ using sqlite3

Hi, I previously sent out out an email that was not clear, this email is meant to fix that. ---previous message I've been searching for a way to serialize an object's vector using sqlite3 but are yet find a working solution. How do I go about making it happen, an example would be of great help. A

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

Hi, I've been searching for a way to serialize an object's vector using sqlite3 but are yet find a working solution. How do I go about making it happen, an example would be of great help. A second question I have is whether it is possible to serialize an object which doesn't have attributes. An an

[sqlite] Does using e.g. LTRIM function remove collation?

Hi, I'm a bit disoriented by the following result - here using SQLite command shell: sqlite> .version SQLite 3.8.6 2014-08-15 11:46:33 9491ba7d738528f168657adb43a198238abde19e sqlite> CREATE TABLE test( col TEXT COLLATE NOCASE ); sqlite> INSERT INTO test VALUES ('b'), ('A'), ('B'), ('a'); sqlite>

Re: [sqlite] Search query alternatives.

hared hosts, even free hosting services. So this limits us somewhat to what is commonly allowed on such platforms. Things like Stored Procedures are unfortunately outside our scope when it come to design considerations. Thanks all. On 18 October 2014 02:24, James K. Lowden wrote: > On

Re: [sqlite] Search query alternatives.

Thanks Eduardo, a most interesting link. On 17 October 2014 05:41, Eduardo Morras wrote: > On Thu, 16 Oct 2014 09:05:51 +1100 > Michael Falconer wrote: > > > Hi all, > > > > first off I must start with an apology. I know I'm sort of doing the > > wr

Re: [sqlite] Search query alternatives.

al times, ditch the longest and shortest times, then take > the mean or average times and do the comparison that way. > > On Wed, Oct 15, 2014 at 7:54 PM, Michael Falconer < > michael.j.falco...@gmail.com> wrote: > > > Igor, > > > > Nice one. A quick

Re: [sqlite] Search query alternatives.

tober 2014 10:30, Michael Falconer wrote: > Yes, I agree with the general sentiment. It is not exactly the design I > would have chosen either, but it is what exists. Design change is occurring > but for the moment we are stuck with the current schema. > > If you cannot change the

Re: [sqlite] Search query alternatives.

t drops the operation to remove the duplicate records from the result set? I'm assuming. I'll give that a try. On 16 October 2014 10:05, RSmith wrote: > > On 2014/10/16 00:05, Michael Falconer wrote: > >> Hi all, >> >> first off I must start with an a

[sqlite] Search query alternatives.

Hi all, first off I must start with an apology. I know I'm sort of doing the wrong thing here as this question is NOT related to sqlite. It is a general SQL question but I ask it here because I have great respect for the answers and discussions I have seen on this forum over many years. I rarely p

[sqlite] Deleting columns in SQLite

TABLE - Sta... I am trying to find the best way to delete a column in SQLite. Here are the two ways I found: From the official website http://www.sqlite.org/faq.html#q11: BEGIN TRANSACTION; View on stackoverflow.com Preview by Yahoo Thanks, Michael

Re: [sqlite] New wrapper library: QUINCE

Log in to what? How do I register? Or do I need to ask an authorized person to do it? Thanks, --- Michael On 19/08/2014 8:18 AM, Michael Shepanski wrote: Hi Sqliters, I've released an open-source library called quince (QUeries In C++ Expressions) that lets you access sqlite3 easily from C

[sqlite] New wrapper library: QUINCE

it works with PostgreSQL too (and maybe other DBMSes in the future -- it's a matter of adding backend libraries). It's all explained at http://quince-lib.com . Cheers, --- Michael Shepanski ___ sqlite-users mailing list sqlite-users@sqlite

Re: [sqlite] parser stack overflow in view

Finally it works and fast again :-) It was possible to execute some parts before. Thanks to all helpers > Gesendet: Montag, 04. August 2014 um 14:26 Uhr > Von: "Clemens Ladisch" > An: sqlite-users@sqlite.org > Betreff: Re: [sqlite] parser stack overflow in view >

Re: [sqlite] parser stack overflow in view

"Richard Hipp" > An: "General Discussion of SQLite Database" > Betreff: Re: [sqlite] parser stack overflow in view > > On Tue, Jul 29, 2014 at 5:00 AM, Michael wrote: > > > I have a view with about 6 Unions and a depth of about 6 subselects in > >

Re: [sqlite] Long execution time since sqlite 3.8

I also tried to remove the views of some queries and create index. But nothing worked so far. Anyway it couldn't be the reason for the "parser stack overflow" of my other question. Is the information I sent sufficient? *Gesendet:* Dienstag, 29. Juli 2014 um 15:17 Uhr *Von:* Michae

Re: [sqlite] Long execution time since sqlite 3.8

t as votes from tbl_flex_content2,tbl_library_item,tbl_flex_template where ownerUUID=tbl_library_item.UUID and tbl_flex_template.UUID=templateUUID and title='votes'; CREATE VIEW mv_rating AS select FTS3_ID,intContent as rating from tbl_flex_content2,tbl_library_item,tbl_flex_template whe

  1   2   3   4   5   6   7   8   9   10   >