Re: [sqlite] Spooky behavior of sqlite3_prepare_v2

Solved this myself so no help needed. Apparently the problem was last parameter in sqlite3_prepare_v2 which was pointing to unallocated memory after execution. As NULL is allowed, I simply put it to NULL to ignore it which solved the whole thing. That kind of explains all the spooky behaviour as

Re: [sqlite] Lemon maintainer

On Tue, Oct 12, 2010 at 6:54 PM, Vincent Adam Burns wrote: > Is there an active maintainer for the Lemon Parser? I'm getting some > parsing conflicts, ex: > > statement ::= IF LEFT_PAREN expression RIGHT_PAREN statement ELSE > statement. > statement ::= IF LEFT_PAREN

[sqlite] Spooky behavior of sqlite3_prepare_v2

I don't believe this! Now I want to do a wrapper for Insert - by doing simple calls to: loop this: { sqlite3_prepare_v2 sqlite3_bind_* sqlite3_step sqlite3_finalize } By my understanding this is what SQLite exec does - prepare, then step, then finalize and it works. The problem is - when I

[sqlite] Single Support

If I get it correctly, currently SQLite only supports REALS only as Double, requiring 8 byte per number, which is for many applications quite expensive. What are the chances to get Single support in a future release? What is the appropriate way to propose such a feature? I understand that there

[sqlite] Unsafe trigger functions (was: Registering a custom tokenizer per database rather than per connection)

Quoth Scott Hess , on 2010-10-12 10:33:54 -0700: > Since the tokenizer-registration code accepts an encoded pointer to a > vtable, it probably should be considered unsafe to expose to users. > > For Gears and Chrome, where SQLite is exposed to web developers, we > did manual

Re: [sqlite] Speed up DELETE of a lot of records

On 12 Oct 2010, at 6:30pm, Scott Hess wrote: > Something like: > > INSERT INTO my_table VALUES (blah, blah, blah); > DELETE FROM my_table WHERE date_or_whatever < some_limit LIMIT 5; > > If your insert load consistently tracks from day to day, this mostly > looks like a circular buffer.

Re: [sqlite] Registering a custom tokenizer per database rather than per connection

On Tue, Oct 12, 2010 at 8:40 AM, Drake Wilson wrote: > Just to clarify, a trigger isn't useful for this in general, because > you still have nowhere to get the function pointer from.  Above I was > worrying that the current SQLite code might be less safe than it could > be as

Re: [sqlite] Speed up DELETE of a lot of records

On Mon, Oct 11, 2010 at 8:13 AM, Jay A. Kreibich wrote: > On Mon, Oct 11, 2010 at 02:08:54PM +0200, Michele Pradella scratched on the > wall: >>   Ok so the main idea it's always the same: split the DELETE to make the >> operation on less records, but do it more often. > >  

Re: [sqlite] gui for data entry

Oliver > I use OOo under WinXP and had a problem related to 3.2.1 in connection with > UNIQUE CONSTRAINTS Not sure I understand everything in the thread, but worth knowing as I learn. Thanks, Graham ___ sqlite-users mailing list

Re: [sqlite] gui for data entry

Vivien, > Libgda: http://www.gnome-db.org This is certainly a new one for me, I will give it a look. Thanks, Graham ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] gui for data entry

Graham Smith writes: [...] > Mmmm, still stuck on 3.2.1 with current release of Ubuntu (the OS I > use most of the time, followed by my Mac), so interesting to hear your > views on 3.2.1. > I use OOo under WinXP and had a problem related to 3.2.1 in connection with UNIQUE

Re: [sqlite] gui for data entry

David > Take a look at Kexi. (kexi-project.org) It is part of the Koffice suite, but > can be used >standalone. I had tested it on Windows and had no trouble > installing it. I have also used this before (on Ubuntu) as well as the OOo option, I suppose I find the SQLite GUIs that much nimbler

Re: [sqlite] gui for data entry

> the best is to take OOo 330 m9 > > that is a milestone without all former illnesses - believe me I suffered a lot > > D o n' t use 3.2.1!!! Mmmm, still stuck on 3.2.1 with current release of Ubuntu (the OS I use most of the time, followed by my Mac), so interesting to hear your views on 3.2.1.

Re: [sqlite] gui for data entry

On 12 October 2010 17:51, Graham Smith wrote: > There are several GUI editors for SQLite, but is there one that allows > creation of simple forms to allow data entry.  Although some allow > adding data to a single table, none that I have looked at seem to > allow a new record

Re: [sqlite] gui for data entry

Take a look at Kexi. (kexi-project.org) It is part of the Koffice suite, but can be used standalone. I had tested it on Windows and had no trouble installing it. It uses sqlite as its back end storage and allows you to create forms, etc. Its aim is to be "like" MS Access. David --- On Tue,

[sqlite] problems with getBytes

I hope I'm not OT, if I am please forgive me! I'm writing a Java application I use sqlite to save data on disk. Everything works fine, I used sqlite successfully for months, with any type of data but bytes. I need to store and read from my sqlite database BLOB fields. I created a table "CREATE

Re: [sqlite] gui for data entry

ahh I forgot: the best is to take OOo 330 m9 that is a milestone without all former illnesses - believe me I suffered a lot D o n' t use 3.2.1!!! Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] gui for data entry

