[sqlite] preserve column constraints

memory db is created. When i do a "select * from sqlite_master;" on the in-memory db, there is no IPK. How can I accomplish creating the in-memory db with the file db data and preserve the column configuration from the original table? I am using

Re: [sqlite] preserve column constraints

ok, thanks I guess i was assuming the command "create table x as select * from y" should preserve column constraints and maybe i was going about it wrong. thanks for the link to the backup api, i will see if this makes sense for my application. thanks, ed On Fri, May 22, 2009 at 10:5

Re: [sqlite] preserve column constraints

Does 'INSERT INTO mem_db SELECT * FROM file_db' work the same as 'CREATE TABLE mem_db AS SELECT * FROM file_db' with regard to transactions? Are the inserts going to be handled as one large transaction in either scenario? Do I need to explicitly use the BEGIN and COMMIT comma

[sqlite] memory usage

) and sqlite3_status(SQLITE_STATUS_MEMORY_USED, ...) but these look like they provide memory statistics for all of sqlite, not per database. thanks, ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: memory usage

Hello, I did not receive a reply to my question.Does anyone have any information on this? thanks, ed -- Forwarded message -- From: ed Date: Tue, Dec 30, 2008 at 10:02 AM Subject: memory usage To: sqlite-users@sqlite.org Hello, My multi-threaded application has various sqlite

Re: [sqlite] Fwd: memory usage

I haven't looked much at the source but will give it a shot.Thanks for the reply. On Wed, Jan 7, 2009 at 12:31 PM, Kees Nuyt wrote: > On Wed, 7 Jan 2009 10:25:12 -0800, ed > wrote in General Discussion of SQLite Database > : > > >Hello, I did not receive a reply to my qu

[sqlite] KEY keyword

raint, such that the following insert's conflict clause would even be necessary. INSERT OR REPLACE INTO elevator_data (id, schedule, panel, output_data) VALUES thanks, ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:80

Re: [sqlite] KEY keyword

Igor,thank you for the explanation however, I am still not clear if the conflict resolution clause will be used on a table with no UNIQUE or PRIMARY KEY columns? I would assume not but i couldn't find the answer in the documentation. thanks, ed On Fri, Jan 9, 2009 at 11:17 AM, Igor Tand

[sqlite] open/close db's across threads

e why sqlite3 is consuming increasingly more memory as the db's are opened and closed (as seen with valgrind's massif). -- thanks, ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] open/close db's across threads

any help on this would be appreciated. thanks, ed -- Forwarded message -- Hello,I have an application that is calling sqlite3_open() in one thread and sqlite3_close() in a different thread. The db's can potentially be opened and closed many times during execution of m

[sqlite] PRAGMA page_cache=x doesnt seem to have an effect

configured sqlite3_soft_heap_limit(8192000). Any help in figuring out how to limit the cache usage of memory would be appreciated. -- thanks, ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA page_cache=x doesnt seem to have an effect

Does anyone have any experience or examples of reducing sqlite memory usage through the pragma cache_size, page_size satements? I am misunderstanding the intended use of the pragmas? thanks, ed On Fri, Feb 20, 2009 at 5:58 PM, ed wrote: > Hello, > I am using sqlite in an embedded envir

Re: [sqlite] One more SQLite threading question

n't work. But this applies only to the pipelining idea. The serializing to use a single connection may still offer an interesting new locking model. Regards, Ed Pasma Op 14-mei-2007, om 13:04 heeft Jiri Hajek het volgende geschreven: Hello, I have tried to search all the documenta

Re: [sqlite] One more SQLite threading question

However, it would be too time consuming to serialize every call to sqlite3_step(), so I wonder whether it can be called in another thread. This almost immediately raises "library routine called out of sequence". It occurs as soon as the processing of A and B overlap, that means A is preparing

Re: Re[2]: [sqlite] Can't update table from itself or multiple tables

te equivalence. It arranges that "val" gets assigned null where no matching row is found in table2. If that is not desirable, this can be omitted to leave singular rows unchanged. Hope this is useful, Ed Pasma - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Trigger update of multiple columns

INSERT. Other suggestions should be welcome. Regards, Ed Op 17-jun-2007, om 10:00 heeft T&B het volgende geschreven: Hi All, I have a pretty standard sales tracking database consisting of tables: Products - Each row is a product available for sale. Includes fi

[sqlite] Nested Inner Join Help

