Re: [sqlite] DEvelopment Error

On Mon, Jul 25, 2011 at 09:13:49PM -0400, Daniel Spain scratched on the wall: > i most recently began making a text based gaming engine and am having > trouble. i downloaded the SQLITE3 package and did: implib sqlite3.lib > sqlite3.dll then copied sqlite3.lib to my project directory. in my >

[sqlite] DEvelopment Error

i most recently began making a text based gaming engine and am having trouble. i downloaded the SQLITE3 package and did: implib sqlite3.lib sqlite3.dll then copied sqlite3.lib to my project directory. in my programs main healer i did : #include "sqlite3ext.h" and linked the LIB file. then

Re: [sqlite] Code First Support?

On 26 Jul 2011, at 12:02am, Ryan Killian wrote: > Im very new to system.data.sqlite, and was wondering if there's any way to > get code-first support working for EF 4.1 yet? Ive seen posts saying its not > supported, but all are dated prior to April. Okay, after a quick google this turns out to

[sqlite] Code First Support?

Hello, Im very new to system.data.sqlite, and was wondering if there's any way to get code-first support working for EF 4.1 yet? Ive seen posts saying its not supported, but all are dated prior to April. Thanks! ___ sqlite-users mailing list

Re: [sqlite] SQLite3.dll for Win 64

The makefile builds lemon.exe from lemon.c as part of the build process, so make sure it was generated correctly as well. "lemon -x" should print a version number. "lemon -?" should print an error and help message. Again, HTH. -Shane On Mon, Jul 25, 2011 at 5:51 PM, Shane Harrelson

Re: [sqlite] SQLite3.dll for Win 64

The TK_* identifiers are all defined in parse.h which is generated by lemon.exe from parse.y. parse.h is "included" in the amalgamation file, sqlite3.c. Try deleting your parse.c and parse.h and sqlite3.c and re-running your make. Check that parse.h was generated correctly and subsequently

Re: [sqlite] SQLite3.dll for Win 64

Probably is even possible, but much better would be to have this dll especially for the community. Anyone have done this dll before? 2011/7/25 Robert Myers > Check your compiler documentation. You should be able to link C .obj > files and call C functions without too much

Re: [sqlite] [FTS3] Understanding the Flow of data through the tokenizer

On Mon, Jul 25, 2011 at 9:54 AM, Dan Kennedy wrote: > On 07/24/2011 08:16 PM, Abhinav Upadhyay wrote: >> Hi, >> >> I am trying to write my own custom tokenizer to filter stopwords apart >> from doing normalization and stemming. I have gone through the >> comments in

Re: [sqlite] SQLite3.dll for Win 64

Check your compiler documentation. You should be able to link C .obj files and call C functions without too much hassle. The biggest issue will be getting all the functions declared in a Pascal readable format. On 7/25/2011 3:10 PM, Everton Vieira wrote: > The software that uses this dll is made

Re: [sqlite] SQLite3.dll for Win 64

The software that uses this dll is made in pascal so i can't include c files in the project. 2011/7/25 Teg > Hello Everton, > > EV> Don't have any easy way to make this dll? There's a lot of 64bits > systems > EV> out there that will need this dll. > > I just compile it into my

Re: [sqlite] SQLite3.dll for Win 64

Hello Everton, EV> Don't have any easy way to make this dll? There's a lot of 64bits systems EV> out there that will need this dll. I just compile it into my program and don't bother with DLL's. I find that DLL's in general make my software less reliable so, I avoid them. Static linking all the

Re: [sqlite] SQLite3.dll for Win 64

So, now i'm stock on this errors: sqlite3.c sqlite3.c(40972) : warning C4244: '=' : conversion from '__int64' to 'int', poss ible loss of data sqlite3.c(57259) : error C2065: 'TK_REGISTER' : undeclared identifier sqlite3.c(57266) : error C2065: 'TK_UMINUS' : undeclared identifier sqlite3.c(57266)

Re: [sqlite] Reducing compiled size

For the record, I know that the documentation says the OMIT_* flags don't work with the regular amalgamation, but I have in fact used many of them and they seem to work. Two that only partially worked (a bug?) are SQLITE_OMIT_AUTOVACUUM and SQLITE_OMIT_AUTHORIZATION (I am not sure about that

[sqlite] New madIS v1.3 release

madIS is an extensible relational database system built upon the SQLite database and with extensions written in Python (via APSW SQLite wrapper). Its is developed at: http://madis.googlecode.com Due to madIS’ SQLite core, the database format of madIS is exactly the same as SQLite’s one. This

Re: [sqlite] SELECT query first run is VERY slow

On Mon, Jul 25, 2011 at 5:45 PM, Григорий Григоренко wrote: > > 1) SQLITE has to read about _half of index_ before it can use it (and > understand there are no records matching query). > > If cache is enough to hold 50 Mb then on subsuquent queries sqlite process is > not

Re: [sqlite] SQLite3.dll for Win 64

ops! I've run on cmd 2011/7/25 John Drescher > On Mon, Jul 25, 2011 at 10:52 AM, Everton Vieira > wrote: > > So far so good but return an error: > > > > C:\Dattna\Applications\Installs\sqlite\sqlite-src-3070701>nmake -f > > Makefile.msc sqlite3.dll >

Re: [sqlite] SELECT query first run is VERY slow

You need to normalize your "kind" value. .pragma cache_size=15000; drop index idxlog_kind_computer; create table kind(id integer,kind text); insert into kind values(1,'debug'); insert into kind values(2,'error'); insert into kind values(3,'info'); insert into kind values(4,'timing'); insert

Re: [sqlite] Reducing compiled size

