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

"Serverless" has worked flawlessly since inception. Why change now...? The marketing buzzword usage will disappear...long before Dr Hipp convinces the list that email is dead even. 😏 Regards. Brian P Curley On Wed, Jan 29, 2020, 5:39 PM Jim Dodgen wrote: > I vote for

Re: [sqlite] importing data to a table that has generated-columns

s it's expected the input file to be CSV compliant. Regards. Brian P Curley On Sun, Jan 26, 2020, 1:37 PM Scott Robison wrote: > On Sun, Jan 26, 2020 at 11:01 AM chiahui chen > wrote: > > > Hi, > > > > After creating a table (total 8 columns including 1 genera

Re: [sqlite] List of innocuous functions?

_info, pragma_index_info, and the aforementioned pragma_function_list, at least that I recall. Any sort of listing of what's available like these? I'd think that it would be helpful in the peanut gallery. Thanks! Regards. Brian P Curley On Fri, Jan 24, 2020 at 4:12 PM Richard Hipp wrote: &g

[sqlite] Shell usage/help text inconsistencies

he option definition refers to SIZE and the explanatory text refers to SZ. Best regards, Brian Nixon ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WAL mode for in-memory databases?

I’m very interested in the answer to this as I was planning on do the exact same thing.  Not sure my app would even be able to function without WAL mode. Brian Macy On Jan 14, 2019, 8:28 AM -0500, Dominique Devienne , wrote: > On Mon, Jan 14, 2019 at 2:23 PM Wout Mertens wrote: > >

Re: [sqlite] Regarding CoC

Probably a virtual machine. On Wed, Oct 24, 2018, 2:27 PM R Smith wrote: > > On 2018/10/24 8:19 PM, Stephen Chrzanowski wrote: > > ..// without users consent. ... unlike... > > > https://www.extremetech.com/wp-content/uploads/2016/08/Windows10-BSOD-640x353.jpg > > How did you take a screenshot w

Re: [sqlite] Question about a query

t it might include. Otherwise, you'd want to leverage your application's handling to emulate the same behavior. Regards. Brian P Curley On Tue, Oct 9, 2018 at 10:04 AM Simon Slavin wrote: > On 9 Oct 2018, at 2:47pm, Leonardo Inácio de Freitas < > oldbrain...@gmail.com> wr

Re: [sqlite] sqlite3_column_* with error handling

On Tue, Sep 4, 2018 at 4:11 PM Keith Medcalf wrote: > > On Tuesday, 4 September, 2018 14:00, Clemens Ladisch > wrote: > > >Keith Medcalf wrote: > >> 6) If the column type is SQLITE_BLOB > >> a) Retrieve the column value pointer using column_blob > >> b) If the returned pointer is NULL

Re: [sqlite] sqlite3_column_* with error handling

On Tue, Sep 4, 2018 at 1:31 PM Keith Medcalf wrote: > > Well, that is not exactly true. If you attempt to retrieve the column > values properly, either no errors can occur or if they do, they are obvious. > > 1) Query the column_type > 2) If the column_type is SQLITE_NULL then return a NULL in

Re: [sqlite] sqlite3_column_* with error handling

On Wed, Sep 5, 2018 at 5:22 AM Richard Hipp wrote: > On 9/4/18, Brian Vincent wrote: > > Hi, I'm currently writing a Go sqlite package, go-sqlite-lite. I think > it > > provides a good "pure" SQLite experience with Go. > > > > If I want to make s

[sqlite] sqlite3_column_* with error handling

ons to fail in this manner? Thanks, Brian Vincent ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Why trigger (UPDATE) does not work?

CLI-based scripts) and a no-nonsense GUI, it also tends to flake out with memory issues on relatively small databases. I also cannot find if it's actively supported; no recent versions or activity on the forum. You might need to crosscheck your results within alternates like SQLiteAdmin or db

Re: [sqlite] After upgrade from sqlite3 3.8.7.4 to anything after 3.14.1, I get "Error: destination database is in use"

Is this question better suited for the development list? No response at all. Thanks, Brian ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] After upgrade from sqlite3 3.8.7.4 to anything after 3.14.1, I get "Error: destination database is in use"

