Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Thank you so much for your reply. I sill surely look at the options you gave me. I ask because I run into errors a lot, using the System.Data.SQLite libraries. It easily crashes, trhows exceptions and similar issues... I found out that it matters which target platform is selected... So t

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Why not just add the amalgmation to your source then do C function calss. I do not get why you would use a dll when you can just link in the amalgamtion into your program and have full access to the latest version. - Scott Doctor [email protected] ---

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

On 19 Oct 2018, at 2:23am, Larry Brasfield wrote: > Jordy Deweer asks about alternatives to System.Data.SQLite because: “I run > into errors a lot, using the System.Data.SQLite libraries. It easily crashes, > trhows exceptions and similar issues...”. System.Data.SQLite is generally considered

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Jordy Deweer asks about alternatives to System.Data.SQLite because: “I run into errors a lot, using the System.Data.SQLite libraries. It easily crashes, trhows exceptions and similar issues...”. I’ve used that module for several projects and found it to be generally robust. I have also seen tha

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

What target platforms have you found on which it is unreliable? I haven't had problems on Win7, but I haven't used it all that much. RobR On Thu, Oct 18, 2018 at 2:57 PM Jordy Deweer wrote: > Larry Brasfield wrote: "Jordy Deweer asks: “Is there a way to use a > SQLite database in a C# project,

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Why don't you want to use System.Data.SQLite? On Thu, Oct 18, 2018 at 11:04 AM Jordy Deweer wrote: > Dear all > > I am new to this group and this is my first question here. > > My question is as follows: > > Is there a way to use a SQLite database in a C# project, without > installing / configur

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Larry Brasfield wrote: "Jordy Deweer asks: “Is there a way to use a SQLite database in a C# project, without installing / configuring / depending on the System.Data.SQLite libraries? I really hope there is.” If you do a web search for the combination of terms “SQLite”, “C#” and “library”, you

Re: [sqlite] Using SQLite in C# without System.Data.SQLite

Jordy Deweer asks: “Is there a way to use a SQLite database in a C# project, without installing / configuring / depending on the System.Data.SQLite libraries? I really hope there is.” If you do a web search for the combination of terms “SQLite”, “C#” and “library”, you will find several alter

[sqlite] Using SQLite in C# without System.Data.SQLite

Dear all I am new to this group and this is my first question here. My question is as follows: Is there a way to use a SQLite database in a C# project, without installing / configuring / depending on the System.Data.SQLite libraries? I really hope there is. Thank you so much in advance for

Re: [sqlite] Using Sqlite nuget package in a .Net test assembly

Greg Pagendam-Turner wrote: > > Using Sqlite nugget package version 3.13 > Are you using the full (desktop) .NET Framework? If so, the NuGet package you probably want is probably "System.Data.SQLite". -- Joe Mistachkin ___ sqlite-users mailing list s

[sqlite] Using Sqlite nuget package in a .Net test assembly

