On Wed, Feb 12, 2020 at 9:02 PM Eric Grange wrote:
> [...] This is completely safe vs SQL injection, and IME quite efficient. [...]
I disagree that this is efficient enough. I'd much rather have native support in
SQLite for array binding, in the public API, than this. That public
API could wrap
w
Hi Everybody,
I just thought I'd announce this new node library here:
name: sqlite3-cli
description: A shell for executing sqlite queries
https://github.com/pguardiario/sqlite3-cli
Comments / requests are welcome.
- Thanks.
--
Sent from: http://sqlite.1065341.n5.nabble.com/
After sqlite 3.29 -> 3.31 upgrade, we started seeing issues related to
differences in /dev/null in Solaris.
Recently, O_NOFOLLOW was added to several calls into robust_open(). In
that function, if the fd returned by open() is too low (in the stdio
range 0-2), then it closes it, and opens /dev/
Greetings.
I was searching on sqlite.org for [sqlite command line tool .timer explanation]
and found nothing. I also searched on the internet and found an old thread[1]
of when .timer had just two entries:
CPU Time: user 880.710398 sys 353.260288
And, although, there is some good information
On 2/13/20, jakub.ku...@oracle.com wrote:
>
> Recently, O_NOFOLLOW was added to several calls into robust_open(). In
> that function, if the fd returned by open() is too low (in the stdio
> range 0-2), then it closes it, and opens /dev/null to pad out the fd's
> until we reach at least fd#3.
Back
I would create an SQL dump ("sqlite3 file.db .dump") and search therein.
- Original Message -
From: Scott
To: SQLite Mailing List
Sent: Thursday, February 13, 2020, 15:01:06
Subject: [sqlite] Can I search all tables and columns of SQLite database for a
specific text string?
Can I sea
Can I search all tables and columns of SQLite database for a specific text
string? I'm sure this question has been asked many times, but I'm having
trouble finding a solid answer.
My problem: My clients SQLite database has 11 tables and multiple columns (some
designated and others not) and they
On 13 Feb 2020, at 2:01pm, Scott wrote:
> Can I search all tables and columns of SQLite database for a specific text
> string?
No. There's no way to do this, and there's no way to say "all tables" in SQL.
In other words it's not easy to write such a thing.
I like Thomas Kurz's solution, to
Scott, on Thursday, February 13, 2020 09:01 AM, wrote...
>
> Can I search all tables and columns of SQLite database for a specific
> text string? I'm sure this question has been asked many times, but I'm
> having trouble finding a solid answer.
> My problem: My clients SQLite database has 11 table
Tom and Slavin:
The dump of information sounds like a good idea. To Slavin's question, the user
need to be able to repeated search, but as a developer, I would want and idea I
can eventually implement repeatedly. I've done this successfully in the past,
but it required 4-5 methods handling a com
Hi,
How can I prevent receiving the "ok" added here:
https://www.sqlite.org/src/info/b3692c406f7ba625
when I'm using `sqlite -cmd "PRAGMA key " database.sqlite .output`?
iulianOnofrei
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
According to the code in shell.c the .timer on/off sets a flag that tells
whether you want timer data printed or not, and then for each statement:
if .timer is turned on
save the current wall clock and getrusage times (usr and sys times)
execute the statement.
if .timer is turned on
get the
On Windows the GetProcessTimes Win32 API is used to get the user and kernel
(sys) times for the current process since getrusage only exists on unix-like
platforms. In all cases the precision and accuracy are limited by the
underlying OS timer accuracy.
The vfs call to get the current time i
Team,
I am trying to compile SEE for ARM processor.
I have followed following steps. But was not successful in generating "
*libsqliteX.so*" file which can be used on Android Samsung G7 mobile.
1. Installed GCC compiler from “http://www.mingw.org/” reference at “
https://gcc.gnu.org/”.
2.
On 2/13/20, Subodh Pathak wrote:
>
> I am trying to compile SEE for ARM processor.
There is a website explain how to compile SQLite for Android here:
https://www.sqlite.org/android/doc/trunk/www/index.wiki
Please review the instructions on that website and write again if they
do not work for you
I have an app which is multithreaded. Sometimes during lengty inserts a
different thread (which only reads the database) sees part of the
updated data.
This would be solved by using transactions. However, during the
transaction the "reading" thread gets a 'database table is locked' error.
In
In 3.31.1, this self-contained script, which joins to an unnecessary table
and adds what should be a redundant but harmless WHERE constraint on it:
https://gist.github.com/TallJimbo/d819876a77cfd79312ad48508cfdd8a2
returns incorrect results (which clearly violate the redundant
constraint). Remov
I’ve written a virtual table to view spreadsheet data inside Excel workbook
(.xlsx) files as SQlite tables. I want to implement an SQL function, attr(),
which the virtual table overrides to give access to the raw attributes of the
cell being returned. I’m looking for a robust way to find the act
> On Feb 13, 2020, at 10:51 AM, Subodh Pathak wrote:
>
> I am looking for help to configure machine to compile SEE for ARM. I am
> using Android mobile Samsung G7.
You have to use a cross-compiler, a version of GCC that runs on your platform
but generates ARM-Linux code.
Specifically, to bui
> On Feb 13, 2020, at 12:52 PM, David Jones wrote:
>
> sqlite> select F,G,H,attr(H,3) from summary; # show formula used
> to calculate column H.
Maybe pass the column name as a string, i.e. `attr('H',3)`? It sounds like your
`attr` function needs to know the _identity_ of the col
Jens Alfke asks:
>Maybe pass the column name as a string, i.e. `attr('H',3)`
2 problems with that idea. First, the first argument has to refer to a value in
the virtual table in order to invoke the overridden version (overrides are per
table, so I use the ppArg to bind function invocation to ass
On 2/13/20, Jim Bosch wrote:
> https://gist.github.com/TallJimbo/d819876a77cfd79312ad48508cfdd8a2
Thanks for the very succinct bug report. The problem is now fixed on
trunk. https://www.sqlite.org/src/timeline?c=c9a8defcef35a1fe
--
D. Richard Hipp
d...@sqlite.org
__
Correct. "memory" databases can only be shared between connections in the same
process, and then only by the sharedcache method. In effect, a "memory"
database is nothing more than a cache, and sharing it between connections means
sharing the cache. cache=private uses a separate cache for th
I have placed databases on/in /dev/shm and shared them across both threads
and processes.
Jim "Jed" Dodgen
j...@dodgen.us
On Thu, Feb 13, 2020 at 2:38 PM Keith Medcalf wrote:
>
> Correct. "memory" databases can only be shared between connections in the
> same process, and then only by the sha
On Thursday, 13 February, 2020 17:06, Jim Dodgen wrote:
>I have placed databases on/in /dev/shm and shared them across both
>threads and processes.
Yeah, /dev/shm is a pre-existing tmpfs filesystem, separate from the one
mounted on /tmp. I keep forgetting about that one ...
--
The fact that
I have often wondered what the performance difference is between /dev/shm
and :memory: databases
Jim "Jed" Dodgen
j...@dodgen.us
On Thu, Feb 13, 2020 at 4:48 PM Keith Medcalf wrote:
>
> On Thursday, 13 February, 2020 17:06, Jim Dodgen
> wrote:
>
> >I have placed databases on/in /dev/shm and s
On Thursday, 13 February, 2020 17:58, Jim Dodgen wrote:
>I have often wondered what the performance difference is between /dev/shm
>and :memory: databases
Theoretically a :memory: database is faster than a /dev/shm stored database. A
:memory: database is purely in memory and has no extra conn
27 matches
Mail list logo