message when .restore is ran. The contents of the script basically boil down this CLI set of commands that illustrate the issue: sqlite3 myTestDb sqlite> CREATE TABLE table1 (myId INTEGER PRIMARY KEY, myName TEXT); sqlite> INSERT INTO table1 (myName) VALUES ('brian'); sqlite>

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

ond the initial attempt. I signed up so long ago that I forget what the process involves. Regards. Brian P Curley On Wed, Jun 13, 2018, 11:46 AM Richard Hipp wrote: > On 6/13/18, Chris Brody wrote: > > On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie > > wrote: > >> [.

[sqlite] Can't clone SQLite repository

Lately it seems that I can't clone the official SQLite repository > > fossil clone https://sqlite.org/src sql.fossil > Round-trips: 2 Artifacts sent: 0 received: 0 > Error: not authorized to clone > Round-trips: 2 Artifacts sent: 0 received: 0 > Clone done, sent: 522 received: 580 ip: 2.0.1

Re: [sqlite] sqlite problem - field names missing in select

now that is awesome... Of course, I first attempted it on SQLiteStudio using its 3.15 version of sqlite. Looks like it missed it by one major release level; documentation says it arrived as of 3.16. I've tried it on my CLI version, which is 3.19+. Good stuff. Thanks, Simon. Regards. Br

Re: [sqlite] sqlite problem - field names missing in select

other hand, if I am missing something in front of my face...I'm sure that someone here will make me aware. Regards. Brian P Curley On Feb 23, 2018 1:06 PM, "R Smith" wrote: > > On 2018/02/23 2:46 PM, M wrote: > >> sqlite has an integral problem, field names ca

Re: [sqlite] Feature request for the Shell Tool: .mode json

7;ll pass them through additional parsing to make them |-delimited. (echo ${my_hdrs}\ && jq -rc ".d.results[] |${to_flds} |@csv " \ $(basename ${my_file} ) 2>&1 ) \ |sed 's/"

Re: [sqlite] Feature request for the Shell Tool: .mode json

you get it working, you can use it seamlessly as a function or an aliased call. Regards. Brian P Curley On Jan 21, 2018 10:15 AM, "Luuk" wrote: On 21-01-18 16:05, Brian Curley wrote: > Is there even a need to embed it into sqlite itself? Since you're on the > shell, and in

Re: [sqlite] Feature request for the Shell Tool: .mode json

Is there even a need to embed it into sqlite itself? Since you're on the shell, and in keeping with the whole 'do one thing well' mandate: pipe it through jq instead. Beautiful creature that jq... Regards. Brian P Curley On Jan 21, 2018 9:54 AM, "J Decker" wrote:

Re: [sqlite] Can an SQL script be built from within sqlite?

I use Termux on Android. Very useful build of sqlite available there. Regards. Brian P Curley On Jan 14, 2018 7:42 PM, "Simon Slavin" wrote: > > > On 15 Jan 2018, at 12:30am, petern wrote: > > > Shane. That's very interesting considering the effort to make

Re: [sqlite] Can an SQL script be built from within sqlite?

option...) You can then adopt forward to others like Python, Node.js, whatever... Regards. Brian P Curley On Jan 13, 2018 4:18 PM, "Shane Dev" wrote: Yes, I want to create a timestamp in the file name. My goal is to test the prototype on at least Windows, Linux, iOS and Android.

[sqlite] Compile fails with '-Wall -Werror'

We recently upgraded sqlite from 3.19.3 to 3.21.0 and now building with '-Wall -Werror' fails (when it previously succeeded): $ gcc -O3 -Wall -Werror -fno-delete-null-pointer-checks -c -o sqlite3.o sqlite3.c sqlite3.c: In function 'exprAnalyze': sqlite3.c:131526:37: error: 'pLeft' may be used un

Re: [sqlite] checking if a table exists

umn headers and sorted by object and field order... printf "%s\n" ${hdr} |awk 'NR != 1 { print };' |sort -t'|' -k1,1 -k2,2n |grep -v "^table_nm" elif [ ! -e ${1} ]; then printf "\nError: %s \n" "No SQLite file found...&quo

Re: [sqlite] 'database disk image is malformed' only on the mac

Fahad, Are you calling sqlite3_wal_checkpoint_v2? Brian Macy On Sep 20, 2017, 1:59 PM -0400, wrote: > > I've run the Thread Sanitizer with my own SQLite-based on macOS, and haven't > seen any warnings in sqlite3.c. So what you got could be