D) ON A.Column3 = B.ID However depending upon where I put the parentheses I get various different errors from the viewer I use (SQLite Manager for Firefox). A normal Inner Join without the nesting works fine. Can anyone tell me what I'm doing wrong? Re

Re: [sqlite] Nested Inner Join Help

massively more complicated, but that was why I was attempting to use nested Inner Joins, although I'm not necessarily sure they would have helped in this situation anyway. Regards, Ed Adam DeVita wrote: > why not use: > > SELECT A.ID <http://a.id/>, A.Column1, A.Column2,

Re: [sqlite] Nested Inner Join Help

= b2.ID) join C c2 on (b2.Column1 = c2.ID) join D d2 on (b2.Column2 = d2.ID); where d2.ID = ? Would that work? Regards, Ed Igor Tandetnik wrote: > Ed Hawke > wrote: > >> To clarify this (I hope) if my table set-up is: >> >> Table A: >> IDColumn1

Re: [sqlite] Nested Inner Join Help

Thank you again Igor. By run-time defined fields I meant column names that SQL would not recognise until the query was executed, and therefore are only defined when the statement is "run". I am aware that this is probably not the correct terminology. Ed Igor Tandetnik wrote:

Re: [sqlite] Nested Inner Join Help

atement that defines them is run, and therefore I would classify them as run-time defined. I am aware as I said that these are probably not the correct SQL definitions, they were self-applied definitions to help make clear what I was referring to. I can only apologise that it made it more co

Re: [sqlite] Nested Inner Join Help

n the same transaction be able to reference c2, or does the reference only persist in the statement in which c2 was defined? Ed Igor Tandetnik wrote: > Ed Hawke wrote: > >> All I meant was that in a database you have defined tables with >> defined column names. These are defined b

Re: [sqlite] Huge performance drop when using prepared statement

Hello, think I got it, but it is disappointingly simple, see below. Ed. Markus Gritsch wrote: Even more strange: c.execute("""SELECT * FROM entry, word, word_entry WHERE entry.id = word_entry.entry_id AND word.id = word_entry.word_id AND word.word GLOB ? """

Re: [sqlite] shared cache mode locking

soon, also when there is no dead-lock. The situation may be handled by a programmatic retry? Regards, Ed Op 19-dec-2007, om 19:12 heeft Ken het volgende geschreven: Some additional info: when the sqlite_lock is returned there is another thread that appears to be reading the same tab

Re: [sqlite] shared cache mode locking

cache sharing. Ken wrote: Ed, Dan opened a ticket. I agree the documentation isn't clear on the Exlusive locking state. Not really sure, if this is by design or a bug at this stage. I do think its a great feature of the Shared cache mode to allow table level locking. But I'm cu

Re: [sqlite] shared cache mode locking

ons to the same database. Confusing or not? Ken wrote: Ed, Sorry if I confused you, a "Write" lock is really an EXCLUSIVE lock per sqlite documentation. I used the two interchangeably, pardon my error. A begin exclusive indicates the beginning of a transaction, It escalates

Re: [sqlite] Sqlite File Access Restriction

1) Sqlite database file access restriction: Is there a built-in or preferred method to block other processes from writing or even accessing a database file when its opened first by another process. I can get this to work by having the first process to open the file issue a BEGIN Exclusion or

Re: [sqlite] Shared Cache for Processes

Hi, Speaking only as a non-professional, I still try to answer. I don't want to comment on the benefits of shared cache mode now, but only on the question if it can be enabled in Apache. And I believe it can. As you say Apache pre-forks different processes, but within each process it pre-

Re: [sqlite] Most appropriate Web based database? (Newbie)

luted? > >Regards >Len >-- >View this message in context: http://www.nabble.com/Most-appropriate-Web-based-database-%28Newbie%29-t1404 628.html#a3788822 >Sent from the SQLite forum at Nabble.com. > > Sincerely, Ed Porter

[sqlite] Where to use PRAGMAs

ng to the tables if I check their statuses they have been reset to the default values. What am I doing wrong? Regards, Ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Binding with Views

problem? Regards, Ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How can I query a sqlite3_stmt to find out if it has been run through the sqlite3_prepare_v2 function?

Hello all, I have a function that is being passed an sqlite3_stmt object. Within this function I need to determine if the statement has been prepared. How can I accomplish this? Thanks very much. ___ sq

Re: [sqlite] How can I query a sqlite3_stmt to find out if it has been run through the sqlite3_prepare_v2 function?

ind out if it has > been run through the sqlite3_prepare_v2 function? > > Ed Curren wrote: > > I have a function that is being passed an sqlite3_stmt object. > > Within this function I need to determine if the statement has been > > prepared. How can I accomplish this? &