I’m trying to use the Sqlite nugget package in a test assembly. I’m getting the following error in my app when running a query in code: {System.DllNotFoundException: Unable to load DLL 'sqlite3': This operation is only valid in the context of an app container. (Exception from HRESULT: 0x8007109

Re: [sqlite] Using SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

I am drawing from parallel functionality in the existing API.Roughly, the API sqlite3_buffer_numeric_type() would simply be the buffer input version of the existing API sqlite3_value_numeric_type(). But instead of operating on a sqlite3_value parameter, it would read from a pzBuffer parameter

Re: [sqlite] Using SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

On 1/23/18, petern wrote: > Any chance of publishing a modest but hardened "int > sqlite3_numeric_buffer_type(const char*pBuffer,int length,int encoding)" > API that extensions can use? I'm not sure what "sqlite3_numeric_buffer_type()" is suppose to do? -- D. Richard Hipp [email protected] ___

Re: [sqlite] Using SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

Any chance of publishing a modest but hardened "int sqlite3_numeric_buffer_type(const char*pBuffer,int length,int encoding)" API that extensions can use? On Tue, Jan 23, 2018 at 4:43 PM, Richard Hipp wrote: > On 1/23/18, petern wrote: > > What is the fastest forward compatible way to gain use o

Re: [sqlite] Using SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

On 1/23/18, petern wrote: > What is the fastest forward compatible way to gain use of the internal > buffer value recognizers such as "SQLITE_PRIVATE int sqlite3AtoF()" in > external C programs? > There is no forwards-compatible way to do that. We reserve the right to change the design and/or be

[sqlite] Using SQLite internal recognizers eg: SQLITE_PRIVATE int sqlite3AtoF()

What is the fastest forward compatible way to gain use of the internal buffer value recognizers such as "SQLITE_PRIVATE int sqlite3AtoF()" in external C programs? The goal is to efficiently compute exactly how SQLite would taxonomically classify {numeric,float,integer,...} a buffer string value if

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Clyde Eisenbeis schrieb am 27.01.2017 um 18:51: I tried this: - System.Data.SQLite.SQLiteCommand sqliteCmd = sqliteConnection.CreateCommand()); sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%' ||

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I agree completely! I am grateful that SQLite exists. It would be good if users could post solutions, similar to forums. This relieves the burden on the benefactors ... and would, quite likely, attract more users. On Fri, Jan 27, 2017 at 2:38 PM, Warren Young wrote: > On Jan 27, 2017, at 1:09 P

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 27, 2017, at 1:09 PM, Clyde Eisenbeis wrote: > > The SQLite websites would be more useful with examples. Certainly. No question. The thing is, I think most of us are primarily grateful that SQLite *exists* and that it works as well as it does. Given a choice of where our benefactors

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Hi Simon Slavin, This works! Almost identical to the approach used for OLE DB example described in the 26 Jan, 11:45am email attachment. The end result code for SQLite is attached. - Hi James K. Lowden, Examples are a source I've used since 1968 (Fortran using key p

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Thu, 26 Jan 2017 11:45:41 -0600 Clyde Eisenbeis wrote: > Usually I look at examples, and extract the relevant info. In the Age of Google, that has become a popular technique. But it's not a good way to learn anything. I wonder, though: how do you know what the "relevant info" is? How do yo

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On 27 Jan 2017, at 5:59pm, Clyde Eisenbeis wrote: > sqliteCmd.CommandText = SELECT fstPriority, fstInfo, fstDateCreated, > fstDateModified, fiKeyID FROM MemoPadTable WHERE fstInfo LIKE '%' || > ?1 || '%'" > > liststLikeFieldValue[0] = "bruce" Please try the following: Change ?1 to @param1. C

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

sqliteCmd.CommandText = SELECT fstPriority, fstInfo, fstDateCreated, fstDateModified, fiKeyID FROM MemoPadTable WHERE fstInfo LIKE '%' || ?1 || '%'" liststLikeFieldValue[0] = "bruce" On Fri, Jan 27, 2017 at 11:55 AM, Simon Slavin wrote: > > On 27 Jan 2017, at 5:51pm, Clyde Eisenbeis wrote: >

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On 27 Jan 2017, at 5:51pm, Clyde Eisenbeis wrote: > System.Data.SQLite.SQLiteCommand sqliteCmd = > sqliteConnection.CreateCommand()); > > sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + > stTableName + " WHERE " + stLikeFieldName + " LIKE '%' || ?1 || '%'"; > > sqliteCmd.Paramet

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Thanks. Was able to open the .chm file. I tried this: - System.Data.SQLite.SQLiteCommand sqliteCmd = sqliteConnection.CreateCommand()); sqliteCmd.CommandText = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%' || ?1 || '%'"

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Clyde Eisenbeis schrieb am 26.01.2017 um 18:45: It appears that sqlite3 is not part of System.Data.SQLite. Aaah! Now we get somewhere! You should have told us from the beginning that you are using SQLite through the .NET/MONO Wrapper. All the mentioning of sqlite3_bind_* and the like refer to

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Clyde Eisenbeis wrote: > > I can't read CHM docs. > I'm somewhat curious about that. Anyhow, there are alternatives: 1. IntelliSense in the Visual Studio IDE (this requires the XML file "System.Data.SQLite.xml", which should have been included with your DLL).

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I can't read CHM docs. I'd appreciate some example code which uses "sqlite3_bind_". Thanks! On Thu, Jan 26, 2017 at 12:02 PM, Joe Mistachkin wrote: > > Clyde Eisenbeis wrote: >> >> It appears that sqlite3 is not part of System.Data.SQLite. >> > > Actually, it is. However, the managed component

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Clyde Eisenbeis wrote: > > It appears that sqlite3 is not part of System.Data.SQLite. > Actually, it is. However, the managed components provide a "wrapper" around the core library functionality. The documentation, in Windows CHM format, is available here: https://urn.to/r/sds_docs T

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Usually I look at examples, and extract the relevant info. After I have extracted relevant info, I create functions that are universally valid for different programs ... see attachment for one example. In this case, I have attempted to create code using what has been described so far. However, w

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On 2017/01/26 5:46 PM, Clyde Eisenbeis wrote: To answer a previous question, here is an example of stCmdString contents: stCmdString = "SELECT fstPriority, fstInfo, fiKeyID FROM PadTable WHERE fstInfo LIKE '%macro%'" This works. Yes, and so it should, but this is what you think it /shou

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 26, 2017, at 8:40 AM, Clyde Eisenbeis wrote: > > When I tried entering: > > sqlite3_bind_ > > the compiler starts complaining. What I wrote was "sqlite3_bind_*()” which you were expected to understand as a reference to the 15 functions beginning with “sqlite3_bind_” listed on the fir

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On 26 Jan 2017, at 3:04pm, Clyde Eisenbeis wrote: > string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName > + " WHERE " + stLikeFieldName + " LIKE ('%' || " + > liststLikeFieldValue[0] + " || '%')"; Still looks like there would be spaces missing from that. After SELECT and bef

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