Re: [sqlite] CTE question...

that is perfect. Thanks, Clemens! Regards. Brian P Curley On Sat, Sep 16, 2017 at 5:14 AM, Clemens Ladisch wrote: > Brian Curley wrote: > > WITH cte_name --(my_row, code_key) > > AS ( > >SELECT

[sqlite] CTE question...

MIT are redundant.) ​​ Regards. Brian P Curley ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug: Nested function call to replace() throws parser stack overflow exception

Determinstic from C# (Feature request!?)) Thanks Brian -- <http://www.thinksmartbox.com> www.thinksmartbox.com Facebook <https://www.facebook.com/thinksmartbox> Twitter <https://twitter.com/ThinkSmartbox> LinkedIn <https://www.linkedin.com/company/smartbox-assistive

Re: [sqlite] Bug: Nested function call to replace() throws parser stack overflow exception

x27;),'`',''), '~',''),'|',''),'.',''),'!',''),'?',''),' ','') I get the parser stack overflow exception at the point where I create the index: "CREATE INDEX RecordingsNoPunctuationPart1Idx ON Recordings({0});" Or in FULL: "CREATE INDEX RecordingsNoPunctuationPart1Idx ON Recordings(replace(replace( repl

[sqlite] Bug: Nested function call to replace() throws parser stack overflow exception

27;,''),'%',''),'^',''),'&',''),'*',''),'@',''),'#',''),'”',''),'“',''),' ','')" "CREATE T

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

ite_master, might actually suffice for your need without impairing users who rely on the program in the wild. Regards. Brian P Curley On Wed, Jun 7, 2017 at 12:17 PM, PICCORO McKAY Lenz wrote: > hello brian, what standars? reading deeply the sqlite site i not see the > @issue buton@ >

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

Not exactly. You're free to extend it yourself and submit it for consideration though. I think that you'll just need to adopt the same standards as are in use within the usual enhancements channels. Regards. Brian P Curley On Wed, Jun 7, 2017 at 12:09 PM, PICCORO McKAY Lenz wrot

Re: [sqlite] Filter results based on contents of another single field table

( -- Outer query required to offset quirk that prevented ORDER BY below... SELECT * FROM vw_sub_strings_seek EXCEPT SELECT * FROM vw_sub_strings_skip ) ORDER BY CASE WHEN unicode(lower(column_name)) < 95 THEN unicode(lower(column_name)) + 300 ELSE unicode(lower(column_name)) END

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

at SQLite supports both single line ("-- ..") and multi-line ("/* .. */") forms of comments, so your parsing might need to handle either/both according to your style book. Regards. Brian P Curley On Wed, Mar 15, 2017 at 7:40 AM, Chris Locke wrote: > Just add a 'co

Re: [sqlite] A CTE to count the records (rows) for each table

*) FROM "%w" ',name,name) ELSE printf('SELECT "%w", count(*) FROM "%w" UNION',name,name) END counted FROM sqlite_master WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%' ; Dynamic SQL would be very helpful h

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

ed to output it just to read in as an update. Regards. Brian P Curley On Mar 7, 2017 7:30 AM, "Clemens Ladisch" wrote: > Brian Curley wrote: > > What I wonder though is if CTEs could actually serve as a stand-in for > the > > lack of Dynamic SQL > > Recu

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

think that the CLI is often overlooked. You can use it ad hoc, or in tandem with existing DBs, just like you can stream data to the shell for other commercial products, like sqlplus. There is quite a bit out there. Regards. Brian P Curley On Mar 7, 2017 7:04 AM, "Michael Tiernan" wr

Re: [sqlite] SQLite Recursive Common Table Expression suggestion

triggers can sometimes serve in place of a procedural language. I have successfully coupled shell scripts and the CLI but in cases where one is limited to desktop options, this would really be pretty awesome. Regards. Brian P Curley On Mar 7, 2017 3:46 AM, "Clemens Ladisch" wrote

[sqlite] Inserts silently failing

called with the correct parameters, I logged everything coming back on the error log callback, and I verified that the DB is always in auto commit. What can I do to debug better? Can checkpoint RESTART/TRUNCATE cause data loss? Brian Macy ___ sqlite-users

Re: [sqlite] Simple web query tool

