Re: [sqlite] (no subject)

On Mon, Jul 30, 2018 at 7:09 PM J Decker wrote: > > > On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > >> >> >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", >> >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", >> >"SQLITE_DEFAULT_FOREIGN_KEYS=1" >> >> >Is there something

Re: [sqlite] (no subject)

On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > > >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", > >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", > >"SQLITE_DEFAULT_FOREIGN_KEYS=1" > > >Is there something about the combination of options I've used? > > Do you get

Re: [sqlite] (no subject)

>"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", >"SQLITE_DEFAULT_FOREIGN_KEYS=1" >Is there something about the combination of options I've used? Do you get different results when using different options? (of course, if you turn

Re: [sqlite] (no subject)

On 2018/06/19 9:55 PM, Stephen Chrzanowski wrote: *sigh* I wish I had this kind of homework back in the day.. Well, I say you could just do the homework of those who do post homework questions here That way it technically IS your homework, and as such, your wish would have come

Re: [sqlite] (no subject)

*sigh* I wish I had this kind of homework back in the day.. On Tue, Jun 19, 2018 at 3:22 PM, Simon Slavin wrote: > On 19 Jun 2018, at 8:15pm, Vicente minguez gabarda > wrote: > > > hello I need a simple example of relationship between table, > > I would like to be able to visualize the

Re: [sqlite] (no subject)

On 19 Jun 2018, at 8:15pm, Vicente minguez gabarda wrote: > hello I need a simple example of relationship between table, > I would like to be able to visualize the relationship code between tables > and then reuse it. One day, just for a laugh, we should

Re: [sqlite] (no subject)

Thanks I needed a Laugh, try clicking on one of the links at the bottom of your emails and unsubscribe. *Jim Dodgen* On Fri, Oct 6, 2017 at 7:41 PM, cindy estepp wrote: > stop emailing me i do not know you > ___ >

Re: [sqlite] (no subject)

This seems to be exactly what I'm looking for. Thanks! --Ron Op ma 17 jul. 2017 om 20:23 schreef Jens Alfke > > > On Jul 17, 2017, at 11:08 AM, Ron wrote: > > > > I am looking into the possibility of putting the changes in SQLite > database > > into

Re: [sqlite] (no subject)

> On Jul 17, 2017, at 11:08 AM, Ron wrote: > > I am looking into the possibility of putting the changes in SQLite database > into kafka, similar to this: > https://www.confluent.io/blog/bottled-water-real-time-integration-of-postgresql-and-kafka/ > >

Re: [sqlite] (no subject)

I’d look at creating a virtual table that can be setup to “shadow” any existing table. Basically pass-through any read or write operations, possibly shunting off writes. This has the advantage of not requiring any kind of patching or modifications to the core library. Sounds a lot simpler

Re: [sqlite] (no subject)

On 13 Oct 2014, at 12:06pm, Rohit Kaushal wrote: > please unregister me Only you can stop forest fires. See the link at the bottom of every post to this list. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] (no subject)

On Tue, 1/28/14, Igor Tandetnik <i...@tandetnik.org> wrote: Subject: Re: [sqlite] (no subject) To: sqlite-users@sqlite.org Date: Tuesday, January 28, 2014, 2:41 PM On 1/28/2014 2:26 PM, David Bicking wrote: > I have two tables:

Re: [sqlite] (no subject)

On 1/28/2014 2:26 PM, David Bicking wrote: I have two tables: ARB KEY (PRIMARY KEY) ASSIGN (NOT NECESSARILY UNIQUE) DMC KEY (NOT UNIQUE) ASSIGN (NOT UNIQUE) VALUE I need to report all the records from ARB, and sum up the values if the keys match OR if the keys don't match, then sum

Re: [sqlite] (no subject)

That worked thanks Igor. On 16 May 2013 15:33, Paul Sanderson wrote: > Rob yes thats correct > > Igor - thanks I'll give that a go > > > > On 16 May 2013 14:51, Rob Richardson wrote: > >> First idea: include a subject line. >> >> I'm not

Re: [sqlite] (no subject)

Rob yes thats correct Igor - thanks I'll give that a go On 16 May 2013 14:51, Rob Richardson wrote: > First idea: include a subject line. > > I'm not 100% clear on your message. You said: > " For those entries in table1 where there is a null in t2..." > I'm

Re: [sqlite] (no subject)