am Regards Andy -Original Message- From: sqlite-users [mailto:[email protected]] On Behalf Of Clyde Eisenbeis Sent: Thu 26 January 2017 15:41 To: SQLite mailing list Subject: Re: [sqlite] Using SQLite, how can I search for chars that include a ', simila

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

tring += " AND fstInfo LIKE ('%' || ?1 || '%') AND fstInfo >>> LIKE ('%' || ?2 || '%')" >>> >>> Then use the sqlite3_bind_* () calls to replace the ?n markers with the " >>> liststLikeFieldValue" strings. &

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

tInfo >> LIKE ('%' || ?2 || '%')" >> >> Then use the sqlite3_bind_* () calls to replace the ?n markers with the " >> liststLikeFieldValue" strings. >> >> HTH >> >> Andy >> >> -Original Message-

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

markers with the " > liststLikeFieldValue" strings. > > HTH > > Andy > > -Original Message- > From: sqlite-users [mailto:[email protected]] On > Behalf Of Clyde Eisenbeis > Sent: Thu 26 January 2017 15:04 > To: SQLite mailing

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

n Behalf Of Clyde Eisenbeis Sent: Thu 26 January 2017 15:04 To: SQLite mailing list Subject: Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters? I've also tried: string stCmdString = "SELECT" + stFieldNames + "FROM &quo

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Re-reading the previous emails, it appears I also need to use sqlite3_bind_*(). On Thu, Jan 26, 2017 at 9:04 AM, Clyde Eisenbeis wrote: > I've also tried: > > string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName > + " WHERE " + stLikeFieldName + " LIKE ('%' || " + > liststLikeFi

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On 2017/01/26 5:04 PM, Clyde Eisenbeis wrote: I've also tried: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE ('%' || " + liststLikeFieldValue[0] + " || '%')"; which does not work. Could you kindly simply output the resulting s

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I've also tried: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE ('%' || " + liststLikeFieldValue[0] + " || '%')"; which does not work. On Thu, Jan 26, 2017 at 8:14 AM, heribert wrote: > There are some missing spaces i think: > > str

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

There are some missing spaces i think: string stCmdString = "SELECT " + stFieldNames + " FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%'||" + liststLikeFieldValue[0] + "||'%'"; Am 26.01.17 um 15:04 schrieb Clyde Eisenbeis: I tried replacing this: string stCmdString = "SELECT

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

