> Hello my friends, i need your help, i have problems with the use special
> character for example "?" , work with vb net. The problem consist when save
> this character in the data base sqlite, this chance in another character. I
> hope your help. Thank you.
Bach. Jonathan Mej?a Acosta
On Tue, Oct 6, 2015 at 8:36 PM, Simon Slavin wrote:
> Or copy an existing /open/ database file to the new server using the
> SQLite Backup API, [requires other connections to stop modifying the
> database for long enough for the copy to be made]
>
Well the backup API works with WAL mode [1] so i
On Tue, 6 Oct 2015 17:39:20 +
Hick Gunter wrote:
> AFAICT the FROM clause is superflous, as the function has no
> (supported) way of detecting which table(s) the FROM clause contains.
> What is your "reindex_virtual_table()" function (I assume it is a
> user implemented function) supposed to
On Tue, Oct 6, 2015 at 2:57 PM, Clemens Ladisch wrote:
> It backs up to any disk that you can access.
> Do you have a network file system?
>
Well yes, but I'd like to handle it at the application layer. Basically,
we operate a custom replication layer atop sqlite. It replicates
individual tran
On Tue, 6 Oct 2015 15:39:08 +0100
Simon Slavin wrote:
> There are also things Virtual Tables can't do. For instance you
> cannot index a Virtual Table using SQL commands.
Does "SELECT reindex_virtual_table() FROM virtual_table" count as SQL command
only?
--- ---
Eduardo Morras
On 2015-10-06 04:52 PM, H?ctor Fiandor wrote:
> Dear fellows:
>
>
>
> I handle my applictions with Lazarus and use BD as sqlite. Sometimes I have
> to obtain a copy of an sqlite table and now I use the method of read and
> write, but I want to know if exists and SQL command that do the same wi
AFAICT the FROM clause is superflous, as the function has no (supported) way of
detecting which table(s) the FROM clause contains. What is your
"reindex_virtual_table()" function (I assume it is a user implemented function)
supposed to do?
-Urspr?ngliche Nachricht-
Von: Eduardo Morras [
On 10/06/2015 02:45 AM, Andrew Cunningham wrote:
>> Ok. My first guess is that you are missing the "suggested index" on the
>> child table. Without this, if there is a foreign key violation in the
>> db, each insert on the parent table will cause a linear scan of the
>> entire child table. With the
On Tue, Oct 6, 2015 at 4:39 PM, Simon Slavin wrote:
> On 6 Oct 2015, at 2:51pm, Dominique Devienne wrote:
> > Is this use case supported by SQLite?
>
> Whether this works correctly depends on how your Virtual Module is
> written. It should be possible to implement this correctly, but I can
> im
Well, there's the obvious Elephant in the room - SQL. You could just
reduce any DB to SQL statements and pass those along at whichever
pace/destination/byte-mode you fancy. The target system will have zero
trouble turning it into a DB, thanks to the SQLite engine already able
to parse SQL.
Thi
We use (for years now) an in-memory DB with both tables and virtual tables
in our app.
We recently started experimenting with multiple connections to the same
in-memory DB, thanks to URI filenames and shared cache, to perform queries
in parallel. This seems to work well with regular tables, and we
On 6 Oct 2015, at 2:51pm, Dominique Devienne wrote:
> On the first connection, we declare the virtual module and its virtual
> tables. This also adds the vtables to sqlite_master. But then on additional
> connections to that same in-memory DB, we also need to declare a vmodule
> and vtables, rig
On 6 Oct 2015, at 2:44pm, David Barrett wrote:
> Regardless, all those solutions require me to wait for the entire backup to
> complete before sending the file to the remote host -- my goal is to send
> it one page at a time (eg, send the pages as the backup API processes them)
> so as to avoid
1) Each connection needs to load the image(s) that contain(s) the virtual
module code (unless you have already linked it into a single image).
2) Each connection needs to declare the virtual module(s) by calling
sqlite3_create_module(_v2).
3) Each connection needs to declare the tables using "CRE
I suspect you are having a chracter encoding problem. SQLite supports UTF
encoding.
-Urspr?ngliche Nachricht-
Von: Jonathan [mailto:jonathanmejiaa at hotmail.com]
Gesendet: Dienstag, 06. Oktober 2015 15:27
An: sqlite-users at mailinglists.sqlite.org
Betreff: [sqlite] Problem sqlite
> Hel
On 6 Oct 2015, at 1:52pm, David Barrett wrote:
> Well yes, but I'd like to handle it at the application layer. Basically,
> we operate a custom replication layer atop sqlite. It replicates
> individual transactions great with 2-phase commit, but right now you need
> to manually "bootstrap" a n
We are using multiple processes accessing the same on-disk db with almost
exclusively virtual tables.
Once the tables have been declared (CREATE VIRTUAL TABLE...), all other
connections need only to load the modules. The xConnect method gets called on
first access.
-Urspr?ngliche Nachricht
@Scott Robison
+1 mate; I thought the same thing as I was reading this. Maybe a
different concept, something like SQLiteNG (SQLite Next Generation)?
It's just a thought, that's all.
Cheers.
On 10/05/2015 05:47 PM, Scott Robison wrote:
> It seems to me the reason these questions keep coming up b
Your thread made me ponder what might be up, so I wrote a test using fts3:
http://pastebin.com/AKP2yHuM
and AFAICT, it works alright. I haven't specifically verified each of the
flags to sqlite3_open_v2(), I just spammed what looked relevant in there.
Hmm, should have commented the #if's befor
On 10/6/15, David Barrett wrote:
> sqlite has a cool "online backup" API: https://www.sqlite.org/backup.html
> However, it only backs up to a local disk. I'm wondering if anybody can
> think on how to use this API to do an incremental backup over a network
> connection to a remote host? The net
Dear fellows:
I handle my applictions with Lazarus and use BD as sqlite. Sometimes I have
to obtain a copy of an sqlite table and now I use the method of read and
write, but I want to know if exists and SQL command that do the same with
less efforts.
Thanks for your suggestions
Ing. H?ctor
David Barrett wrote:
> sqlite has a cool "online backup" API: https://www.sqlite.org/backup.html
> However, it only backs up to a local disk.
It backs up to any disk that you can access.
Do you have a network file system?
> how to use this API to do an incremental backup
This API is not increme
On 10/5/15, Matt DeLand wrote:
> The following SQL outputs more rows than expected. The behavior seems to
> require the use of UNION ALL, ORDER BY (in the column being selected), and
> an OFFSET.
Thanks for providing a test case. See
https://www.sqlite.org/src/info/b65cb2c8d91f6685 for the tick
You could mount a directory as a ramdisk.
On Tue, Oct 6, 2015 at 7:52 AM, David Barrett
wrote:
> On Tue, Oct 6, 2015 at 2:57 PM, Clemens Ladisch
> wrote:
>
> > It backs up to any disk that you can access.
> > Do you have a network file system?
> >
>
> Well yes, but I'd like to handle it at the
> Hello, i need your help, i have problems with the use special
> character for example "?" , work with vb net. The problem consist when save
> this character in the data base sqlite, this chance in another character. I
> hope your help. Thank you.
Bach. Jonathan Mej?a Acosta
Tel. 7104-0440
Cost
Hi every one,
I'm a beginner with sqlite and I'm a C# programmer.
Ive seen the documentation on the c/c++ API but i've no Idea of how to
implement that. I've downloaded the system.data.sqlite dlls which is
working: I can open a connection, list the tables in an sql3 db... But
as I tried more comp
sqlite has a cool "online backup" API: https://www.sqlite.org/backup.html
However, it only backs up to a local disk. I'm wondering if anybody can
think on how to use this API to do an incremental backup over a network
connection to a remote host? The networking part is easy. But I can't
figure
27 matches
Mail list logo