Oliver > works fine now but take the latest odbc driver from here: > > http://www.ch-werner.de/sqliteodbc/sqliteodbc-088pre2.exe > > because the 0.87 has a problem under special circumstances (makros) - > something > you will use if you like to automate some functions in your forms or make them

Re: [sqlite] gui for data entry

Graham Smith writes: [...] > > Thanks, I did consider this, but the last time I tried, it was very > clunky, and crashed a lot, but I will have another look since you > have suggested it. [...] works fine now but take the latest odbc driver from here:

Re: [sqlite] gui for data entry

Oliver > OpenOffice Base > > you need an ODBC driver too (http://www.ch-werner.de/sqliteodbc/) Thanks, I did consider this, but the last time I tried, it was very clunky, and crashed a lot, but I will have another look since you have suggested it. Graham

Re: [sqlite] gui for data entry

Graham Smith writes: > > There are several GUI editors for SQLite, but is there one that allows > creation of simple forms to allow data entry. Although some allow > adding data to a single table, none that I have looked at seem to > allow a new record to be added when it

[sqlite] gui for data entry

There are several GUI editors for SQLite, but is there one that allows creation of simple forms to allow data entry. Although some allow adding data to a single table, none that I have looked at seem to allow a new record to be added when it involves more than one table. It needs to be cross

Re: [sqlite] Registering a custom tokenizer per database rather than per connection

Quoth Travis Orr , on 2010-10-12 08:17:38 -0700: > Drake Wilson said: > - However, it now occurs to me that it may be possible to use the > - fts3_tokenizer() function in a trigger, which is probably a bad thing > - when writing to untrusted databases. > > I suppose the only way

Re: [sqlite] Speed up DELETE of a lot of records

Thank you for the advice, I'll try it in my application. regards Il 12/10/2010 17.17, Pavel Ivanov ha scritto: > Michele, > > Here is another thought for you to consider. Apparently your > application consistently generates some records, each record is marked > with a timestamp of its creation

Re: [sqlite] Speed up DELETE of a lot of records

Michele, Here is another thought for you to consider. Apparently your application consistently generates some records, each record is marked with a timestamp of its creation and after some time you have to garbage-collect all records that are at least at a certain amount of time in the past. You

Re: [sqlite] Registering a custom tokenizer per database rather than per connection

Drake Wilson said: - However, it now occurs to me that it may be possible to use the - fts3_tokenizer() function in a trigger, which is probably a bad thing - when writing to untrusted databases. I suppose the only way to accomplish it would be to recompile sqlite3 with my custom tokenizer in

Re: [sqlite] Detach command in 3.7.1 gives "database is locked" error

On Sat, Oct 9, 2010 at 11:28 AM, Jim Wilcoxson wrote: > This may be a bug in 3.7.1, or I may have been taking advantage of a flaw > in > 3.6.18: > > HashBackup uses SQLite to store backup data in a meta data db and file data > archive db. First I open the main database, then

Re: [sqlite] String field as primarykey

journal file is creating between transactions. On Tue, Oct 12, 2010 at 3:00 PM, Oliver Peters wrote: > Durga D writes: > > [...] > > > But performance issue is there. > > > > Is there anyway to optimize this? > > > > > maybe you should try > > PRAGMA

Re: [sqlite] String field as primarykey

Hi Oliver, Thank you for your prompt response. I am using C++ wrappers in VC++ 8.0 applicaiton. Where should I add PRAGMA? And also when I insert 100k records by using statement, "m_oDB.execDML(strQuery);" virtual memory is keep on increasing. Any idea? Durga. On Tue, Oct 12,

Re: [sqlite] SQLITE: sorting

Look in your mailbox. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] using SQLite with mod_perl

>-Message d'origine- >De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] De la part de Clark Christensen >Envoyé : lundi, 11. octobre 2010 17:26 >À : General Discussion of SQLite Database >Objet : Re: [sqlite] using SQLite with mod_perl > >>So, I want all the

[sqlite] SQLITE: sorting

Hi, I saw this in the forum: I've developped an SQLite extension including a very similar collation: it sorts the (integral) prefix first and, in case of a draw, orders based on the Unicode suffix. It currently doesn't cope with floating-point prefixes but can surely be adapted easily to do so.

Re: [sqlite] Adding a string in front of what is already in a field

"P Kishor" wrote... > José, > > Please note Igor's very important cautionary note below -- > > On Mon, Oct 11, 2010 at 7:05 AM, Igor Tandetnik > wrote: >> P Kishor wrote: >>> UPDATE OpenJobs >>> SET notes = 'string to add in front\r\n' || notes >>>

Re: [sqlite] String field as primarykey

Durga D writes: [...] > But performance issue is there. > > Is there anyway to optimize this? > maybe you should try PRAGMA journal_mode = OFF; Oliver ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] String field as primarykey

Hi All, I have created a sqlite database with "create table EMP (F1 INTEGER ,F2 TEXT(1120) primary key collate nocase,F3 INTEGER ,LMD TEXT(1120) ,F4 TEXT(1120) ,F5 TEXT(1120));". Here F2(Field2) is primary key. I used transaction queries for every 25,000 records. But performance issue is