Re: [sqlite] How can I query a sqlite3_stmt to find out if ithas been run through the sqlite3_prepare_v2 function?

> Date: Tue, 9 Mar 2010 12:47:42 -0500 > Subject: Re: [sqlite] How can I query a sqlite3_stmt to find out if ithas > been run through the sqlite3_prepare_v2 function? > > Ed Curren wrote: > > This function will be called several times. The first time through > > the s

Re: [sqlite] How can I query a sqlite3_stmt to find outif ithas been run through the sqlite3_prepare_v2 function?

ask you in the words you are looking for. > To: sqlite-users@sqlite.org > From: itandet...@mvps.org > Date: Tue, 9 Mar 2010 13:03:00 -0500 > Subject: Re: [sqlite] How can I query a sqlite3_stmt to find outif ithas been > run through the sqlite3_prepare_v2 function? > > Ed Cu

Re: [sqlite] How can I query a sqlite3_stmt to find out if it has been run through the sqlite3_prepare_v2 function?

Mar 09, 2010 at 11:47:39AM -0500, Ed Curren scratched on the wall: > > > > Hello all, > > > > I have a function that is being passed an sqlite3_stmt object. > > I assume you mean a sqlite3_stmt pointer. You should never > instance an actual sqlite3_stmt str

Re: [sqlite] How can I query a sqlite3_stmt to find outif ithas been run through the sqlite3_prepare_v2 function?

ucture. > Usually when people say they have "function that is being passed an > sqlite3_stmt object" they mean this prototype: > > void f(sqlite3_stmt* stmt); > > If you will check for NULL inside this function (as Jay suggested) and > prepare statement if it's NULL then

Re: [sqlite] unsubsribe plz

Bennie wrote: > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Me too please! ___ sqlite-users mailing list sqlite-users@sqlite.or

Re: [sqlite] SELECT question (computing day of week the usingstrftime() function)

Please cancel my subscription to this list!! My Mail client is overwhelmed. Roger Andersson wrote: >> I need to find out how many specific weekdays (e.g., how many >> Sundays) I have in any given range of dates. >> My problem: How to use the COUNT function in combination with >> the strftime()

Re: [sqlite] notify all processes of database modification

coupled as much as possible from the SQLite source code. It's just not desirable for us to maintain the customized-SQLite-source-code solution we're using right now. -- Ed Scherer Innovision Corporation ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] notify all processes of database modification

functionality built into SQLite *or* go the opposite direction and get more-or-less the same API-level functionality, but with the notification mechanism source code as decoupled as much as possible from the SQLite source code. It's just not desirable for us to maintain the customized-SQLi

[sqlite] Horrendous slowdown when updating versions

takes 70 seconds. Whereas 10 was just about acceptable, 70 is definitely not; can anyone think of a reason why this might be, and what steps I could take to rectify it? Regards, Ed ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

[sqlite] Inconsistent SELECT results

sqlite3 3.7.4 Linux guardian 2.4.28 #1 Fri Dec 10 18:55:16 CST 2004 i686 unknown unknown GNU/Linux an older server running slackware 10 /dev/hda2 on / type reiserfs (rw) sqlite3 3.7.4 So, am I missing something? Or is this a bug of some sort? Thanks for any help, Ed Nolan ___

[sqlite] Please help, am I doing something wrong?

rograms do some writing. Is there a way to only lock the whole file when writing and not when reading? Actually, for anyone experienced in sqlite3, what's the correct way of using it in my situation? Thank you very much. --ed

Re: [sqlite] Re: Select with left outer join - Am I going mad or just having a bad day?

xample I'm just using CaseID 3145 to make sure that >only one category is matched, because I want to make sure the other >two categories still come back with a count of 0. > >But I'm not getting the other two categories coming back at all, let >alone with a count of 0. >-- >Ian M. Jones >___ >IMiJ Software >http://www.imijsoft.com >http://www.ianmjones.net (blog) > > > Sincerely, Ed Porter

Re: [sqlite] Re: Select with left outer join - Am I going mad or just having a bad day?

wrote: > >On 21 Mar 2006, at 18:11, Ed Porter wrote: > >> Hi Ian, >> >> You nee to use a Full Outer Join. I don't know if SQLite has this >> function. >> >> > >Nah, definitely only wanted a left outer, didn't want the results >mult

[sqlite] Saving BLOBs in Sqlite