There are some missing spaces i think: string stCmdString = "SELECT " + stFieldNames + " FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%'||" + liststLikeFieldValue[0] + "||'%'"; Am 26.01.17 um 15:04 schrieb Clyde Eisenbeis: I tried replacing this: string stCmdString = "SELEC

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I tried replacing this: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%" + liststLikeFieldValue[0] + "%'"; with this: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%'

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On 1/25/17, Warren Young wrote: > > stCmdString += " AND ‘%?1%’ LIKE ‘%?2%’”; > > Then use the sqlite3_bind_*() calls to insert parameters 1 and 2 into the > string. Not quite. You cannot have parameters embedded in the middle of strings. The whole string is replaced by a parameter. stCmdSt

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 25, 2017, at 8:50 AM, Clyde Eisenbeis wrote: > > Are there code examples similar to the following (OLE DB)? Code examples? Maybe, but the second link I gave you is pretty clear. The bits you want are even in bold text. > stCmdString += " AND " + stLikeFieldName + " LIKE '%" + > listst

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

I should clarify ... I am currently using: string stCmdString = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE '%" + liststLikeFieldValue[0] + "%'"; for (int iii = 1; iii < liststLikeFieldValue.Count; iii++) stCmdString += " AND " + stLikeFiel

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Thanks for the prompt response! Are there code examples similar to the following (OLE DB)? oledbCmd.CommandText = "SELECT" + stFieldNames + "FROM " + stTableName + " WHERE " + stLikeFieldName + " LIKE @p0"; for (int iii = 1; iii < liststLikeFieldValue.Count; iii++) oledbCmd.CommandT

Re: [sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

On Jan 25, 2017, at 8:33 AM, Clyde Eisenbeis wrote: > > The use of .Parameters in OLE DB fixes this problem. Is there an > equivalent for SQLite? You’re looking for prepared statements with parameters: https://sqlite.org/c3ref/stmt.html https://sqlite.org/lang_expr.html#varparam ___

[sqlite] Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters?

Using SQLite, how can I search for chars that include a ', similar to OLE DB .Parameters? This works to find bruce and baseball: string stCmdString = "SELECT fstInfo FROM PadTable WHERE fstInfo LIKE '%bruce%' AND fstInfo LIKE '%baseball%'" Not sure how to find bruce's and baseball. I know i

Re: [sqlite] using sqlite extensions within Ruby

On 8 December 2016 at 23:23, Don V Nielsen wrote: > Like you, I like ruby and working with sqlite via sqlite3 gem. So you have > recompiled sqlite3 with the sessions extension. Correct? And this modified > sqlite3 is the nearest sqlite3 available in your execution path. Correct? > I'm not well v

Re: [sqlite] using sqlite extensions within Ruby

Documentation update to https://sqlite.org/sessionintro.html: "The session extension provide a mechanism". Should that read, "The session extension provides a mechanism"? dvn On Thu, Dec 8, 2016 at 9:23 AM, Don V Nielsen wrote: > Like you, I like ruby and working with sqlite via sqlite3 gem. S

Re: [sqlite] using sqlite extensions within Ruby

Like you, I like ruby and working with sqlite via sqlite3 gem. So you have recompiled sqlite3 with the sessions extension. Correct? And this modified sqlite3 is the nearest sqlite3 available in your execution path. Correct? The sqlite_ruby library is an interface to sqlite3...the base model. Grante

[sqlite] using sqlite extensions within Ruby

I don't usually see questions about using SQLite3 from Ruby here, so I hope this is not out of place. Ruby is my normal programming language of choice nowadays, and I've been very happy with the sqlite3 ruby gem to use SQLite3 within my programs. I'd now like to make use of the SQLite3 session ex

Re: [sqlite] Using SQLite without SQL.

On 26 Jul 2016, at 10:41pm, John Found wrote: > Well, not as a "demonstration", but for regular use. > I am writing all my software in assembly language, > so such aspiration is some kind of natural for me. :) > > Read my answer to DRH for more details on my motives. Okay. Understood. You'r

Re: [sqlite] Using SQLite without SQL.

On Tue, 26 Jul 2016 21:52:26 +0100 Simon Slavin wrote: > > On 26 Jul 2016, at 9:29pm, John Found wrote: > > > Is it possible to use SQLite, making queries directly in the internal > > virtual machine language, instead of SQL? > > > > Or in another variant, compile the queries in design time,

Re: [sqlite] Using SQLite without SQL.

On Tue, 26 Jul 2016 16:40:07 -0400 Richard Hipp wrote: > On 7/26/16, John Found wrote: > > Is it possible to use SQLite, making queries directly in the internal > > virtual machine language, instead of SQL? > > No. Why do you want to do this. The SQL language is the most > compelling feature