First idea: include a subject line. I'm not 100% clear on your message. You said: " For those entries in table1 where there is a null in t2..." I'm guessing you wanted to say: " For those entries in table1 where there is a null in t1..." Is that right? RobR

Re: [sqlite] (no subject)

On 5/16/2013 9:29 AM, Paul Sanderson wrote: I have two tables of the form create table1 (id1 int, t1 text) create table2 (id2 int unique, t2 text) For those entries in table1 where there is a null in t2 I want to copy the corresponding entry from table2 update table1 set t1=(select t2 from

Re: [sqlite] (no subject)

This makes a huge difference in speed thanks >>Also, you can write the query a bit more compactly: >>select fileref from rtable where vsc > 0 and isgraphic = 1 and md5 not in >>(select md5 from rtable where isgraphic = 1 and vsc = 0); On 31 January 2013 19:54, Igor Tandetnik

Re: [sqlite] (no subject)

On 31 Jan 2013, at 8:58pm, Simon Slavin wrote: > Depending on how chunky the values are in each column, a good index for this > would be an index on (md5,isgraphic,vsc). Sorry, that should be one index on (isgraphic,vsc), I think. Simon.

Re: [sqlite] (no subject)

On 31 Jan 2013, at 8:48pm, Paul Sanderson wrote: > Thanks all > > All columns in the query are indexed. That does not do you much good. Each SELECT can use only one index at a time. So if you have one index per column the query uses an index on, say,

Re: [sqlite] (no subject)

On 1/31/2013 2:33 PM, Paul Sanderson wrote: My query is select fileref from rtable as r where vsc > 0 and isgraphic = 1 and not exists (select md5 fr om rtable as r1 where r.md5 = r1.md5 and isgraphic = 1 and vsc = 0); explain query plan and explain have been run on the table with the results

Re: [sqlite] (no subject)

On 31 Jan 2013, at 7:33pm, Paul Sanderson wrote: > explain query plan and explain have been run on the table with the results > below. Any ideas where and how I can improve performance? Can you show us the indexes you've created on rtable ? Simon.

Re: [sqlite] (no subject)

On 09/05/2012 06:36 PM, Arbol One wrote: That would be the C++ Standard Template Library http://en.wikipedia.org/wiki/Standard_Template_Library I am learning the library and as a student I always have questions. The STL isn't necessarily a project, as it is defined in the C++ standard and

Re: [sqlite] (no subject)

Arbol One wrote: > Does anyone know if there is a mailing list for the STL project? Which of these do you mean by STL? http://en.wikipedia.org/wiki/Standard_Template_Library http://en.wikipedia.org/wiki/State_logic http://en.wikipedia.org/wiki/Subtitle_(captioning)

Re: [sqlite] (no subject)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/07/12 17:54, Jay A. Kreibich wrote: > Except that adds about 10x the workload for the moderators. I'd rather > have the SQLite team working on code, even if it means suffering the > occasional spam message. Who says the SQLite team have to be

Re: [sqlite] (no subject)

On Wed, Jul 18, 2012 at 02:10:52PM -0700, Roger Binns scratched on the wall: > On 18/07/12 13:00, Richard Hipp wrote: > > We have taken to requiring moderator approval before accepting new > > members onto this mailing list. > A better approach as used elsewhere (eg Google & Yahoo groups) is that

Re: [sqlite] (no subject)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 18/07/12 13:00, Richard Hipp wrote: > We have taken to requiring moderator approval before accepting new > members onto this mailing list. A better approach as used elsewhere (eg Google & Yahoo groups) is that the first ~10 messages from someone

Re: [sqlite] (no subject)

For the removal of doubt: We have taken to requiring moderator approval before accepting new members onto this mailing list. And even so spam like that shown below sometime leaks through. There is an arms race on, with spammers getting ever more sophisticated in their attacks. Sorry for the

Re: [sqlite] (no subject)

On Tue, Jun 12, 2012 at 8:32 AM, Igor Tandetnik wrote: > Nicholas Thompson wrote: >> Is it possible to safely use multiple threads in a process with each >> thread making >> its own connection to the same database >> >> rc =

Re: [sqlite] (no subject)

Nicholas Thompson wrote: > Is it possible to safely use multiple threads in a process with each > thread making > its own connection to the same database > > rc = sqlite3_open("file::memory:?cache=shared", ); Every time you connect to a :memory: database, a

Re: [sqlite] (no subject)

On 06/12/2012 05:41 PM, Nicholas Thompson wrote: Hi, I am new to SQLITE Would be using Microsoft VS 2008& 2010 Is it possible to safely use multiple threads in a process with each thread making its own connection to the same database rc = sqlite3_open("file::memory:?cache=shared",); Should

Re: [sqlite] (no subject)

On Wed, Jun 6, 2012 at 1:08 AM, vallur raghava reddy < vallur.raghavare...@gmail.com> wrote: > Hi, > I have few queries regarding the SQLite. I have listed them below please go > through them and give your answers. Thanks > Say if I am working on a DB with 3 tables with 100 records each and each

Re: [sqlite] (no subject)

At 07:08 06/06/2012, you wrote: Hi, I have few queries regarding the SQLite. I have listed them below please go through them and give your answers. Thanks Say if I am working on a DB with 3 tables with 100 records each and each records with some 5 fields of data.Each field is varchar(20) 1.

Re: [sqlite] (no subject)

On 4 Jun 2012, at 6:39pm, Jörgen Hägglund wrote: > What I am trying to accomplish is an update from the source data. If the > entry is already there, just ignore it. Otherwise add the new data. If any unique key (including the primary key) of the existing row and

Re: [sqlite] (no subject)

Hi! Thank You for replying Stefanos! Unfortunately, the errors were typos on my part. Sorry about that. As I wrote, everything works fine the first time around. What I am trying to accomplish is an update from the source data. If the entry is already there, just ignore it. Otherwise add the new

Re: [sqlite] (no subject)

On Fri, 25 May 2012 14:56:24 -0400, Frank Chang wrote: > > http://swatim dot sw dot ohost dot de/gertycamp3.html Poisonous link, don't click. Frank, please perform a rigorous virus check on your machine(s), you may have been infected by a bot. -- Regards, Kees

Re: [sqlite] (no subject)

On 5/24/2012 11:46 AM, IQuant wrote: ie. I have a table with 1,000,000 + records collecting real time stats from many devices with many columns but the main ones of interest are 'timestamp', 'latency' and 'DeviceID'. 2012-05-01 13:12:11.103 Null 14356 2012-05-01 13:12:11.103 Null 14372

Re: [sqlite] (no subject)

lav...@bigfraud.org > Date: Wed, 2 May 2012 11:57:40 +0100 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] (no subject) > > > On 2 May 2012, at 8:55am, Octet Computech <dawitteg...@hotmail.com> wrote: > > > I have an application that creates > > and