s to be an amazing tool! I look forward to any help and I thank you in advance for your input. Sincerely, Ed Porter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Delete database

subsequent session, it cannot delete it. I've tried closing the database from all applications, (before deleting) to no avail. What am I doing wrong? I wish to thank you in advance for your help! Sincerely, Ed Porter - To unsu

[sqlite] Excessive access times

e documentation!) I dropped the time required to process the query by 2000% (over 20 times) with this simple solution. I look forward to your comments. Sincerely, Ed Porter Sincerely, Ed Porter - To unsubscribe, e-mail: [EMA

Re: [sqlite] ANN: SQLiteDB, a COM wrapper around sqlite has been released

ltiThread - hammer an sqlite database by reading data from multiple threads. > >Best regards, >George Ionescu Sincerely, Ed Porter

Re: [sqlite] re: ANN: SQLiteDB, a COM wrapper around sqlite has been released

Hi Fred, The SQLite code is in the DLL (you do not need to install the SQLite3.02 dll). This wrapper is excellent! As a third party reviewer, I find it to be the best one to date! Sincerely, Ed Porter At 11:42 AM 7/27/04 +0200, Frederic Faure wrote: >George Ionescu >> I have just

Re: [sqlite] Storing text in sqlite vs. external flat file

7;ve seen comments on this list suggesting the latter for BLOBs. Are there >specific tuning tweaks I can make to improve my results? > > > >Thanks, > >Ken Cooper > > Sincerely, Ed Porter

[sqlite] TRIM Function in Python3's sqlite3 import

function? 2. How do I update the RHEL Python to a version which has the TRIM function, or is there a replacement function available in 3.3.6 to which I can change the code? Thanks, Ed ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] TRIM Function in Python3's sqlite3 import

007-06-18) Can't help you with the Linux side of things, sorry. -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Ed Lipson --cut-- Thanks, Ed ___ sqlite-users mailing

[sqlite] Date Formatting from Excel Float Date/Time Representation

rmat. What formatting functions can I use to get it to appear as a date time in SQL output, as it appears in Excel? I have tried strftime and date but I don't get any meaningful data. Thanks, Ed ___ sqlite-users mailing list s

[sqlite] Significant Performance Problem with System.Data.SQLite.

I've finally finished converting from SQLserver Express to SQLite for an ASP.NET app on my development machine. VS 2010 Professional. System.Data.SQLite version 1.0.90.0, and 1.0.89.0 Got everything working great in development, but did I ever have problems deploying to Win Server 2012. Finall

Re: [sqlite] Significant Performance Problem with System.Data.SQLite.

Performance Problem with System.Data.SQLite. Ed Tenholder wrote: > > The asp.net app is several pages, each with from one to three datagrids that > are filled using ADO.NET. Very little actual code. Using GridView, > DetailsView, DropDownList, and SqlDataSource > (ProviderName="System

[sqlite] Significant Performance Problem with System.Data.SQLite.

I have never used a profiling tool. Have VS 2010 installed. A quick web search shows several available free tools. What do you recommend for VS 2010 and SQLite? Are you able to run the application with profiling enabled to determine whic

[sqlite] FW: Need Help with Golf Handicap Calculation

From: Ed Tenholder Sent: Saturday, February 08, 2014 1:44 PM To: 'sqlite-users@sqlite.org' Subject: Need Help with Golf Handicap Calculation I’m just trying to learn SQL, and after lots of google searches and reading posts on this email list, I’ve gotten pretty close. Table:

Re: [sqlite] FW: Need Help with Golf Handicap Calculation

...@sqlite.org] On Behalf Of James K. Lowden Sent: Sunday, February 09, 2014 6:04 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] FW: Need Help with Golf Handicap Calculation On Sat, 8 Feb 2014 19:47:44 + Ed Tenholder wrote: > Query: SELECT MAX(ScoreDate),AVG((Score-Rating)*(113.0/Slope))*

[sqlite] YACC/Bison vs. Lemon vs. standard input

I'm trying to convert a calculator from Bison to Lemon. I ran into an unexpected problem involving standard input where the two programs behave quite differently.  The Bison version prints the result immediately after pressing [Enter]. With the Lemon version, the result is delayed until I type a n

[sqlite] SQLITE_FTS3_MAX_EXPR_DEPTH and upgrading sqlite

it to allow this one client to do their queries as they used to do, but will not know that we’ve raised it enough to allow all our clients to get the same behavior they were accustomed to? How do people choose this limit? Thanks much! Ed ___ sqlite-