Would the SQLite Manager extension on Firefox suffice? I don't know the scope of your use case, but internal file shares are all that's needed to connect to a distributed file. You can achieve variables through a miscellaneous table and coalesce() as needed. Regards. On Wed, Feb 1, 2017 at 11:10

Re: [sqlite] importing csv

Windows requires that you escape the \ in the path, effectively doubling them up. Regards. Brian P Curley On Aug 24, 2016 8:24 PM, "Simon Slavin" wrote: > I hope someone else can help. > > Does that table already exist in the database file ? > > Is the first line

[sqlite] Will the next release include support for VS 2015 Update 3?

Greetings, I need to work with a project that uses SQLite as an ADO data source. I have visual studio 2015 Update 3. I see the binaries on https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki are for update 2, and they don't work. Looking at the timeline, it appears that suppo

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

I've reproduced the issue using both SERIALIZED and MULTITHREADED modes. The issue here doesn't seem to have anything to do with the threading modes. The issue is related to shared caches, and waiting on a b-tree lock while holding the global SQLITE_MUTEX_STATIC_OPEN lock. - Brian V

Re: [sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

ning for all databases. Please let me know if I'm thinking about this problem clearly, or if you would like me to test some things or write a simple test case. Thanks, Brian Vincent On Sat, Jul 9, 2016 at 5:58 AM Olivier Mascia wrote: > > Le 9 juil. 2016 à 12:33, Simon Slavin

[sqlite] Bug Report: All database opening blocked awaiting wal index rebuild

BtreeOpen () #3 0x7f2b7306bc77 in openDatabase () Thanks, Brian Vincent ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Recursive WITH attempting UPDATE wishing to recalculate SET clause

Folks, One response to my post on Stack Overflow, but no solution, so I'll post it here. (Recurse.sql). Studied documentation without being able to de-optimize SET from single Scalar evaluation. Regards, Brian Burleigh -- next part -- // In which we investigate recu

[sqlite] sqlite3 file as database

Microsoft security best practices is never to name anything .db They recommend obfuscating the function of the file and putting some strange or random (.bob) file extension. This is for when you have an active intrusion, you are not handing them what to take on a silver platter. You could argue

[sqlite] Rare database corruption - does this help?

I assume nothing in the Server logs for security and applications at the corresponding time? -Original Message- The environment is Windows Server 2012 R2, with the database on a local NTFS drive.

[sqlite] Lawyers, encryption, and RC4

"Several operating systems include arc4random, an API originating in OpenBSD providing access to a random number generator originally based on RC4. In OpenBSD 5.5, released in May 2014, arc4random was modified to use ChaCha20.[11][12] As of January 2015, implementation of arc4random in NetBSD[13][1

[sqlite] Lawyers, encryption, and RC4

Have you found yourself in an ITAR mess? https://en.wikipedia.org/wiki/Export_of_cryptography_from_the_United_States The length of the keys is usually the determining factor for EAR. I'm not an expert, but I'm guessing that is why they are concerned. -Original Message- From: sqlite-users

[sqlite] SIGSEGV rolling back in-memory DB‏‎

knowing what's going on than anything else. > Date: Wed, 8 Jul 2015 10:19:17 -0700 > From: rogerb at rogerbinns.com > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] SIGSEGV rolling back in-memory DB?? > > -BEGIN PGP SIGNED MESSAGE- > Hash

[sqlite] SIGSEGV rolling back in-memory DB‏‎

back in-memory DB?? > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/07/2015 02:06 PM, Brian Soby wrote: > > I don't believe it's a python specific issue since the core problem > > occurs in a rollback command internal to SQLlite. > > Unless

[sqlite] SIGSEGV rolling back in-memory DB‏‎

e any output of anything you'd like. > Date: Tue, 7 Jul 2015 12:47:48 -0400 > From: drh at sqlite.org > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] SIGSEGV rolling back in-memory DB?? > > On 7/7/15, Brian Soby wrote: > > Yes, it appears to a

[sqlite] SIGSEGV rolling back in-memory DB‏‎

python-dbg for the debug info. > Date: Tue, 7 Jul 2015 08:19:53 -0400 > From: drh at sqlite.org > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] SIGSEGV rolling back in-memory DB?? > > On 7/6/15, Brian Soby wrote: > > Related to this bug: https://c

