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 *sqli
On 14 Aug 2012, at 4:14am, daedae11 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 table_info(tab
daedae11 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
___
sqlite-users mailin
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" wrote:
>
>On 14 Aug 2012, at 3:05am, daedae11 wrote:
>
>> Thank you. I got it. And I have another
On 14 Aug 2012, at 3:05am, daedae11 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
sqlite3_prepare16_
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" wrote:
>
>On 14 Aug 2012, at 2:57am, daedae11 wrote:
>
>> How can I judge whether a file is a database file? Is there a function that
>> I can use for this pur
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
On 14 Aug 2012, at 2:57am, daedae11 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 as binary/text
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
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
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
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
sqli
Hi Marc,
"Marc L. Allen" 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 being modified underne
Hi Pavel,
Pavel Ivanov 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 documentin
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 wan
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\..
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 modif
On 13 Aug 2012, at 3:11pm, Marc L. Allen 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 against
> readers and w
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
> "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
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.
Hi Richard,
Richard Hipp 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:
http://www.sqlite.o
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 u
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
On Mon, Aug 13, 2012 at 8:51 AM, Boris Kolpackov wrote:
>
> 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 can argue that
there ar
Hi Richard,
Richard Hipp 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 different con
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 projec
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 l
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 than
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 C#/C
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
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 a
32 matches
Mail list logo
