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
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: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 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
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
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
__
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 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
> 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
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
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 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
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
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 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
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
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.
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
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
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
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
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
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
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
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/
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/
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
27 matches
Mail list logo