[sqlite] SIGSEGV rolling back in-memory DB‏‎

Related to this bug: https://code.djangoproject.com/ticket/24080 I can reliably duplicate on Ubuntu 14.04 (package details at bottom) but I can't seem to create a stripped codebase to repro the issue. GDB stacktrace and package details are below. This only appears to happen for in-memory databases

[sqlite] Force the creation of an automatic covering index?

Is it possible to force the creation of an automatic covering index for a subquery? Like, 'cross join' can force the join order, 'indexed by' can force index use on a table, but it doesn't seem like there's anything to force the creation of an automatic index. The reason that I ask is that one of

[sqlite] Duplicating prepared statements

and duplicating it every time we queue to the background thread, but I'm unclear if the overhead of this is significant enough that we'd be better off making a 'prepared statement pool' instead? Any advice would be appreciated. Thanks, Brian

Re: [sqlite] General R*Tree query

On Wed, Dec 18, 2013 at 1:53 AM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > Perhaps this is a weird way for me to get deeper knowledge of R trees, and > because I vaguely remember that Tyco refers to a specific epoch in which > coordinates are defined, but would it be possible to se

Re: [sqlite] General R*Tree query

On Tue, Dec 17, 2013 at 3:57 PM, Roman Fleysher < roman.fleys...@einstein.yu.edu> wrote: > > Since coordinate system is spherical, how do you tell that RA=23:59 and > RA=00:01 are next to each other using usual comparisons? I don't; usual comparisons won't work so I do two comparisons: I am usu

Re: [sqlite] General R*Tree query

On Tue, Dec 17, 2013 at 3:51 PM, Dan Kennedy wrote: > On 12/18/2013 12:49 AM, Brian T. Carcich wrote: > >> [...] > > Points are fine. [...] > Is it working now? How many more stars do you have data for? Excellent, thanks for the info! I forgot to mention that we do p

[sqlite] General R*Tree query

is that I could include the magnitude in the rtree table. The reason I ask is that rtree table uses min-max pairs, but each star is a point so the min and max are equal for each star. Would that break any implicit R*Tree rules or negate any efficiencies? Thanks, Bri

Re: [sqlite] Bug report: Sqlite seg fault, probably after database gets corrupt

if( d1>=(u32)nKey1 && sqlite3VdbeSerialTypeLen(serial_type1)>0 ) break; The next line will likely segfault if d1>=nKey1, right? What if d1>=nKey1, but it's not true that sqlite3VdbeSerialTypeLen(serial_type1)>0 ? Wouldn't this still cause a segfault?

[sqlite] Bug report: Sqlite seg fault, probably after database gets corrupt

Let me first say that we sometimes see databases that go corrupt. I haven't pinpointed the cause yet, but what I think I can describe, is a possibly way that a corrupt database is causing sqlite to segfault. I use a java wrapper for sqlite. I've seen this exact segfault happen on an older wrappe

Re: [sqlite] SQLite for WinCE

a "System.Transactions" reference in the System.Data.SQLite.Compact.2008 project but the project compiles without error. Should I remove the reference? Thanks again, Brian Wheatley ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite for WinCE

m to the appropriate device before compiling? Or just leave it at mixed? Also, there's no Interop file in the Win32 debug folder. When I try to run a PC application using the System.Data.SQLite.dll in the bin\2008\Debug\bin folder it throws an exception that SQLite.Interop.dll could not be

[sqlite] SQLite for WinCE

need to be recompiled? And what about System.Data.SQLite? Thanks in advance, Brian Wheatley ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [Query] Sqlite

qlite > as I am new to this. > > Kindly acquaint me how getting help works with "sqlite-users@sqlite.org". > > -- > Regards, > Raj > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/c

Re: [sqlite] sqlite3 column widths

N PGP SIGNATURE- > > Version: GnuPG v1.4.11 (GNU/Linux) > > > > iEYEARECAAYFAk+XEG0ACgkQmOOfHg372QRCpgCdEVfimkFYA8kx3WQixtfEVEAs > > DpEAoLY1FVYSbQVNZoRM0dTa1fmUbsKj > > =uuvW > > -END PGP SIGNATURE- > > > > > > -- > Pete > Molly's Revenge <http://www.mollysrevenge.c

[sqlite] Not setting FD_CLOEXEC on shm file?