Hi Richard, I'm using gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5). Also tried with VC9 which yields very similar sizes. $ gcc main.c sqlite3.c -lpthread -ldl $ size a.out textdata bss dec hex filename 51447536881168 519331 7eca3 a.out It looks like this could have

Re: [sqlite] Reducing compiled size

On Mon, Jul 25, 2011 at 10:39 AM, Dave Hope wrote: > Hi all, > > I read on the sqlite website that the compiled size can be reduced to > 275KiB ( http://www.sqlite.org/different.html#small ), however I'm > struggling to get it much below 500 KiB using the SQLITE_OMIT_* >

Re: [sqlite] Reducing compiled size

Thanks Stephan Sorry, you're quite right. I was actually using OPTS="" but omitted it when I pasted it into my e-mail. Thanks Dave On Mon, Jul 25, 2011 at 3:55 PM, Stephan Beal wrote: > On Mon, Jul 25, 2011 at 4:51 PM, Dave Hope wrote: > >> Hi Stephan, >>

Re: [sqlite] Reducing compiled size

On Mon, Jul 25, 2011 at 4:51 PM, Dave Hope wrote: > Hi Stephan, > > I initially added these to the Makefile, but looking at the mailing > list suggested otherwise: > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg37813.html That post says to use: make "OPTS=-..." So

Re: [sqlite] SQLite3.dll for Win 64

On Mon, Jul 25, 2011 at 10:52 AM, Everton Vieira wrote: > So far so good but return an error: > > C:\Dattna\Applications\Installs\sqlite\sqlite-src-3070701>nmake -f > Makefile.msc sqlite3.dll > > Microsoft (R) Program Maintenance Utility Version 10.00.30319.01 > Copyright (C)

Re: [sqlite] SQLite3.dll for Win 64

So far so good but return an error: C:\Dattna\Applications\Installs\sqlite\sqlite-src-3070701>nmake -f Makefile.msc sqlite3.dll Microsoft (R) Program Maintenance Utility Version 10.00.30319.01 Copyright (C) Microsoft Corporation. All rights reserved. cl.exe -O2 -Femkkeywordhash.exe

Re: [sqlite] Reducing compiled size

Hi Stephan, I initially added these to the Makefile, but looking at the mailing list suggested otherwise: http://www.mail-archive.com/sqlite-users@sqlite.org/msg37813.html Thanks Dave On Mon, Jul 25, 2011 at 3:46 PM, Stephan Beal wrote: > On Mon, Jul 25, 2011 at 4:39

Re: [sqlite] Reducing compiled size

On Mon, Jul 25, 2011 at 4:39 PM, Dave Hope wrote: > make sqlite3.c "-DSQLITE_OMIT_ALTERTABLE -DSQLITE_OMIT_ANALYZE > Shouldn't that be: make sqlite3.c CPPFLAGS="..." ? Make doesn't understand -D (no, that's not a smiley). -- - stephan beal

Re: [sqlite] SELECT query first run is VERY slow

On 25-07-2011 15:45, Григорий Григоренко wrote: > I think I narrowed the problem a bit. Guys, hope I'm not bothering you too > much :) > > > I've calculated size of index (it is index on log (kind,computer) ) of its > own: dropped index, run VACUUM and re-created index. I thought that, if

[sqlite] Reducing compiled size

Hi all, I read on the sqlite website that the compiled size can be reduced to 275KiB ( http://www.sqlite.org/different.html#small ), however I'm struggling to get it much below 500 KiB using the SQLITE_OMIT_* options. I'm producing my own amalgamation, which I believe you can use the OMIT options

Re: [sqlite] SELECT query first run is VERY slow

I think I narrowed the problem a bit. Guys, hope I'm not bothering you too much :) I've calculated size of index (it is index on log (kind,computer) ) of its own: dropped index, run VACUUM and re-created index. Database file increased by 105 Mb (and sqlite3 process counter shows that there

Re: [sqlite] EXT :Re: SELECT query first run is VERY slow

> > #1 I take it your query is CPU bound the first time? Hmm, not sure. CPU was still under 1 % usage. > > #2 Can you show us the query planner please? > #3 Can you show us the query planner minus the "INDEXED BY"? Sure. Executing: SELECT * FROM log INDEXED BY idxlog_kind_computer WHERE

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

Thanks for persisting with me on this, I recompiled it as your email below and it now runs in both windows and linux. I have not tried the Debug version again, so the problem first time around could have been finger trouble. On a side note it look like I'm also getting a memory leak in linux.

Re: [sqlite] EXT :Re: SELECT query first run is VERY slow

An 8X speedup is a pretty good achievement...congrats... #1 I take it your query is CPU bound the first time? #2 Can you show us the query planner please? #3 Can you show us the query planner minus the "INDEXED BY"? #4 Can you show us sqlite_stat1? #5 Can you show us your tables now? #6

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

On 25 Jul 2011, at 8:26am, Mattia wrote: > I've tried doing transactions (committing and disposing them after each one) > and yes, I've closed the database after doing my operations, with no luck at > all. You understand that you don't do this: BEGIN TRANSACTION insert 1 END TRANSACTION BEGIN

Re: [sqlite] SELECT query first run is VERY slow

Okay, here are some steps I've done. 1) normalize db; I've created single table (item). "computer","process" and "who" fields in log table became rowid integers pointing to this table. "kind" is still a short string. 2) give up covering indexes; For those not aware

Re: [sqlite] System.Data.SQLite: commands not persisting on db.

Hello, sorry for my late reply but I've been away the past week. I've tried doing transactions (committing and disposing them after each one) and yes, I've closed the database after doing my operations, with no luck at all. Mat. 2011/7/15 Simon Slavin > > On 15 Jul 2011,