Re: [sqlite] Using SQLite without SQL.

On 26 Jul 2016, at 9:29pm, John Found wrote: > Is it possible to use SQLite, making queries directly in the internal virtual > machine language, instead of SQL? > > Or in another variant, compile the queries in design time, manually optimize > them (if needed) and then store and call in the p

Re: [sqlite] Using SQLite without SQL.

On 7/26/16, John Found wrote: > Is it possible to use SQLite, making queries directly in the internal > virtual machine language, instead of SQL? No. Why do you want to do this. The SQL language is the most compelling feature of SQLite. Why abandon it? > > Or in another variant, compile the

[sqlite] Using SQLite without SQL.

Is it possible to use SQLite, making queries directly in the internal virtual machine language, instead of SQL? Or in another variant, compile the queries in design time, manually optimize them (if needed) and then store and call in the program in compiled form? -- http://fresh.flatassembler.

[sqlite] Using SQLite for storing photo's

I would definitely store the pictures in separate files. The main reason is compatibility. If you store them as blobs in sqlite, you have to extract them first to view or edit them in a another program.i Are you sure you've covered all your use cases with your program? Ketil On 14 Apr 2016 7:37 p.

[sqlite] Using SQLite for storing photo's

On 2016/04/14 10:18 PM, Cecil Westerhof wrote: > 2016-04-14 22:07 GMT+02:00 Clemens Ladisch : > >> Cecil Westerhof wrote: >>> what is the best way to make a backup? >> With the backup API: . >> (Also available as .backup in the shell.) >> > ?I should be more pre

[sqlite] Using SQLite for storing photo's

2016-04-14 22:07 GMT+02:00 Clemens Ladisch : > Cecil Westerhof wrote: > > what is the best way to make a backup? > > With the backup API: . > (Also available as .backup in the shell.) > ?I should be more precise in my communication. :'-( I prefer to make my bac

[sqlite] Using SQLite for storing photo's

2016-04-14 21:37 GMT+02:00 Simon Slavin : > > On 14 Apr 2016, at 8:10pm, Cecil Westerhof wrote: > > > ?I would like to have everything in one file. > > From previous discussions on this list, what you want to do will work > fine. Of course you should make sure your operating system is able to de

[sqlite] Using SQLite for storing photo's

Hello Cecil, I have multiple 30-40 GB Sqlite DB's which contain images as blobs. I back them up by copying them to my backup drive. Unless your application runs 24x7, I see no reason to do anything complicated with the backup. My image blobs are in a table which contains an imag

[sqlite] Using SQLite for storing photo's

Cecil Westerhof wrote: > what is the best way to make a backup? With the backup API: . (Also available as .backup in the shell.) Regards, Clemens

[sqlite] Using SQLite for storing photo's

2016-04-14 19:41 GMT+02:00 Simon Slavin : > > On 14 Apr 2016, at 6:37pm, Cecil Westerhof wrote: > > > I am thinking about storing my photo's in SQLite. > > Doesn't answer your question, but you should definitely read > > > ?I would like to have

[sqlite] Using SQLite for storing photo's

On 14 Apr 2016, at 8:10pm, Cecil Westerhof wrote: > ?I would like to have everything in one file.

[sqlite] Using SQLite for storing photo's

I am thinking about storing my photo's in SQLite. This has to be done in a blob of-course, but I was wondering if there are any caveats, or if anyone has helpful tips. One thing I was wondering: what is the best way to make a backup? I would think a normal dump is not very handy. It would probably

[sqlite] Using SQLite for storing photo's

On 14 Apr 2016, at 6:37pm, Cecil Westerhof wrote: > I am thinking about storing my photo's in SQLite. Doesn't answer your question, but you should definitely read Simon.

[sqlite] Using SQLite in a multi-threaded environment

Dear all, I have a (probably) very basic question regarding the usage of SQLite in an multithreaded environment. I use a compiled version of SQLite with SQLITE_THREADSAFE 0. Inside my application exists one thread that is the exclusive user of the SQLite interface. So from my point of view I am u

[sqlite] Using SQLite as a column-store database?