thing to do with the problem I'm having but I was curious if there was a reason why it was excluded from the files that get the FD_CLOEXEC flag set? I'm unable to subscribe to the user mail group at the moment, so a direct reply would be appreciated! - Thanks in advance Brian Sz

Re: [sqlite] Export Blob data from sqlite database to html

> sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > -- Regards. Brian P Curley home: 845 778-5937 cell: 845 548-4377 ___

Re: [sqlite] Using dot commands with the command line binary

Use of a heredoc to simulate a session...or staging it all into a file for use via .read are good too. On Aug 16, 2011 6:55 AM, "Ryan Henrie" wrote: > I finally figured out how to load multiple "dot commands" or settings > from the command line tool. (Some users only have the default binary to > r

Re: [sqlite] Shell doesn't do

@Simon: I'd disagree, unless you mean to make it less specific, since it's really an exercise for the reader to infer mark-up...not just HTML over XHTML. But that's just me... On Aug 10, 2011 1:06 PM, "Simon Slavin" wrote: > > On 10 Aug 2011, at 5:58pm, Kit wro

Re: [sqlite] Shell doesn't do

retrieval logic by piping sqlite output into use. It's much better than some on this forum give it credit. But as mentioned elsewhere: you've got the recompile option too... On Aug 10, 2011 12:58 PM, "Kit" wrote: > 2011/8/10 Brian Curley : >> Depending on your preferr

Re: [sqlite] Shell doesn't do

Depending on your preferred shell...the sqlite CLI is just crazy flexible. Just pipe your output through sed for upper/lower preferences. On Aug 10, 2011 12:18 PM, "Kit" wrote: > 2011/8/10 Simon Slavin : >> I've never tried using this before for some reason but in a recent OS X version of the com

Re: [sqlite] Encoding Question

Christian Schwarz wrote: >This is base64. Christian Many thanks - I've not come across this before, but there's enough in the Wikipedia article to enable me to write a little vb script to convert the base64 to text. Brian -- Brian Pea

[sqlite] Encoding Question

ion encode for the 145 characters in the first? Brian -- Brian Pears (Gateshead) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] OSX Install

Hi Simon, Thanks for the quick reply! Haven't started the PyGTK step as I wanted to get the SQLite working first. Now I know to skip it. Thanks again! Cheers, === Brian On 03/05/2011, at 23:14 PM, Simon Slavin wrote: > >> I'm Brian and very much a r

[sqlite] OSX Install