Re: [sqlite] (no subject)

On 2 May 2012, at 8:55am, Octet Computech wrote: > I have an application that creates > and saves some data in a SQLite database. I am using SQLite v 3.6.14, > accessing > it through the native dll form a C# WPF application. For some reason that I > cant figure out am

Re: [sqlite] (no subject)

On Wed, 4 Jan 2012 17:21:18 +0530, Tarun wrote: >Hi All, > >I am running program in which I have created SQLite DB file using: >sqlite3_open_v2() > >configured it: > >PRAGMA journal_mode = WAL >PRAGMA synchronous=OFF > >Then created one table into SQLiteDB by using

Re: [sqlite] (no subject)

On Wed, Jan 4, 2012 at 12:51 PM, Tarun wrote: > Waiting for your response, I am stuck in my work. > The physical size of the db file is an implementation detail, not a well-published behaviour with concrete reproducible results, and should in no way affect your use of

Re: [sqlite] (no subject)

On 31 Aug 2011 at 23:24, Igor Tandetnik wrote: > On 8/31/2011 5:56 PM, Tim Streater wrote: >> In the above, each database is newly created as shown. What I had >> forgotten to do was to create the "test" table in the second database >> before copying the data. What seems to

Re: [sqlite] (no subject)

On 8/31/2011 5:56 PM, Tim Streater wrote: In the above, each database is newly created as shown. What I had forgotten to do was to create the "test" table in the second database before copying the data. What seems to happen is that, lacking a "test" table in the test2 database, SQLite appears to

Re: [sqlite] (no subject)

On Wed, Aug 31, 2011 at 10:56:00PM +0100, Tim Streater scratched on the wall: > In the above, each database is newly created as shown. What I had > forgotten to do was to create the "test" table in the second > database before copying the data. What seems to happen is that, > lacking a "test"