Would it be realistic to pretend to use SQLite as a column-store database by leveraging ALTER TABLE ... ADD COLUMN massively and to expect better performance? Suppose that instead of defining a table like CREATE TABLE (key, c1, c2, ... cn) I defined it as CREATE TABLE (key) followed by n-times

[sqlite] Using SQLite as a column-store database?

On 29 Jul 2015, at 8:28pm, Jean Chevalier wrote: > Would it be realistic to pretend to use SQLite as a column-store database by > leveraging ALTER TABLE ... ADD COLUMN massively and to expect better > performance? Sorry. No. The data for each row is stored together. > Suppose that instead

[sqlite] Using SQLite with WP8.1

Hi SQLite Users, I am new to SQLite and tried using SQLite to my Windows phone 8.1 App. I couldn't find any useful samples online which can be used with Windows phone 8.1. Requesting to share any useful samples that can help my application. Here are the sample requests I am looking for: 1.

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

Hello Hayden, If I was doing this, I'd use a single database as the core then periodically from within the app, write out a new database with the last 5 minutes worth of data. Then let them run off the copy while you maintain a master copy of the DB. In that way this splitting and multiple DB thin

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

On 3 May 2014, at 2:35pm, Hayden Livingston wrote: > That's clever. I'm thinking how I'll go about this .. essentially the > filename is devised by time splits. I could do what you're saying but then > I can't move the file. Basically, the good part is that our warehousing > department (which is

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

Ok. But I'm wondering how GROUPBY and stuff will work? On Sat, May 3, 2014 at 7:13 AM, Petite Abeille wrote: > > On May 3, 2014, at 3:40 PM, Hayden Livingston > wrote: > > > This looks promising. I sooo wish it didn't have a limit to number of > > databases. > > 10 by default if I recall proper

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

On May 3, 2014, at 3:40 PM, Hayden Livingston wrote: > This looks promising. I sooo wish it didn't have a limit to number of > databases. 10 by default if I recall properly. Can be perhaps be increased to 62 at most: http://www.sqlite.org/limits.html > But I think I could reasonably do somet

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

This looks promising. I sooo wish it didn't have a limit to number of databases. But I think I could reasonably do something like coalesce the databases into a new database once every 2 hours. I also need to generate some code to figure out how to address the tables which I guess means I'll have to

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

That's clever. I'm thinking how I'll go about this .. essentially the filename is devised by time splits. I could do what you're saying but then I can't move the file. Basically, the good part is that our warehousing department (which is what this is used for) can look at order inventories every 5

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

On May 3, 2014, at 2:59 PM, Hayden Livingston wrote: > Thoughts? Take a look at ‘ATTACH’, it might help: http://www.sqlite.org/lang_attach.html ___ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sql