Hello group, I'm Brian and very much a rookie on this topic. After several hours trying to determine how to install/compile SQLite for OS X, I'm getting no where; SQLite is required for KeepNote (http://rasm.ods.org/keepnote/) app. I've downloaded and unzipped three sets of f

Re: [sqlite] Confitional IF in triggers

On a field by field basis: CASE..WHEN [condition 1]..THEN [result 1]..WHEN [condition n]..THEN [result n]..ELSE..END - Original Message - From: "Russell A" To: Sent: Friday, October 08, 2010 01:24 a Subject: [sqlite] Confitional IF in triggers This may be a really dumb question,

[sqlite] Trigger mask entities...

Looking for some guidance or enlightenment on the available fields within a given trigger. In reading through the code as a non-C kind of guy, it looks like there's an array of columnar values lumped together as old.* and new.* would need them, but nothing that contains the individual field or col

Re: [sqlite] Different temp_store_directory settings okay?

nd application blow away all the temporary data for the first application sitting in /tmp? > > I am experiencing physical DB corruption and am searching > > for possible explanations. > Is the corruption repeatable? What version of SQLite are you running? No, unfortunately. 3.6.14.

[sqlite] Different temp_store_directory settings okay?

physical DB corruption and am searching for possible explanations. Brian Dantes ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Any workarounds/suggestions for dropping a not nullconstraint?

On Feb 3, 2010, at 09:58 , Igor Tandetnik wrote: > Brian Palmer wrote: >> Hey all, we've painted ourselves into a bit of a corner and we're >> trying to find the best way out. Through an oversight during initial >> development, we defined a column as not null in ou

[sqlite] Any workarounds/suggestions for dropping a not null constraint?

ove the not null, which as far as I can tell should work fine, but is a bit scary. Thanks for any advice! -- Brian Palmer ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Strange index creation/insertion performance between Windows and Linux 64-bit

Thanks for the replies. - All insertions are within a transaction - Database was originally created on Linux (with a 1K page size) and copied to Windows - Changing the page size to 4K (and vacuuming) lowered the index creation time on Windows to 50 seconds and on Linux to 5.5 minutes. Howeve

[sqlite] Strange index creation/insertion performance between Windows and Linux 64-bit

plete and the insertion speed seems fairly constant. Can anyone offer any explanations for these huge disparities in sqlite performance on these two platforms? And why Windows does badly on index insertions and well on rebuilding it from scratch, and Linux 64-bit has the exact opposite behavior?

[sqlite] TOCTOU pager bug in 3.6.14.2

See Ticket 3883 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQLite 3.5.9 bug with journals and file locking

If a transaction is opened on a DB for which a journal file exists, and fcntl() returns EACCES or EPERM on the attempt to acquire a write lock on the DB to replay the journal, SQLite 3.5.9 quietly ignores the journal without replaying it and continues on. This is a serious bug. SQLite 3.6.14.2 kee

[sqlite] Alignment bug in SQLIte 3.6.14.2

We've run into an alignment issue in SQLite 3.6.14.2 which only seems to cause a problem under Solaris Sparc in our testing. Failure narrowed down to: src/rowset.c:186 pEntry->v = rowid pEntry is 0xX4 __alignof(*pEntry) is 8 (because of an i64) However sizeof(RowSet) is 28 (and 28%8 = 4), and

[sqlite] Insert into with select not working

Can anyone explain to me why an insert with select statement isn't working? I know in my my example below I just have an extra column which I could have added, but my actual tables are a bit more complex and this below is just to demonstrate the problem. -- Original table CREATE TABLE "subscribers

Re: [sqlite] Bug in "cast" function?

tage to "having the last word." ;-) Thanks, Donald, that's actually a useful suggestion. -- Brian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Bug in "cast" function?

rdcast(word AS INTEGER) > -- - > 0 0 > 0 0 > 1 1 > 10 10 > 100 100 > 11 11 > 12 12 > 0 0 > 0 0 > 0 0 > 0 0 > 0 0 > 0 0 Am I misusing the cast function? Or is this a bug that crept in between 3.4 and 3.6? (I think it worked correctly in 3.5 as well -- I can go back and try, if that helps) Thanks, -- Brian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Journal deletion: no directory fsync?

rolled back and undoing a commit that had already returned. > > There's no danger of corruption here, but doesn't this break > durability? Instead of undoing a commit that has already returned, it will *redo* the commit that has al

Re: [sqlite] SQLite on NFS cache coherency

Brian Smith wrote: > The statement quoted from the SQLite FAQ says that SQLite-NFS > problems are caused by NFS clients that do not implement > locking correctly. While that is definitely true, SQLite is > also to blame, because it uses fnctl locks in a way that is > incomp

Re: [sqlite] How long time to index this table

erating system handle all the disk I/O via swapping. Just make sure that other processes aren't actively using memory. If none that doesn't help, then try decreasing the cache size and increasing your /proc/sys/vm/dirty_ratio and /proc/sys/vm/background_dirty_ratio to 95 each. - Bri

[sqlite] SQLite on NFS cache coherency

ttp://nfs.sourceforge.net/#faq_a8 [6] http://www.apps.ietf.org/rfc/rfc3530.html#sec-9.3.2 [7] http://www.unixcoding.org/NFSCoding#head-a092c1477f04fa51abffc99d62cf649296aa4c4c Cheers, Brian ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Transaction log writing performance

[EMAIL PROTECTED] wrote: > "Brian Smith" <[EMAIL PROTECTED]> wrote: > > When SQLite writes to the log file, it > > > > (1) writes all the data, > > (2) fsyncs, then > > (3) updates the page count in the header, and finally > > (4) fsyn

Re: [sqlite] Unrecognized "Z" UTC time zone signifier

Wilson, Ron P wrote: > Heh. He implemented it with a goto statement! It is also interesting that the vast majority of the Zulu people do not live in the "Zulu timezone." - Brian ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Transaction log writing performance

ites more than one sector per transaction. Thanks, Brian [1] http://tools.ietf.org/html/rfc3385 [2] http://damienkatz.net/2008/02/faster_couchdb.html ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

  1   2   >