Re: [sqlite] (no subject)

>Ah, there is a way to write it so that you can have at most one of >those constraints where only one makes sense, and not require a >specific order of constraints, but it'd require listing all the >possible orderings, which would be impractical. > >So if one wanted to enforce that there's at

Re: [sqlite] (no subject)

On Thu, May 19, 2011 at 4:28 PM, Nico Williams wrote: > However, I'm not sure how to write this such that there can be only > one of those constraints of which there should be just one but without > then imposing ordering on those constraints.  IMO there's no need to > fix

Re: [sqlite] (no subject)

On Thu, May 19, 2011 at 4:22 PM, Pavel Ivanov wrote: >> Is there a rationale for allowing such statements or is that an effect >> of the 'Lite' nature?  (Note: I'm not complaining, just asking.) > > I believe that's an effect of the "typeless" design. As SQLite doesn't > have

Re: [sqlite] (no subject)

> Is there a rationale for allowing such statements or is that an effect > of the 'Lite' nature?  (Note: I'm not complaining, just asking.) I believe that's an effect of the "typeless" design. As SQLite doesn't have strict type names for columns it accepts pretty much anything for that. So in

Re: [sqlite] (no subject)

On 21 Oct 2010, at 2:42pm, "" wrote: > please remove my name jbh...@bluefrog.com from the mailing list. Please click on the link included at the end of every message on this list. Simon. ___ sqlite-users

Re: [sqlite] (no subject)

On Sat, 22 May 2010, Prakash Reddy Bande wrote: > Me too, all attempts to unsubscribe have failed. On Sat, 22 May 2010, pcvetsko...@yahoo.com wrote: > please unuscribed pcvetko...@yahoo.com Did you try this: http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Enter the email address

Re: [sqlite] (no subject)

Me too, all attempts to unsubscribe have failed. I have put a filter, but still my .pst is becoming big. From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On Behalf Of Pece Cvetkoski [pcvetko...@yahoo.com] Sent: Saturday, May 22,

Re: [sqlite] (no subject)

Indeed, stupid typo in my sql. Sorry for the noise and the lack of a subject on the subject line in my first email. David --- On Tue, 10/27/09, Pavel Ivanov <paiva...@gmail.com> wrote: > From: Pavel Ivanov <paiva...@gmail.com> > Subject: Re: [sqlite] (no subject) > To

Re: [sqlite] (no subject)

Something screwed up in your application: sqlite> create table assets (Code Text, Acct1 Text, Acct2 Text); sqlite> insert into assets values ('C0', 'name1', 'name2'); sqlite> select * from assets; C0|name1|name2 sqlite> insert into assets select 'C0', 'name1', 'name3' where not exists (select 1

Re: [sqlite] (no subject)

´¯¯¯ >No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols >are represented by 2 bytes when UTF-16 does not. And I had an >understanding that Doug said about this 16-bit guarantee. Also if >we're talking about encoding where any character can be represented by >a single variable

Re: [sqlite] (no subject)

Doug, 3. "How are your strings stored in your program?  If they are stored with wchar_t, then using the '16' APIs is probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc)." I have no idea how they are stored, but I would guess as "standard" ASCII. Other community members have

Re: [sqlite] (no subject)

> Is there really anyone using UCS-2 now or did you mean UTF-16? No, I meant exactly UCS-2. Because UCS-2 guarantees that all symbols are represented by 2 bytes when UTF-16 does not. And I had an understanding that Doug said about this 16-bit guarantee. Also if we're talking about encoding where

Re: [sqlite] (no subject)

Hi Pavel, ´¯¯¯ >So conversion between wchar_t and >UCS-2 encoding is not always as easy as you can think. `--- Is there really anyone using UCS-2 now or did you mean UTF-16? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] (no subject)

> If they are stored with wchar_t, then using the '16' APIs is > probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc). Just don't forget that wchar_t on some platforms (reportedly on Linux for example) is 32-bit integer. So conversion between wchar_t and UCS-2 encoding is not

Re: [sqlite] (no subject)

Hi Erick -- I can only help a little with #3. How are your strings stored in your program? If they are stored with wchar_t, then using the '16' APIs is probably easiest to use (ie sqlite3_open16, sqlite3_prepare16_v2, etc). That's what I do and all sorts of European and Asian customers don't

Re: [sqlite] (no subject)

> Hello. > > I'm using SQLite with a VB wrapper (dhSQLite) for VB6. > > The following SQL string works fine for putting together a recordset where > the DATE field contains only the date of the last day of each month. > > > SQLString = "SELECT date(Date,'start of month','+1 month','-1

Re: [sqlite] (no subject)

On Mon, 1 Jun 2009 04:38:37 -0700 (PDT), "Manasi Save" wrote: >Hi, > >we are developing an application on android we are using SQLite Database >and on phone we are getting SQLiteException:no such table. but, it is >working fine on simulator. > >Can anyone

Re: [sqlite] (no subject)

On Tue, May 26, 2009 at 6:34 PM, John Machin wrote: > Don't try that with your 100MB database without ensuring that your > keyboard interrupt mechanism isn't seized up :-) > > Perhaps you meant > > .schema tablename I did indeed. I even remember going, "oh, yeah, don't want

Re: [sqlite] (no subject)

On 26/05/2009 7:58 PM, Samuel Baldwin wrote: > On Tue, May 26, 2009 at 4:45 PM, Martin.Engelschalk > wrote: >> select * from sqlite_master; > > Or: > .dump tablename Don't try that with your 100MB database without ensuring that your keyboard interrupt mechanism isn't

Re: [sqlite] (no subject)

On Tue, May 26, 2009 at 4:45 PM, Martin.Engelschalk wrote: > select * from sqlite_master; Or: .dump tablename -- Samuel 'Shardz' Baldwin - staticfree.info/~samuel ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] (no subject)

Hi, select * from sqlite_master; Martin PS.: Please provide a subject which summarises your question. Manasi Save schrieb: > Hi All, > > Can anyone help me out with the command to see the SQLite table defination > on command-line SQLite application. >

Re: [sqlite] (no subject)

: Daniel Watrous <dwmaill...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Monday, February 2, 2009 11:55:52 AM Subject: Re: [sqlite] (no subject) Hey Boris, It's a bit hard to follow what you've posted here, but I'm sure that's because

Re: [sqlite] (no subject)

program ends. Again the same code is used for successful and > failed results as outlined before. > > Thanks, > Boris > > > > > > > > From: Daniel Watrous <dwmaill...@gmail.com> > To: General Discussion of SQLite Database <sql

Re: [sqlite] (no subject)

iel Watrous <dwmaill...@gmail.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Saturday, January 31, 2009 5:42:40 PM Subject: Re: [sqlite] (no subject) why don't you send us some code. It sounds like you might have an issue managing your connections.

Re: [sqlite] (no subject)

why don't you send us some code. It sounds like you might have an issue managing your connections. On Sat, Jan 31, 2009 at 3:09 PM, Boris Arloff wrote: > Hi, > > I am having a small problem with an sqlite3 v3.5.6 database being accessed > from within python 2.5 (import

Re: [sqlite] (no subject)

t was bit > confusing when iam using sqlite command prompt > > Regards, > Satish > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor > Sent: Friday, November 14, 2008 11:35 AM > To: General Discussion of SQLite Datab

Re: [sqlite] (no subject)

] On Behalf Of P Kishor Sent: Friday, November 14, 2008 11:35 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] (no subject) On 11/13/08, Satish <[EMAIL PROTECTED]> wrote: > Hi! > > Really I am Serious about this I am very new to database and I want > to use

Re: [sqlite] (no subject)

Satish wrote: > Hi! > > Really I am Serious about this I am very new to database and I want > to use sqllite.so I want to know.THE Reason why asked this question is I > have seen a video of google tech bytes in that the presenter said that > sqllite doesn't support foreign key and alter

Re: [sqlite] (no subject)

t; -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Cory Nelson > Sent: Friday, November 14, 2008 11:22 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] (no subject) > > On Thu, Nov 13, 2008 at 9:31 PM, Satish

Re: [sqlite] (no subject)

want to know based on this I can proceed further. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cory Nelson Sent: Friday, November 14, 2008 11:22 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] (no subject) On Thu, Nov 13, 2008

Re: [sqlite] (no subject)

On Thu, Nov 13, 2008 at 9:31 PM, Satish <[EMAIL PROTECTED]> wrote: > Hi! > >Will sqllite support Foreign Key and ALTER Table Comands .I want to know > is there any documentation that helps me to know what are the classes that I > can use and program.I use vc++ to connect to database.tell me if