The suggested command did create the win32 setup for me, but I'd also like
the x64 setup and this replaced:
set_Release_x86_2010.bat
with
set_Release_x64_2010.bat
and build again. This however also build the x86 target for some reason and
no x64 setup file is produced (bake fails, complaining
Bernhard Mogens Ege wrote:
This however also build the x86 target for some reason and no x64 setup
file is produced (bake fails, complaining about missing x64 files).
This means that the x64 binaries were not built first using build.bat.
You should be able to build binaries for all
But I did use build.bat after using set_Release_x64_2010.bat. This is what
is so strange.
Build_all.bat fails as it seems vsSp.bat detects that I have VS2008
installed, but this is installed by SQL 2008 R2 and lacks pretty much
everything (used for business intelligence design only and has no
Earlier this year I was bothering this list with many questions about
the sqlite virtual table support, because I needed (among other
things) an efficient way to compute moving averages. And here is the
result, free for anyone to play with:
http://voksenlia.net/sqlite3/interpolate.c
Rather
Hello from france,
I have a bug with windows 98 and sqlite3.dll :
Missing export kernel32.dll SetFilePointerEx
The same code with previous version have no error.
Regards,
Roger//
___
sqlite-users mailing
I've managed to make it work.
What I've done:
- Uninstall SQLite provider for VS (both 3.5 and 4.0 versions were
installed)
- Download dlls for .NET 4.0
- Install SQLite provider for .net 4 and VS2010
sqlite-netFx40-setup-bundle-x86-2010-1.0.81.0.exe
- Update my connection string in parent
Hi Richard,
Richard Hipp d...@sqlite.org writes:
In shared-cache mode, the page cache is shared across threads. That means
that each thread must acquire a mutex on the page cache in order to read
it. Which means that access to the page cache is serialized.
I just ran our concurrency test in
On Mon, Aug 13, 2012 at 8:51 AM, Boris Kolpackov bo...@codesynthesis.comwrote:
Also, your explanation doesn't feel quite satisfactory to me.
In shared-cache mode, SQLite acquires a mutex on the shared cache, thus
serializing access.
The mutex is acquired because it is usually needed. You
The shared cache does not know that the table is small nor that there is
nothing else to load.
When a thread accesses that shared cache, it must protect itself from the data
page it's on being modified, either because the page is simply flushed from the
cache (if the cache does such things) or
Hi,
I've recently started using sqlite3 c-library. I'm using the in-memory
databases which are pretty fast since I'm loading data dynamically into
sqlite3 from a different backend (had to do this as we wanted to provide
an SQL interface to our users).
It would be very nice if I could also
Hi Richard,
Richard Hipp d...@sqlite.org writes:
In shared-cache mode, SQLite acquires a mutex on the shared cache, thus
serializing access.
Oh, that's quite a surprise. I would have never said that something
like this is going on just by reading the documentation page on shared
cache:
Another idea for you:
In our test, on the other hand, each thread queries its own set of
rows from the table. So, based on your explanation, here each thread
should end up with its own set of pages (more or less). However, even
in this case, I still observe a near sequential performance.
There are four levels to the shared-cache locking model: transaction
level locking, table level locking, cache level locking, and schema
level locking. They are described in the following three sub-sections.
This would be a bad way of documenting this because cache level
locking works on a
I wonder if it would be possible to refine the cache locking mechanism.
If I understand the modified DB/Table locking semantics when running under a
shared-cache, it appears that the cache page should be protected against
readers and writers.
Perhaps only the list of pages in the cache need to
On 13 Aug 2012, at 3:11pm, Marc L. Allen mlal...@outsitenetworks.com wrote:
I wonder if it would be possible to refine the cache locking mechanism.
If I understand the modified DB/Table locking semantics when running under a
shared-cache, it appears that the cache page should be protected
I don't believe I'm suggesting one mutex per page.
If I understand correctly, the purpose of the overall mutex is to prevent a
page from being removed underneath a user. If the standard DB locking
semantics are working properly, I think there is no possibility of a page's
data from being
This doesn't appear to build everything needed as when I install the bundles
(x86 and x64), nothing is added to the global assembly cache in
C:\windows\assembly\ (did ask the installer to add to the GAC), making every
binary using System.Data.SQLite fail. The files are put into C:\Program
Files\..
On Mon, Aug 13, 2012 at 03:43:46PM +0200, Bishwa Shrestha scratched on the wall:
Hi,
I've recently started using sqlite3 c-library. I'm using the
in-memory databases which are pretty fast since I'm loading data
dynamically into sqlite3 from a different backend (had to do this as
we wanted
Hi Pavel,
Pavel Ivanov paiva...@gmail.com writes:
There are four levels to the shared-cache locking model: transaction
level locking, table level locking, cache level locking, and schema
level locking. They are described in the following three sub-sections.
This would be a bad way of
Hi Marc,
Marc L. Allen mlal...@outsitenetworks.com writes:
If I understand correctly, the purpose of the overall mutex is to prevent a
page from being removed underneath a user. If the standard DB locking
semantics are working properly, I think there is no possibility of a page's
data from
roger 66 wrote:
I have a bug with windows 98 and sqlite3.dll :
Missing export kernel32.dll SetFilePointerEx
Would you try again with the latest trunk code and see if that
clears the issue?
--
Joe Mistachkin
___
sqlite-users mailing list
Bernhard Mogens Ege wrote:
Build_all.bat fails as it seems vsSp.bat detects that I have VS2008
installed, but this is installed by SQL 2008 R2 and lacks pretty much
everything (used for business intelligence design only and has no C#/C++
compiler).
Yeah, the Visual Studio detection logic
Bernhard Mogens Ege wrote:
This doesn't appear to build everything needed as when I install the
bundles
(x86 and x64), nothing is added to the global assembly cache in
C:\windows\assembly\ (did ask the installer to add to the GAC), making
every
binary using System.Data.SQLite fail. The
How can I judge whether a file is a database file? Is there a function that I
can use for this purpose?
Help!
Hope for you reply.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 14 Aug 2012, at 2:57am, daedae11 daeda...@126.com wrote:
How can I judge whether a file is a database file? Is there a function that I
can use for this purpose?
You can use the SQLite library call to open it and see whether you get an error
back. But it might be better to open the file
In linux I use the command 'file yourfilenamehere' and I get as an
answer something like 'yourfilenamehere: SQLite 3.x database' if it
is an Sqlite3 database.
Regards,
Luis
On Tue, Aug 14, 2012 at 09:57:33AM +0800, daedae11 wrote:
How can I judge whether a file is a database file? Is there a
Thank you. I got it. And I have another question. Does function sqlite3_exec
support UTF-16?
At 2012-08-14 10:01:13,Simon Slavin slav...@bigfraud.org wrote:
On 14 Aug 2012, at 2:57am, daedae11 daeda...@126.com wrote:
How can I judge whether a file is a database file? Is there a function
On 14 Aug 2012, at 3:05am, daedae11 daeda...@126.com wrote:
Thank you. I got it. And I have another question. Does function sqlite3_exec
support UTF-16?
No. sqlite3_exec() is a wrapper around sqlite3_prepare_v2(), and
sqlite3_prepare_v2() expects UTF-8. For UTF-16 you should be using
If I use the group of:
sqlite3_prepare16_v2()
sqlite3_step()
andsqlite3_finalize()
how can I get the names of a table's columns from a SELECT sql sentence?
At 2012-08-14 10:11:31,Simon Slavin slav...@bigfraud.org wrote:
On 14 Aug 2012, at 3:05am, daedae11 daeda...@126.com wrote:
Thank you.
daedae11 daeda...@126.com wrote:
If I use the group of:
sqlite3_prepare16_v2()
sqlite3_step()
andsqlite3_finalize()
how can I get the names of a table's columns from a SELECT sql sentence?
sqlite3_column_name[16]
--
Igor Tandetnik
___
On 14 Aug 2012, at 4:14am, daedae11 daeda...@126.com wrote:
If I use the group of:
sqlite3_prepare16_v2()
sqlite3_step()
andsqlite3_finalize()
how can I get the names of a table's columns from a SELECT sql sentence?
To get the names of columns of a table, use the SQL command
PRAGMA
Thank you. And I found these functions:
const char *sqlite3_column_database_name(sqlite3_stmt*,int);
const void *sqlite3_column_database_name16(sqlite3_stmt*,int);
const char *sqlite3_column_table_name(sqlite3_stmt*,int);
const void *sqlite3_column_table_name16(sqlite3_stmt*,int);
const char
32 matches
Mail list logo