Re: [sqlite] confused getting started

A less LMGTFY-like response: First off, using SQLite does require that you become familiar with SQL, and a bunch of database ideas: normalization for good schema design, unit of work for good use of transactions, how to use indexes, others I'm sure I don't know about. But those ideas are not

Re: [sqlite] confused getting started

> On Mar 5, 2017, at 3:03 AM, NTrewartha T-Online > wrote: > > Any examples of a C,C++,C# or Python usage for sqllite.? Have you tried searching? I entered “sqlite c example” and “sqlite python example” into Google and got some useful-looking links in the top few

[sqlite] SQLite Recursive Common Table Expression suggestion

I’ve seen many amusing examples of using Common Table Expressions to solve Sudoko puzzles. Has anyone tried using one to suggest the best next move for Minesweeper ? The idea would be to supply a grid with the solution so far in it, and supply the total number of mines, and have SQLite

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

Yes there is. Every SQL statement is performing a COMMIT since you have not explicitly delimited your transactions. > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Yuri > Sent: Sunday, 5 March, 2017 08:06 > To: SQLite

Re: [sqlite] confused getting started

> I'm not a computer novice, but also not a nerd/geek. > Been using PCs since the mid 1980s and have used dBase III+ and Approach > previously. > > I can't seem to grasp what I need to download / install to use SQLite? > > Can someone guide me through the process? Looking to use it with >

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

Simon Slavin wrote: > You’re going to have to wait for the developer team to fix the bug, or change the row IDs so that they are unique in the entire database. Regards, Clemens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 03/05/2017 09:49, Simon Slavin wrote: On 5 Mar 2017, at 4:28pm, Yuri wrote: So, to be clear, blob writes can only be used when no other statements are executed in the middle? Because the latest testcase only changes the other table, not the table where the blob is. I’m

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 5 Mar 2017, at 4:28pm, Yuri wrote: > So, to be clear, blob writes can only be used when no other statements are > executed in the middle? Because the latest testcase only changes the other > table, not the table where the blob is. I’m glad to see that someone else has

Re: [sqlite] BUG: blob handles are invalidated in too many tables (was: Can sqlite3_blob_write be done through SQL?)

Yuri wrote: > even updates to other tables invalidate the blob handle. Please see the > example below. This is a bug. Apparently, it was introduced in commit f17ef37897da9bca, where the function invalidateIncrblobCursors() forgets to check the pgnoRoot parameter, which means that blob cursors

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 03/05/2017 08:22, Simon Slavin wrote: Yes, as we already established it’s because you changed the values of other columns in the row. I think you’re using SQLite’s blob calls in an unexpected way. They’re not meant to be used as an ongoing editor. Adding the kind of support you’ve asked

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 5 Mar 2017, at 4:11pm, Yuri wrote: > On 03/05/2017 07:20, Simon Slavin wrote: >> If you want to delay the ending of the transaction you have to put the BEGIN >> in before it, and then you must put the COMMIT in after it or it won’t be >> committed. > > The second blob

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 03/05/2017 07:20, Simon Slavin wrote: If you want to delay the ending of the transaction you have to put the BEGIN in before it, and then you must put the COMMIT in after it or it won’t be committed. The second blob write fails even after adding BEGIN before sqlite3_blob_open and COMMIT

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 5 Mar 2017, at 3:06pm, Yuri wrote: > On 03/05/2017 03:48, Keith Medcalf wrote: >> Perhaps because you are committing the transaction? > > There is no COMMIT statement there. If you try to execute a command without putting it in a transaction (i.e. using BEGIN) then SQLite

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 03/05/2017 03:48, Keith Medcalf wrote: Perhaps because you are committing the transaction? There is no COMMIT statement there. Yuri ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

Would it be possible for you to write the other columns just once, after all the blob has been inserted? On Mar 4, 2017 4:34 PM, "Yuri" wrote: > On 03/04/2017 01:22, Clemens Ladisch wrote: > >> Do you have a concrete example for such a statement? >> > > > Yes. I need to

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

Perhaps because you are committing the transaction? > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Yuri > Sent: Sunday, 5 March, 2017 02:27 > To: SQLite mailing list > Subject: Re: [sqlite] Can sqlite3_blob_write be done

Re: [sqlite] confused getting started

I too am new to DB's and Sqllite. I have downloaded the binaries for win 10 and there is a dll and def file. I clicked on the def file hoping this would integrate the dll into VS 2015 community, but all what happened was that the def file get listed. and I cannot seem to find an import def

Re: [sqlite] confused getting started

Besides the need to include RDBMS engine inside your application, and manage it from the code. You have a standalone application (sqlite3.exe) who let manage your databese from the CLI (command line interpreter) of your system, and play whit the majority options who SQLite offer. HTH. --

Re: [sqlite] Can sqlite3_blob_write be done through SQL?

On 03/04/2017 23:08, Clemens Ladisch wrote: I think you can work around these problems by moving the blob value into a separate table. I thought so too. However, even updates to other tables invalidate the blob handle. Please see the example below. Variable breakMe breaks the second