Re: [sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

On 3 May 2014, at 1:59pm, Hayden Livingston wrote: > My workload is quite straightforward, I have a multi-threaded application > that logs to this file but from within any single thread at any given time. > So from SQLite's perspective only one person will be writing to this > database and nobod

[sqlite] Using SQLite for write only workload, splitting databases into smaller files, but need to query it as a whole

I have a situation where I store a data in a text file with tabs, and it's becoming really quite unwieldy to use this. My workload is quite straightforward, I have a multi-threaded application that logs to this file but from within any single thread at any given time. So from SQLite's perspective

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

Yes, of course. Sorry. It would seem I shouldn't answer email that early in the morning on a day off. -j On Dec 31, 2013, at 7:48 AM, Stephan Beal wrote: > On Tue, Dec 31, 2013 at 2:33 PM, Jay Kreibich wrote: > >> Using SQLite covers up to the very last 2.6 version of SQLite. The book

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

Thank you, Jay! Bob On 12/31/13, 8:33 AM, Jay Kreibich wrote: Using SQLite covers up to the very last 2.6 version of SQLite. The book went to press about the same time that SQLite 2.7.0 came out. As such, the book does not cover WAL or any of the more resent features. The book only covers

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

On Tue, Dec 31, 2013 at 2:33 PM, Jay Kreibich wrote: > Using SQLite covers up to the very last 2.6 version of SQLite. The book > went to press about the same time that SQLite 2.7.0 came out. Certainly you intended 3.x instead of 2.x? To quote the preface: "The first edition of this book cov

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

Using SQLite covers up to the very last 2.6 version of SQLite. The book went to press about the same time that SQLite 2.7.0 came out. As such, the book does not cover WAL or any of the more resent features. The book only covers the C/C++ APIs, since everything else is based off those. The

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

Thank you, I will look more closely at the node-sqlite3 documentation. Bob On 12/31/13, 12:25 AM, Navaneeth K N wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hello, On 12/31/13 8:18 AM, Bob Cochran wrote: I'm working on a tough project that requires me to use Node.js and SQLite. I'm

Re: [sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hello, On 12/31/13 8:18 AM, Bob Cochran wrote: > I'm working on a tough project that requires me to use Node.js and > SQLite. I'm building a database with SQLite version 3.8.2. > > My question is, would purchasing the book "Using Sqlite" by Jay Kre

[sqlite] Using SQLite by Jay Kreibich (2010 paperback edition)

I'm working on a tough project that requires me to use Node.js and SQLite. I'm building a database with SQLite version 3.8.2. My question is, would purchasing the book "Using Sqlite" by Jay Kreibich still be mostly pertinent to SQLite 3.8.x features? Would it be helpful in the context how Node

Re: [sqlite] Using SQLITE to build database from tab delimited file

On 26 Jul 2013, at 9:25am, Rob Slater wrote: > I have an iPad app that uses several (4) different SQLITE databases and I > currently build these databases using Mozilla Firefox SQLite Manager utility > (on a Mac). The databases are simple (single table) with a number of rows, > and are created

Re: [sqlite] Using SQLITE to build database from tab delimited file

You can write your sql commands in a txt file (say mycmd.txt), and then sqlite3 your.databasefile < mycmd.txt Or I have a simple API that lets you import / export csv (not necessarly CSV inderd, any kind of delimited file) files into SQLite, so you can do it via your own C/C++ application as

[sqlite] Using SQLITE to build database from tab delimited file

I have an iPad app that uses several (4) different SQLITE databases and I currently build these databases using Mozilla Firefox SQLite Manager utility (on a Mac). The databases are simple (single table) with a number of rows, and are created from a text file with tab delimited fields. This all wo

[sqlite] Using sqlite as a parallel computation benchmark?

Hi folks, I'm looking into using sqlite for benchmarking performance of a glibc feature based on hardware based transactional memory that is a new feature of new Intel and Ibm (and other) cpus. The glibc feature is described here: https://lwn.net/Articles/534758/ In short, glibc attempts automat

Re: [sqlite] Using SQLite on a networkshare

It boils down to that SQLite is working as intended as it can only rely on what the OS feeds it. As stated, the developers of SQLite are not going to be looking at network sharing as the responsibility of file locking is on the OS, not SQLite. Network sharing is tricky, and it "seems" seamless wh

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 07 Jan 2013 20:09:02 +0700 Dan Kennedy wrote: > On 01/07/2013 03:22 PM, Eduardo Morras wrote: > > > > Hi, I use sqlite in some of my projects. In one it follows a > > parent/multichild model (multifork). The database is managed by the > > parent, open close backups etc, opened before the

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 7 Jan 2013 11:11:01 +0100 Pavlos Christoforou wrote: > Hello Eduardo, > > We do (succesfully) use sqlite in a similar manner as you describe in your > post but the code ensures the DB is opened in each individual child process > *after* a child is successfully forked. It is not a good id

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 7 Jan 2013 12:27:54 + Simon Slavin wrote: > > On 7 Jan 2013, at 8:22am, Eduardo Morras wrote: > > > The app works but, is anyone working with sqlite this way? Any advice to > > avoid db corrupts, deadlocks, whatever? > > Read this page: > >

Re: [sqlite] Using sqlite in multi fork() without threads

On Mon, 07 Jan 2013 05:43:50 -0800 Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 07/01/13 00:22, Eduardo Morras wrote: > > opened before the fork, and after it the childs use the database > connection. I don't want to corrupt the database, > > https://sqlite.org/fa

Re: [sqlite] Using SQLite on a networkshare

Hi JCHD, Thnx for your notice. Of course I checked the AutoIt forum first. There is indeed some discussion on this topic, but no solution that worked for me. I also checked the solution by atensoft (actually I used this for a while, but couldn't find out how to properly write a wrapper for it in s

  1   2   3   >