True, "some" parts of "some" games can be implemented with DB
technology, particularly matrix- and graph-based ones. Not only for fast
storage and retrieval of game data, but, more interestingly, for
implementing complex computation algorithms through SQL queries, that
may prove faster than t
To add some thoughts to Peter's discussion...
In game design speed is definitely of the utmost importance since a
visual game is basically a UI that is time-sensitive (unlike nearly any
other type of software). It's usual to implement some slow data
mechanism, typically an internet service DB
> Any practical realtime video game using SQLite is probably
> doing so only to save and restore the game board between games.
and perhaps calculating the initial "maze" or other non time sensitive data
processing
> Even a cursory look into production
> quality video game development will tell
FYI. 2D/3D game usability is extremely sensitive to response time. A stock
in-memory SQLite database with plenty of memory is still too slow for
tracking the state of an interactive graphical game especially on portable
grade cpus. Any practical realtime video game using SQLite is probably
doing
In my day job, I am an SAP consultant - for over 20 years. Production
quality code? Yes, but only within the companies where I have worked - tax,
banking, inventory, procurement, sales, etc.
My interest in SQLite is a personal hobby project at the moment. I have a
couple of ideas for end user appl
On 1/17/18, petern wrote:
>
> Richard, since you're responding to questions, let me ask again about 3.22
> INTROPECTION_PRAGMAS release.
No. We are past pencils-down. No new features at this point.
--
D. Richard Hipp
d...@sqlite.org
___
sqlite-users
csv.c isn't a writer. Shane expected to write the file by inserting rows
into the vtable. He has no application whatsoever but for the shell.
Richard, since you're responding to questions, let me ask again about 3.22
INTROPECTION_PRAGMAS release.
Will function_list() be progressing at all toward
On 1/17/18, petern wrote:
> Take a look at the function shell_callback for hints.
If the goal is to create a TSV reader/writer, it seems like the CVS
reader/writer might be a better starting point, as it is unencumbered
by lots of other unrelated features as is the shell. You might be
able to ge
Take a look at the function shell_callback for hints. See the MODE_Csv
case.
You could start by cribbing the functions MODE_Csv uses for your own row
handler and then see what you'll have to figure out yourself.
Typically, if you are a serious product developer at a frontier in the
market, you wil
On 1/17/18, 11:07 AM, "sqlite-users on behalf of Jens Alfke"
wrote:
> If I were tackling this, I’d look for an open-source CSV parser/generator
> library. Once you have that, the part that reads/writes the rows to the
> database is pretty simple.
If they’re reading tab separated files, I woul
> On Jan 17, 2018, at 3:53 AM, Bart Smissaert wrote:
>
> You don't have to, just need a different wheel.
If I were tackling this, I’d look for an open-source CSV parser/generator
library. Once you have that, the part that reads/writes the rows to the
database is pretty simple.
—Jens
___
> I try very hard not to reinvent the wheel
You don't have to, just need a different wheel. I did this recently both
for .csv and also for .html
and working very nicely and far more flexible than using the code in
shell.c.
RBS
On Wed, Jan 17, 2018 at 10:54 AM, Shane Dev wrote:
> On 17 January
On 17 January 2018 at 08:45, petern wrote:
> Shane. Expect to do a lot of hacking on shell.c. It's not intended as a
> library but as the main program of a console application.
That's a shame. I try very hard not to reinvent the wheel especially when
the wheel question (shell.c) is widely used
Shane. Expect to do a lot of hacking on shell.c. It's not intended as a
library but as the main program of a console application. Another way
involves controlling the IO handles of your process and sending strings but
that will probably run into portability problems that are even a bigger
headach
Apparently the CSV virtual table supports neither changes (INSERT, UPDATE,
DELETE), nor reading single column csv files.
What I really want is the functionality of .import and .output SQLite shell
commands. Maybe a better strategy would be to compile shell.c with my c
program and call the function
On 1/16/18, Shane Dev wrote:
> I tried -
>
> sqlite> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='test.tsv');
>
> where test.tsv is a tab separated table. However
>
> select count(*) from t1;
>
> goes into an infinite loop. Do you how to specify a separator other than
> ","?
The "C" in CSV st
Thanks Peter,
That saved me hours of work.
According to the comments -
/* Read a single field of CSV text. Compatible with rfc4180 and extended
** with the option of having a separator other than ",".
I tried -
sqlite> CREATE VIRTUAL TABLE temp.t1 USING csv(filename='test.tsv');
where test.t
On 1/16/18, 10:29 AM, "sqlite-users on behalf of petern"
wrote:
> https://sqlite.org/csv.html
BTW typo on that page:
“The example above showed a single filename='th3file.csv' argument for the CSV
virtual table.”
Should be:
“The example above showed a single filename='thefile.csv' argumen
FYI. csv.c is already a separate C program which imports CSV files without
necessity of the SQLite shell:
https://sqlite.org/csv.html
On Tue, Jan 16, 2018 at 12:47 AM, Shane Dev wrote:
> Hi,
>
> I am looking for an efficient way to write a c program which performs the
> same function as the SQL
Hi,
I am looking for an efficient way to write a c program which performs the
same function as the SQLite shell command ".import"
My initial strategy is to include the sqlite library source files and copy
the control block from shell.c that begins after
if( c=='i' && strncmp(azArg[0], "import",
s depending on the compiler
> you use.
>
> Cheers
>
> --
> Adolfo J. Millan
>
>>
>> Mensaje original
>> De: eli
>> Para: sqlite-users@mailinglists.sqlite.org
>> Fecha: Sat, 30 Dec 2017 13:35:35 +0200
>> Asunto: [sqlite] C++ compile
sqlite-users@mailinglists.sqlite.org
> Fecha: Sat, 30 Dec 2017 13:35:35 +0200
> Asunto: [sqlite] C++ compiler
>
> Hello,
It would be awesome if SQLite could compile as a part of bigger C++ project.
Right now there is a bunch of pointer casting errors, that can be fixed in
a matt
users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Nelson, Erik - 2
Sent: Tuesday, January 2, 2018 9:50 AM
To: SQLite mailing list
Subject: Re: [sqlite] C++ compiler
Eli Sent: Saturday, December 30, 2017 6:36 AM
>It would be awesome if SQLite could compile as a part of bigger C++
On 30 Dec 2017, at 11:35am, eli wrote:
> It would be awesome if SQLite could compile as a part of bigger C++ project.
It can. It should work fine. This is the main way SQLite is intended to be
used. Download the "amalgamation" source code (one .h and one .c file) and
include them in your
Hi,
On Sat, Dec 30, 2017 at 5:35 AM, eli wrote:
> Hello,
>
> It would be awesome if SQLite could compile as a part of bigger C++ project.
> Right now there is a bunch of pointer casting errors, that can be fixed in
> a matter of hour IMHO.
Which OS/compiler are you trying?
What is the exact erro
Eli Sent: Saturday, December 30, 2017 6:36 AM
>It would be awesome if SQLite could compile as a part of bigger C++ project.
>Right now there is a bunch of pointer casting errors, that can be fixed in
>a matter of hour IMHO.
I don't have any trouble using it as part of a larger C++ project.
-
On Sat, Dec 30, 2017 at 5:35 AM, eli wrote:
> Hello,
>
> It would be awesome if SQLite could compile as a part of bigger C++
> project.
> Right now there is a bunch of pointer casting errors, that can be fixed in
> a matter of hour IMHO.
>
I'm not a very knowledgeable C++ programmer, but wouldn
Hello,
It would be awesome if SQLite could compile as a part of bigger C++ project.
Right now there is a bunch of pointer casting errors, that can be fixed in
a matter of hour IMHO.
Cheers,
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.
Simon,
> Your text makes it look like you think that that kind of corruption affects
> only existing rows. This is not the case. If you continue to write to a
> database which shows this problem, you can lose more of the existing rows
> and/or the new data you're trying to write. The proper
--Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Roberts, Barry (FINTL)
>Sent: Tuesday, 24 October, 2017 09:04
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] C# pragma integrity_check call throwing exceptio
On 24 Oct 2017, at 4:03pm, Roberts, Barry (FINTL) wrote:
> Our system would get a list of the rowid problems allowing it to log them and
> inform the user. I am currently testing using the 1.0.105.1 driver, however
> the ExecuteReader() call (above) throws an exception saying the database is
Hi,
I asked the following question a few weeks ago, but did not get any responses,
hoping someone may have an idea.
We are currently running System.Data.SQLite.dll 1.0.80.0 and would like to
upgrade to a newer version. However there are a variety of issues we have run
into, most of which I hav
> On Aug 25, 2017, at 7:56 PM, Papa wrote:
>
> const std::string& SQLite3_RDB::getSQLiteVersion(){
> tmp = sqlite_version();
> }
sqlite_version() is not a function in SQLite itself; is it from some wrapper
library you're using? Most likely the crash is in that function. Look at the
crash
Of Papa
>Sent: Friday, 25 August, 2017 20:56
>To: SQLite mailing list
>Subject: [sqlite] C++ sqlite_version()
>
>In my C++ program, I'd like to display the SQLite3 version. To do so,
>this is what I have done.
>
>class SQLite3_RDB {
> private:
> sqli
sqlite.org] On Behalf Of Papa
>Sent: Friday, 25 August, 2017 20:56
>To: SQLite mailing list
>Subject: [sqlite] C++ sqlite_version()
>
>In my C++ program, I'd like to display the SQLite3 version. To do so,
>this is what I have done.
>
>class SQLite3_RDB {
> priv
In my C++ program, I'd like to display the SQLite3 version. To do so,
this is what I have done.
class SQLite3_RDB {
private:
sqlite3* db; //!< Data Base
std::string tmp;
public:
SQLite3_RDB(){}
~SQLite3_RDB(){sqlite3_close(db); }
const std::string&
> On May 25, 2017, at 10:00 PM, Wout Mertens wrote:
>
> I would like to make it partially asynchronous, still doing most of the
> work on the main thread, but waiting in a helper thread. I was thinking
> that the longest delays will be from disk access, so sqlite_step().
SQLite has a cache, so
On 5/26/17, Wout Mertens wrote:
>
> Are the above assumptions correct? Any other calls (besides opening the db)
> that can take a long time?
Most of the work associated with opening the database connection
(which is to say, parsing the schema) is deferred until the first time
you call sqlite3_pre
On 2017/05/26 7:33 AM, Simon Slavin wrote:
On 26 May 2017, at 6:00am, Wout Mertens wrote:
Ideally there'd be some way to know if a _step() call will be served from
buffer…
There are (simplified) three possibilities: quick quick, slow slow, and slow
quick.
A) SQLite finds a good index for t
On Fri, May 26, 2017 at 7:33 AM Simon Slavin wrote:
>
> On 26 May 2017, at 6:00am, Wout Mertens wrote:
>
> > Ideally there'd be some way to know if a _step() call will be served from
> > buffer…
>
> There are (simplified) three possibilities: quick quick, slow slow, and
> slow quick.
>
[...]
Aha
On 26 May 2017, at 6:00am, Wout Mertens wrote:
> Ideally there'd be some way to know if a _step() call will be served from
> buffer…
There are (simplified) three possibilities: quick quick, slow slow, and slow
quick.
A) SQLite finds a good index for the search/sort and can easily locate all t
I am liking the simplicity of the better-sqlite3 Nodejs library, but it is
synchronous (for some good reasons), so it will hang the main thread until
sqlite is done.
I would like to make it partially asynchronous, still doing most of the
work on the main thread, but waiting in a helper thread. I w
On Tue, 9 Aug 2016 17:09:39 -0300
Paulo Roberto wrote:
> I would like something like this:
>
> "BEGIN EXCLUSIVE TRANSACTION;"
> "SELECT counter FROM mytable WHERE counterid = ?;"
> "UPDATE mytable SET counter=? WHERE counterid = ?;"
> "COMMIT TRANSACTION;"
begin transaction;
On Thu, Aug 11, 2016 at 4:34 AM, Paulo Roberto
wrote:
> Thank you very much, it worked!
Just remember that exposing a SQL function that de-references a
"user"-supplied integer value as a pointer is inherently unsafe.
Anyone can select remember(val, 0) or select remember(val, 101) and crash
(at
Thank you very much, it worked!
On Tue, Aug 9, 2016 at 11:49 PM, Richard Hipp wrote:
> On 8/9/16, Paulo Roberto wrote:
> >
> > I found your solution pretty elegant and I tried to implement it.
> > But after solving a lot of building issues with the sqlite3ext header
>
> It does not have to be i
On 8/9/16, Paulo Roberto wrote:
>
> I found your solution pretty elegant and I tried to implement it.
> But after solving a lot of building issues with the sqlite3ext header
It does not have to be implemented as a loadable extension. Just copy
the lines https://www.sqlite.org/src/artifact/8440f8
Thank you for all the answers.
Clemens,
The counterid in my case is a text field and not an integer. That's why I
need to sanitize.
Clemens and Keith,
As each of my process has its own connection to the database, I tried your
solution using BEGIN IMMEDIATE and it worked successfully.
Thank you.
> "BEGIN EXCLUSIVE TRANSACTION;"
> "SELECT counter FROM mytable WHERE counterid = ?;"
> "UPDATE mytable SET counter=? WHERE counterid = ?;"
> "COMMIT TRANSACTION;"
> I have a counter that I need to increment and get its previous value in one
> operation.
> To access this counter I must pass a
On 8/9/16, Richard Hipp wrote:
> Or, you could make remember() a two argument function:
>
>UPDATE mytable SET counter=remember(counter, $ptr)+1 WHERE counterid=$id
>
A sample implementation for this function can now been seen at
https://www.sqlite.org/src/artifact/8440f8d0b452c5cd
--
D. Ric
On 8/9/16, Richard Hipp wrote:
>
> UPDATE mytable SET counter=remember(counter)+1 WHERE counterid=?
>
Or, you could make remember() a two argument function:
UPDATE mytable SET counter=remember(counter, $ptr)+1 WHERE counterid=$id
Then bind $ptr to the address of the variable in which you wan
On 8/9/16, Paulo Roberto wrote:
>
> I need some help to ... increment a counter and get its
> former value.
> My question is: Preparing 4 statements, binding then and calling
> *sqlite3_step
> *for each one of then in order, would have the expected atomic operation
> behavior or not? If not, how
On 9 Aug 2016, at 9:09pm, Paulo Roberto wrote:
> My question is: Preparing 4 statements, binding then and calling *sqlite3_step
> *for each one of then in order, would have the expected atomic operation
> behavior or not?
You might be happier with BEGIN IMMEDIATE.
No other connections can make
Paulo Roberto wrote:
> I need some help to do a simple operation, increment a counter and get its
> former value.
> I could have some race condition, so the transaction must be atomic.
>
> I also would like to use prepared statements to accomplish that, so I have
> less effort sanitizing inputs.
I
Hello,
I need some help to do a simple operation, increment a counter and get its
former value.
I could have some race condition, so the transaction must be atomic.
I also would like to use prepared statements to accomplish that, so I have
less effort sanitizing inputs.
My problem:
I have a cou
> On Thu, 31 Mar 2016 10:21:53 -0400
> Richard Hipp wrote:
>
>> On 3/31/16, Kristaps Dzonsons wrote:
>>>
>>> Is there any interest in integrating this tool to have manpages in
>>> the doc distribution without downstream bits?
>>>
>>
>> I think that would be cool. Integrating your tool into the
> How about the CC0 license? I think it's designed for these sorts of
> things (you want to make something public domain even if you're not
> allowed to) - https://creativecommons.org/about/cc0/
Jonathon,
I think the problem is that LV is similar to Norway[1] in this regard,
so something like CC0
How about the CC0 license?
I think it's designed for these sorts of things (you want to make something
public domain even if you're not allowed to) -
https://creativecommons.org/about/cc0/
On Fri, 01 Apr 2016 00:05:30 +0100 Kristaps Dzonsons wrote
>> As for publ
On Thu, 31 Mar 2016 10:21:53 -0400
Richard Hipp wrote:
> On 3/31/16, Kristaps Dzonsons wrote:
> >
> > Is there any interest in integrating this tool to have manpages in
> > the doc distribution without downstream bits?
> >
>
> I think that would be cool. Integrating your tool into the source
>
>> As for public domain, I'm happy to put the sources under a similar
>> license. I can't speak for the voodoo of the public domain and the EU
>> (or is it country-by-country?), however.
>
> From an English translation I found of the Latvian law includes moral
> rights and is closer to the droit
On 31/03/16 14:39, Kristaps Dzonsons wrote:
>>> Is there any interest in integrating this tool to have manpages in the
>>> doc distribution without downstream bits?
>>
>> I think that would be cool. Integrating your tool into the source
>> tree would mean that as the comment formats evolve, your t
>> Is there any interest in integrating this tool to have manpages in the
>> doc distribution without downstream bits?
>
> I think that would be cool. Integrating your tool into the source
> tree would mean that as the comment formats evolve, your tool would
> evolve in lock-step. If your tool i
Hello,
I couldn't find any way to convert the SQLite docs (via sqlite.h) to
UNIX manpages, so I wrote a tool that does so:
https://github.com/kristapsdz/sqlite2mdoc
This generates one manpage per API reference with the proper SEE ALSO
(from collected references) and IMPLEMENTATION NOTES (the ra
On 3/31/16, Kristaps Dzonsons wrote:
>
> Is there any interest in integrating this tool to have manpages in the
> doc distribution without downstream bits?
>
I think that would be cool. Integrating your tool into the source
tree would mean that as the comment formats evolve, your tool would
evol
That's not an SQLitespeed feature but indeed a backwards-compatible
SQLite feature. (I had this wrong too at some point)
You probably already know, but to be clear: In SQL standard,
double-quotes indicate identifiers and single quotes indicate string values.
While the single quotes are used more
-Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org
> [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Chris
> Prakoso
> Sent: Tuesday, February 9, 2016 7:56 AM
> To: SQLite mailing list
> Subject: Re: [sqlite] C# + SQLite - Update/In
Thanks for the detailed explanation.
Regards,
Chris
On Tue, Feb 9, 2016 at 4:05 PM, R Smith wrote:
> That's not an SQLitespeed feature but indeed a backwards-compatible SQLite
> feature. (I had this wrong too at some point)
>
> You probably already know, but to be clear: In SQL standard, double
users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Chris Prakoso
Sent: Tuesday, February 9, 2016 5:09 PM
To: SQLite mailing list
Subject: Re: [sqlite] C# + SQLite - How do you do Multiple Rows Inserts/Updates?
Yes thank you. My SQLite i
Chris Prakoso wrote:
> insert into test (field1,field2) values (1,"two"),(2,"three")
>
> SQL Error: near ",": syntax error
You might want to update to a tool that is not years out of date.
Regards,
Clemens
Ok. Thanks for the reminder.
Regards,
Chris
On Tue, Feb 9, 2016 at 3:18 PM, Richard Hipp wrote:
> On 2/9/16, Chris Prakoso wrote:
> > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
> > double-quote as delimiter successfully.
> >
>
> That is supported for backwards com
Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
double-quote as delimiter successfully.
Regards,
Chris
On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin wrote:
>
> On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote:
>
> > *insert into test (field1,field2) values (1,"two"),(2,"t
Yes thank you. My SQLite is the latest, it's the front-end that is
outdated, which I have just swiftly corrected.
Regards,
Chris
On Tue, Feb 9, 2016 at 2:52 PM, Richard Hipp wrote:
> On 2/9/16, Clemens Ladisch wrote:
> > Chris Prakoso wrote:
> >> insert into test (field1,field2) values (1,"tw
On 9 Feb 2016, at 12:10pm, Chris Prakoso wrote:
> *insert into test (field1,field2) values (1,"two"),(2,"three")*
As well as the comments about your software being out of date, you need to know
that the text delimiter in SQLite is the non-directional single quote character
normally seen as an
On 2016/02/09 1:30 PM, Chris Prakoso wrote:
> Hi Clemens,
>
> Thanks for your reply. I've tried to use raw SQL but it didn't work
> either. Do you have any SQLite front-end that you use?
If I may suggest, try SQLitespeed (http://sqlc.rifin.co.za/) and add
your DB file, open it and then use th
Steven,
I don't use any back-end, the code I pasted here IS my back-end. I opted
for direct SQLite connection. So I don't use EF6 nor Linq.
Chris
On Tue, Feb 9, 2016 at 1:47 PM, Steven M. McNeese <
steven.mcneese at freedomparkdfw.com> wrote:
> Chris,
>
> What are you using in c# for SQLite b
Thanks Ryan,
I will definitely try it. I'm ok with raw SQL, just not familiar with the
odd ones like this multiple rows update.
Thanks a lot,
Chris
On Tue, Feb 9, 2016 at 12:42 PM, R Smith wrote:
>
>
> On 2016/02/09 1:30 PM, Chris Prakoso wrote:
>
>> Hi Clemens,
>>
>> Thanks for your reply.
Chris Prakoso wrote:
> public bool UpdateData(string tableName, Dictionary
> fields, List whereKeys)
> {
> ...
> using (SQLiteTransaction transaction =
> conn.BeginTransaction())
> {
> ...
>
Ok. Got it.
Now, if only I can get that multiple rows update working on my code, it
would be perfect.
Thanks a lot,
Chris
On Tue, Feb 9, 2016 at 12:07 PM, Clemens Ladisch wrote:
> Chris Prakoso wrote:
> > public bool UpdateData(string tableName,
> Dictionary fields, List whereKeys)
> >
Chris Prakoso wrote:
> I've been testing the performance of my Insert/Update using
> Transaction and without, and I found that it is quicker when I don't
> use it.
Show the code.
Regards,
Clemens
Chris Prakoso wrote:
> My question is whether anybody had successfully implemented multiple
> rows Insert/Update.
This is possible in SQL:
INSERT INTO MyTable(ID, Value)
VALUES (1, 'hello'),
(2, 'world');
UPDATE MyTable
SET Value = 'the same value'
WHERE ID IN (1, 2);
-- rather verbose;
I did a test using simple table, and entering the sql directly using SQLite
Administrator:
*insert into test (field1,field2) values (1,"two"),(2,"three")*
The error I got from the SQLite Administrator is:
*2/9/2016 11:29:40 AM: SQL Error: near ",": syntax error *
Thanks,
Chris
On Tue, Feb 9
Here they are:
public bool UpdateData(string tableName, Dictionary
fields, List whereKeys)
{
bool result = false;
string sql = "";
List fieldList = new List();
List whereKeyList = new List();
int rowsUpdated = 0;
Hi Clemens,
Thanks for your reply. I've tried to use raw SQL but it didn't work
either. Do you have any SQLite front-end that you use?
Regards,
Chris
On Tue, Feb 9, 2016 at 11:12 AM, Clemens Ladisch wrote:
> Chris Prakoso wrote:
>> My question is whether anybody had successfully implemented
Hi all,
I've been testing the performance of my Insert/Update using
Transaction and without, and I found that it is quicker when I don't
use it.
Anybody has an insight on this?
Thanks a lot,
Chris
Hi all,
I just joined the Mailing List yesterday, so apologise for any mistake
I am doing.
I'm a .NET (C#) Developer, and at the moment I'm coding a small app
with SQLite as the backend database.
My question is whether anybody had successfully implemented multiple
rows Insert/Update.
I've tried
On 2/9/16, Chris Prakoso wrote:
> Actually I've just done it now, in SQLiteSpeed, and it allowed me to use
> double-quote as delimiter successfully.
>
That is supported for backwards compatibility. I originally put in
support for double-quoted string literals to be compatible with MySQL
3.5. I
: Tuesday, February 9, 2016 7:56 AM
To: SQLite mailing list
Subject: Re: [sqlite] C# + SQLite - Update/Insert using Transaction is
slower than without.
Steven,
I don't use any back-end, the code I pasted here IS my back-end. I opted
for direct SQLite connection. So I don't use EF6 nor Linq.
On 2/9/16, Clemens Ladisch wrote:
> Chris Prakoso wrote:
>> insert into test (field1,field2) values (1,"two"),(2,"three")
>>
>> SQL Error: near ",": syntax error
>
> You might want to update to a tool that is not years out of date.
>
What Clemens means by this is that prior to SQLite 3.7.11 (2012
Chris,
What are you using in c# for SQLite back end? Ado.net? Linq. Let me know and
I can help you with bulk inserts.
Sent from my iPhone
> On Feb 9, 2016, at 6:13 AM, Chris Prakoso wrote:
>
> Ok. Got it.
> Now, if only I can get that multiple rows update working on my code, it
> would be
On 2/9/16, Chris Prakoso wrote:
> Hi Clemens,
>
> Thanks for your reply. I've tried to use raw SQL but it didn't work
> either.
Please show us the SQL that you did you.
> Do you have any SQLite front-end that you use?
>
The only supported "front-end" (if I correctly understand your
meaning) is
We encountered a doubly freed "C" pointer after calling sqlite3_exec
in my custom version of the Microsoft.Data.Sqlite C# method
SqliteCommand::ExecuteAnReader which does not call the parent C# class
method DbCommand::ExecuteReader which does not use a C# NativeMethod. The
C# NativeMethod clas
Hi,
can any one write some suggestion (I mean nuget package(s)) for creating
Windows Store App in C# with SQLite? In desktop apps I use simply
"System.Data.SQLite (x86/x64)" which I love because it allows me to write
SQL statements directly. Are there any good (ideally with examples or
documentatio
Good day,
I'm about to implement TDD for an existing c project that uses sqlite,
using CPPUnit. Sqlite would be a dependency from the point of view of
the routines making calls to it.
Is is typical to just write a link time stub to substitute commonly
used parts of the interface (exec, open, pre
On Mon, Mar 9, 2015 at 10:38 PM, Scott Robison
wrote:
> A co-worker who is working on a project is interested in finding out if
> there is an effective ORM for C++ / SQLite. I've not used one so I'm
> turning to the list to see if anyone has a recommendation.
>
> Note: He's okay using SQLite more
On Mon, Mar 9, 2015 at 3:25 PM, Simon Slavin wrote:
>
> On 9 Mar 2015, at 9:38pm, Scott Robison wrote:
>
>> A co-worker who is working on a project is interested in finding out if
>> there is an effective ORM for C++ / SQLite. I've not used one so I'm
>> turning to the list to see if anyone has a
Hi Scott,
Scott Robison writes:
> A co-worker who is working on a project is interested in finding out if
> there is an effective ORM for C++ / SQLite. I've not used one so I'm
> turning to the list to see if anyone has a recommendation.
Check out ODB:
http://codesynthesis.com/products/odb/
Qu
Hello,
I'm the main developer of QxOrm library and QxEntityEditor application :
http://www.qxorm.com/
Quickly : QxOrm library provides ORM feature to C++/Qt developers, and
QxEntityEditor provides a graphic way to design and manage the data model.
FYI, QxOrm provides also a set of other features
On 9 Mar 2015, at 9:38pm, Scott Robison wrote:
> A co-worker who is working on a project is interested in finding out if
> there is an effective ORM for C++ / SQLite. I've not used one so I'm
> turning to the list to see if anyone has a recommendation.
For those playing along at home, ORM == Ob
On 2015-03-09 3:25 PM, Simon Slavin wrote:
> On 9 Mar 2015, at 9:38pm, Scott Robison wrote:
>
>> A co-worker who is working on a project is interested in finding out if
>> there is an effective ORM for C++ / SQLite. I've not used one so I'm
>> turning to the list to see if anyone has a recommendat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/09/2015 02:38 PM, Scott Robison wrote:
> Note: He's okay using SQLite more or less directly if he needs to,
> as he recognizes the lack of reflection in C++ might lead to a less
> manageable ORM. Still, never hurts to ask.
Don't use an ORM unles
A co-worker who is working on a project is interested in finding out if
there is an effective ORM for C++ / SQLite. I've not used one so I'm
turning to the list to see if anyone has a recommendation.
Note: He's okay using SQLite more or less directly if he needs to, as he
recognizes the lack of re
1 - 100 of 545 matches
Mail list logo
