s has not been verified. Use at your own risk."
2015-07-24 15:23 GMT+02:00 Jean Chevalier :
> Floor and Ceil can be dynamically loaded. Check last entry here:
> http://www.sqlite.org/contrib
>
>
> Today, Artem Skoretskiy wrote:
> >
> > Hi all,
> &g
ound for floor (only for positive numbers --
floor(N) == round(N - 0.5)) but it is only a workaround.
--
Truly yours,
Artem Skoretskiy
> On 05/19/2015 03:35 PM, Artem wrote:
>> Hi!
>>
>> And what about result of our conversation?
>> Can developers increase this limitations for using all memory that user
>> have?
> Hi Artem,
> The conclusion was that although the first problem encountere
> On 19 May 2015, at 9:35am, Artem wrote:
>> Can developers increase this limitations for using all memory that user
>> have?
> The answer to this depends on which operating system you are
> running and how it is configured. The answers cannot be changed by changing
ack might been exhausted, perhaps before a pure OOM condition was
>> reached.
>>
> The code I was referring to in earlier posts performed a realloc. I wonder
> if perhaps there is a corner case in there. Growing a block potentially
> means moving a block, so if the library was copyin
;>> think Sqlite is responsible when malloc lies about what should be
>>> considered a failed memory allocation which should return null.
> SDR
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
? ?,
Artem mailto:devspec at yandex.ru
body FROM pages LIMIT 0,100
INSERT INTO pages_fts(title, body) SELECT title, body FROM pages LIMIT
100,200
etc
It was OK until 600 mln rows, after 600 mln rows it failed with Segmentation
Fault error (on Ubuntu).
> On Apr 29, 2015 1:56 AM, "Artem" wrote:
>> So, is
So, is that a real bug of SQLIte and how to fix it?
I really need to create huge FTS-indexes like that,
I have 32GB of memory for that.
Many thanks for your attention.
> On 04/29/2015 05:27 AM, Artem wrote:
>> , Tim.
>>
>> ?? ?? 29 ?? 2015 ?., 1:21:00:
, Tim.
?? ?? 29 ?? 2015 ?., 1:21:00:
> On 28 Apr 2015 at 23:14, Artem wrote:
>>> How about trying the sqlite3.exe command line utility. put your
>>> sql for that operation in a text file, launch the program, open
>>> the database, then read
Scott Doctor
> scott at scottdoctor.com
> ------
> On 4/28/2015 6:29 AM, Artem wrote:
>> No, I'm sure that is not a problem in my software, it exactly
>> error of the SQLite library. My software is very simple - it creates
>> simple connection to the database with connec
control of valgrind
> and have its memcheck tool take a look.
> -Urspr?ngliche Nachricht-
> Von: Artem [mailto:devspec at yandex.ru]
> Gesendet: Dienstag, 28. April 2015 14:36
> An: General Discussion of SQLite Database
> Betreff: Re: [sqlite] Segfault during FTS index c
> On 04/03/2015 10:16 PM, Artem wrote:
>> Hi!
>>
>> The situation is like that. There?s a SQLite database with around 3 billion
>> records. Each record consists of a certain CHAR field and several other
>> additional fields with different types. The file size i
Hi!
The situation is like that. There?s a SQLite database with around 3 billion
records. Each record consists of a certain CHAR field and several other
additional fields with different types. The file size is approx. 340 gb. The
maximum content length in the doc field is 256 symbols, the
Let's create and populate a test table:
sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY NOT NULL);
sqlite> INSERT INTO foo VALUES (1);
sqlite> INSERT INTO foo VALUES (100);
sqlite> INSERT INTO foo VALUES (200);
sqlite> INSERT INTO foo SELECT MAX (id) + 1 FROM foo WHERE id >= 100 AND
id < 200;
Another example:
CREATE TABLE a (
id int,
flags int
);
INSERT INTO a VALUES(1, 0);
INSERT INTO a VALUES(2, 1);
CREATE TABLE b AS
SELECT id, (flags & 1) as flag FROM a where (flags & 1) = 1;
In following SQL sqlite3_column_type returns null affinity:
SELECT b.flag FROM a
LEFT JOIN b ON
I have following script:
CREATE TABLE a (d datetime);
INSERT INTO a insert into('01-01-01');
CREATE TABLE b AS SELECT d FROM a;
Then I use this sql:
SELECT d FROM b;
In SQLite version 3.6.4 the "datetime" affinity is persisted, but from version
3.6.16
(maybe earlier) the affinity is lost
Thanks
--- [EMAIL PROTECTED] wrote:
> "Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
> > Artem Yankovskiy
>
> > wrote:
> > > I know about DROP TABLE.
> > > I have not knew when compatibility DROP TABLE
> and
> > > SELECT..
It's a pity :(
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Artem Yankovskiy
>
> wrote:
> > I know about DROP TABLE.
> > I have not knew when compatibility DROP TABLE and
> > SELECT...
> >
> > DROP TABLE (select name from sqlite_master
> where.
Hi Igor.
I know about DROP TABLE.
I have not knew when compatibility DROP TABLE and
SELECT...
DROP TABLE (select name from sqlite_master where...)
did not work.
Can I build resembling query?
Thanks.
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Artem Yankovskiy
>
> wrote:
&g
Hello.
I like delete some of table.
For example:
I can run query:
select name from sqlite_master where name like
'prefix_%';
Can I delete found tables?
Using only sql.
It's real?
Best regards,
Artem Yankovskiy
gt; I'm using version 3.3.4 on Windows.
>
> Thanks,
> Jeffrey Rennie
>
Best regards,
Artem Yankovskiy
Вы уже с Ya
> To unsubscribe, send email to
> [EMAIL PROTECTED]
>
-
>
>
Best regards,
Artem Yankovskiy
Вы уже с Yahoo
Thanks. :-)
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> On 12/22/06, Artem Yankovskiy
> <[EMAIL PROTECTED]> wrote:
> > Thanks!
> > Can at whom is small sample on C/С ++?
>
>
> some example code here:
>
> SqliteImporter and SqliteReplicato
Thanks!
Can at whom is small sample on C/С ++?
--- jose isaias cabrera <[EMAIL PROTECTED]> wrote:
>
> http://www.dprogramming.com/enticeaddrbook.html
>
>
>
>
> - Original Message -
> From: "Artem Yankovskiy" <[EMAIL PROTECTED]>
&g
Hello!
Can I get sample source code for using DLL?
Yahoo!?
Yahoo! !
http://ru.mail.yahoo.com
-
To unsubscribe, send email to [EMAIL PROTECTED]
Hi Jason.
Can make is easier so:
SELECT * FROM film WHERE
genre IN ("comedy", "drama")
AND tag IN ("bill murry", "scarlett o'hara"
,"silly");
--- jason schleifer <[EMAIL PROTECTED]> wrote:
> heya folks,
>
> I'm trying to figure out the proper syntax for doing
> a query of something
> like
Thanks Richard.
I will try.
--- [EMAIL PROTECTED] пишет:
> Artem Yankovskiy <[EMAIL PROTECTED]> wrote:
> > Question, whether probably to count up how much an
> > free space there is in this a DB?
> >
>
> If the first byte of the database file is called
>
Hello.
There is a DB. auto_vacuum is not used. One of tables
of a database contains 500 records.
We for example delete from it 300 records. The place
in a database was released, but the size of a file has
not decreased how is not set auto_vacuum.
Question, whether probably to count up how much an
* Headers-only (no need to compile or install).
* Single file (you can just copy it into your project).
* "Cheap" thread-safety (to work with a database you /must/ lock it).
* One-liners (you can write code that binds variables and runs the query
/ takes result from it, in a single statement).
*
29 matches
Mail list logo