Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
ok sorry, I did not red all thru, may you simply sha1 local and remote ? if != commit again On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin slav...@bigfraud.org wrote: On 15 Jul 2014, at 2:20am, William Drago wdr...@suffolk.lib.ny.us wrote: The software doesn't crash on its own; I'm forcing

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
, 2014 at 6:53 AM, mm.w 0xcafef...@gmail.com wrote: ok sorry, I did not red all thru, may you simply sha1 local and remote ? if != commit again On Tue, Jul 15, 2014 at 12:49 AM, Simon Slavin slav...@bigfraud.org wrote: On 15 Jul 2014, at 2:20am, William Drago wdr...@suffolk.lib.ny.us wrote

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
forgot if != commit again or restore if local unusable (lossy scenario) On Tue, Jul 15, 2014 at 7:01 AM, mm.w 0xcafef...@gmail.com wrote: yes indeed the journal tweaking would work solely for this special file case, comparing local and remote that's how for instance git works like many other

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
:53pm, mm.w 0xcafef...@gmail.com wrote: ok sorry, I did not red all thru, may you simply sha1 local and remote ? if != commit again You won't have anything to commit. If your application really had crashed it wouldn't have any transaction data to commit. If your application had not crashed

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
but it does not imply that in rare cases that either of files are not busted, that's the reason of backups being able to recover last seen (the lossy case, shit happens) On Tue, Jul 15, 2014 at 10:06 AM, mm.w 0xcafef...@gmail.com wrote: Simon your design-idea do not reflect any reality

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
yes that's exactly what I said thank you to confirm my dear 8) If the pipe dies halfway then the app would know it sorry LOL On Tue, Jul 15, 2014 at 12:13 PM, RSmith rsm...@rsweb.co.za wrote: On 2014/07/15 19:06, mm.w wrote: Simon your design-idea do not reflect any reality, this is weak

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
to be clear, the original solution does not answer the question, it tries to relay on sqlite specifics, where specifics are beyond the sqlite small world. you must read back the first request to understand. On Tue, Jul 15, 2014 at 1:10 PM, mm.w 0xcafef...@gmail.com wrote: yes that's exactly

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
morality good question, wrong solution from the op + wrong solution gain of simon to endorse the bad design, so then when you are serious you roll-back to the entry point not the broken branch. On Tue, Jul 15, 2014 at 1:12 PM, mm.w 0xcafef...@gmail.com wrote: to be clear, the original

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
with it. thank you. On Tue, Jul 15, 2014 at 1:16 PM, mm.w 0xcafef...@gmail.com wrote: morality good question, wrong solution from the op + wrong solution gain of simon to endorse the bad design, so then when you are serious you roll-back to the entry point not the broken branch. On Tue, Jul 15, 2014

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
and the inside and all the possible entry point. thank you for getting back on earth. On Tue, Jul 15, 2014 at 1:27 PM, mm.w 0xcafef...@gmail.com wrote: sorry, I did not enter in the specifics of the answer, because it's driven by personal feelings which are off topic and surely misplaced but I

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
, mm.w wrote: whine_spam++ // Apologies to all. Not sure if this is intended for Simon too, or only myself - either way, would you be so kind as to take it off-list, it is of no benefit to others here - much appreciated. ___ sqlite-users

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
don't try to look good when you are not. thank you. On Tue, Jul 15, 2014 at 2:02 PM, mm.w 0xcafef...@gmail.com wrote: why Apologies when it's solely addressed to you, please don't be a hypocrite everybody can understand that in your first paragraph you are out of the topic and the line

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
projecting yourself over a 2 years round, must laugh at large, I can't tell you, my little candy. Best. On Tue, Jul 15, 2014 at 2:04 PM, mm.w 0xcafef...@gmail.com wrote: don't try to look good when you are not. thank you. On Tue, Jul 15, 2014 at 2:02 PM, mm.w 0xcafef...@gmail.com wrote

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
I agree I am not the best communication guy ever born but I can say no guys don't roll-back this is a terrible idea without getting personal On Tue, Jul 15, 2014 at 3:26 PM, Simon Slavin slav...@bigfraud.org wrote: On 15 Jul 2014, at 11:03pm, mm.w 0xcafef...@gmail.com wrote: Simon

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
anyway no drama here, I am not here to fight or getting personal, that's just on a situation I ve seen I get passionate that's all On Tue, Jul 15, 2014 at 3:28 PM, mm.w 0xcafef...@gmail.com wrote: I agree I am not the best communication guy ever born but I can say no guys don't roll-back

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
hello, if you think so, I have noting to say to you, because you already made your judgement without giving a right of answer, so be it. On Tue, Jul 15, 2014 at 4:18 PM, RSmith rsm...@rsweb.co.za wrote: On 2014/07/16 00:03, mm.w wrote: And to finally be clear I am a plain guy I don't hide

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
you dare to affirm that I affirm , I On Tue, Jul 15, 2014 at 4:43 PM, mm.w 0xcafef...@gmail.com wrote: hello, if you think so, I have noting to say to you, because you already made your judgement without giving a right of answer, so be it. On Tue, Jul 15, 2014 at 4:18 PM, RSmith rsm

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
am not else you don't understand one single line of my previous comments, you are just pissed off and not able to calling off thing I did On Tue, Jul 15, 2014 at 4:44 PM, mm.w 0xcafef...@gmail.com wrote: you dare to affirm that I affirm , I On Tue, Jul 15, 2014 at 4:43 PM, mm.w 0xcafef

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
I already accepted your apologies why don't you give some air simply? instead of poisoning the actual lame situation? On Tue, Jul 15, 2014 at 4:46 PM, mm.w 0xcafef...@gmail.com wrote: am not else you don't understand one single line of my previous comments, you are just pissed off

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try 8D On Tue, Jul 15, 2014 at 4:48 PM, mm.w 0xcafef...@gmail.com wrote: I already accepted your apologies why don't you give some air simply? instead of poisoning the actual lame situation? On Tue, Jul 15, 2014 at 4:46

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
I am sorry I am jocking but you 'r calling of for white flag and use it to charge again. On Tue, Jul 15, 2014 at 4:51 PM, mm.w 0xcafef...@gmail.com wrote: seriously Rsmith \\\ 3 slashes is the microsoft guy way then I give a try 8D On Tue, Jul 15, 2014 at 4:48 PM, mm.w 0xcafef...@gmail.com

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
and moreover you bluntly lie On Tue, Jul 15, 2014 at 4:53 PM, mm.w 0xcafef...@gmail.com wrote: I am sorry I am jocking but you 'r calling of for white flag and use it to charge again. On Tue, Jul 15, 2014 at 4:51 PM, mm.w 0xcafef...@gmail.com wrote: seriously Rsmith \\\ 3 slashes

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
oh boy On Tue, Jul 15, 2014 at 5:10 PM, mm.w 0xcafef...@gmail.com wrote: and moreover you bluntly lie On Tue, Jul 15, 2014 at 4:53 PM, mm.w 0xcafef...@gmail.com wrote: I am sorry I am jocking but you 'r calling of for white flag and use it to charge again. On Tue, Jul 15, 2014

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
I thought you were a good person... seriously? what it is your issue with just telling the truth, I am the first person here to say I am full of shit, sorry for the derogatory language but that's fact get back on your feet man! On Tue, Jul 15, 2014 at 5:11 PM, mm.w 0xcafef...@gmail.com wrote

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
almost 2 hours of of unbelievable crap seriously? just for accusing me of bad behaviors towards Simon on a topic you don't even know? sorry again. On Tue, Jul 15, 2014 at 5:15 PM, mm.w 0xcafef...@gmail.com wrote: I thought you were a good person... seriously? what it is your issue with just

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
yes where arethe social kills? telling crap loooking a like a queenie? just work on tv man not real life. On Tue, Jul 15, 2014 at 5:18 PM, mm.w 0xcafef...@gmail.com wrote: almost 2 hours of of unbelievable crap seriously? just for accusing me of bad behaviors towards Simon on a topic you

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
and I stay public even it looks weird, but seriously grew up and fast kiddo. On Tue, Jul 15, 2014 at 5:21 PM, mm.w 0xcafef...@gmail.com wrote: yes where arethe social kills? telling crap loooking a like a queenie? just work on tv man not real life. On Tue, Jul 15, 2014 at 5:18 PM, mm.w

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
to temporarily block him from the list would do any good, would it? May be time to investigate how to get gmail to block specific addresses. On Tue, Jul 15, 2014 at 6:34 PM, mm.w 0xcafef...@gmail.com wrote: and I stay public even it looks weird, but seriously grew up and fast kiddo

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
if you want some hint about google mail I can provide you, I could even ask for my username change without any loss On Tue, Jul 15, 2014 at 5:37 PM, mm.w 0xcafef...@gmail.com wrote: yes because I have nothing to hide, if you wish to block me so be it, no offense taken, do it and we can share

Re: [sqlite] capturing and testing a hot journal

2014-07-15 Thread mm.w
and yes I don't spit in a face of someone, then selling my so good reputation you are joke rsmith and you would dare any of the crap face to face sorry truth must be told and I did not started this shit for the record. On Tue, Jul 15, 2014 at 5:39 PM, mm.w 0xcafef...@gmail.com wrote: if you

Re: [sqlite] capturing and testing a hot journal

2014-07-14 Thread mm.w
seriously? you should fix and solve why the soft crashed in the first place, reality check please. But it is possible that Dropbox will copy a database and journal files that are not consistent with each other, which can create problems fix the sync process, that's easy. Best. On Mon, Jul

Re: [sqlite] Sometimes when my process restarts, it returns error database is locked

2014-07-11 Thread mm.w
what's your file system? looks like not related at all to sqlite but your code On Fri, Jul 11, 2014 at 4:31 PM, Mayank Kumar (mayankum) mayan...@cisco.com wrote: Hi Richard I have enabled error logging as suggested. Is there a way to test this logging. For e.g. I just corrupted the

Re: [sqlite] Can't make SQLite work

2014-07-09 Thread mm.w
? ... On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin slav...@bigfraud.org wrote: On 7 Jul 2014, at 4:21am, mm.w 0xcafef...@gmail.com wrote: as we start low a more simple solution if recent features are needed Nothing to do with MacPorts is simple. If you've messed up your shell path

Re: [sqlite] Can't make SQLite work

2014-07-09 Thread mm.w
? ... On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin slav...@bigfraud.org wrote: On 7 Jul 2014, at 4:21am, mm.w 0xcafef...@gmail.com wrote: as we start low a more simple solution if recent features are needed Nothing to do with MacPorts is simple. If you've messed up your shell path

Re: [sqlite] Can't make SQLite work

2014-07-09 Thread mm.w
thx to teach me-self about the port LOL On Wed, Jul 9, 2014 at 3:03 PM, mm.w 0xcafef...@gmail.com wrote: ? ... On Mon, Jul 7, 2014 at 12:48 AM, Simon Slavin slav...@bigfraud.org wrote: On 7 Jul 2014, at 4:21am, mm.w 0xcafef...@gmail.com wrote: as we start low a more simple solution

Re: [sqlite] column affinity and the query planner's use of indices

2014-07-08 Thread mm.w
Hello, Keith Medcalf would not be more simple just to say create your own metadata wrapper which is perfectly doable and legitimate in such case. Best. On Tue, Jul 8, 2014 at 10:47 AM, Simon Slavin slav...@bigfraud.org wrote: On 8 Jul 2014, at 6:16pm, Hinrichsen, John jhinrich...@c10p.com

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

2014-07-07 Thread mm.w
* from where 0 will it be able to get an immediate lock on the table. Srikanth On Sun, Jul 6, 2014 at 9:21 PM, mm.w 0xcafef...@gmail.com wrote: what's the syscall set behind the scene might help, os? On Sun, Jul 6, 2014 at 6:04 PM, Srikanth Bemineni bemineni.srika...@gmail.com

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

2014-07-07 Thread mm.w
your sunglasses won't stop my gaze On Mon, Jul 7, 2014 at 4:21 PM, mm.w 0xcafef...@gmail.com wrote: comply to my request or stop, sorry but truth must be told at some point. On Mon, Jul 7, 2014 at 6:02 AM, Srikanth Bemineni bemineni.srika...@gmail.com wrote: Hi, How can I find

Re: [sqlite] Sqlite in dead lock state when deleting records from the same table from different threads

2014-07-06 Thread mm.w
what's the syscall set behind the scene might help, os? On Sun, Jul 6, 2014 at 6:04 PM, Srikanth Bemineni bemineni.srika...@gmail.com wrote: Hi, Is it possible for any SQLLite developer to explain the locking mechanism in case of the shared connections, specifically table level locking,

Re: [sqlite] Can't make SQLite work

2014-07-06 Thread mm.w
as we start low a more simple solution if recent features are needed http://www.macports.org/ sudo port install sqlite3 best On Sun, Jul 6, 2014 at 10:27 AM, Richard Hipp d...@sqlite.org wrote: On Sat, Jul 5, 2014 at 3:46 PM, Mike Seabrook Sr mseabroo...@gmail.com wrote: Hi there, I

Re: [sqlite] Updating one DB from another

2014-06-19 Thread mm.w
diff and update when a user is actually migrating, let server1 run until all users have migrated, if migrated prevents to ever connect to server1 simple. best On Thu, Jun 19, 2014 at 1:59 PM, jose isaias cabrera cabr...@wrc.xerox.com wrote: Simon Slavin wrote... On 19 Jun 2014, at

Re: [sqlite] Updating one DB from another

2014-06-19 Thread mm.w
morality: opting for the pseudo-hot-sync-based-on-will-be-ever-faulty, in the first place, was ridiculous, I don't know how it could have been even retained. -- best. On Thu, Jun 19, 2014 at 3:19 PM, mm.w 0xcafef...@gmail.com wrote: diff and update when a user is actually migrating, let

Re: [sqlite] Android sqlite error

2014-06-12 Thread mm.w
you can't write at dest, then the journal file fails, quite obvious reading the logs On Wed, Jun 11, 2014 at 11:41 PM, Sathish N nsathis...@gmail.com wrote: I am new for sqlite. The following sqlite error comes in my android phone. when i run the application sum times. I like to know the

Re: [sqlite] Application with 'grid' form for entering table data wanted

2014-06-04 Thread mm.w
I know about that https://github.com/j4mie/idiorm no cargobay On Wed, Jun 4, 2014 at 7:08 AM, David Bicking dbic...@yahoo.com wrote: I don't know php, but this sounds like what I think you want: phpGrid | PHP Datagrid Made Easy. phpGrid | PHP Datagrid Made Easy. phpGrid is a simple,

Re: [sqlite] how to write this commands?

2014-05-16 Thread mm.w
Note to self: Someday, you want to be like Igor. in which way LOL. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Porting SQLite to plain C RTOS

2014-05-13 Thread mm.w
http://pubs.opengroup.org/onlinepubs/7908799/xsh/systime.h.html http://pubs.opengroup.org/onlinepubs/7908799/xsh/flockfile.html http://pubs.opengroup.org/onlinepubs/009695399/functions/fcntl.html // IEEE Std 1003.1, 2004 Edition @!!= linux On Tue, May 13, 2014 at 7:55 AM, Artur Deterer

Re: [sqlite] select 1 where 1 - 1;

2014-05-05 Thread mm.w
Hello, an empty string should be false strongly disagree, a NULL string should be solely false, now in this case, the question is: comparisons should be handled as bin or by; 'literal' values? or equality/comparison must not be eval'ed and strictly made on type? one other of the quirk would be

Re: [sqlite] select 1 where 1 - 1;

2014-05-05 Thread mm.w
select inf; should be true or false? :) On Mon, May 5, 2014 at 8:18 AM, mm.w 0xcafef...@gmail.com wrote: Hello, an empty string should be false strongly disagree, a NULL string should be solely false, now in this case, the question is: comparisons should be handled as bin or by; 'literal

Re: [sqlite] select 1 where 1 - 1;

2014-05-05 Thread mm.w
I know Simon, just asking, nope an empty string is a valid string, else you say no NULL allowed for strings, might be a backend option 8) On Mon, May 5, 2014 at 8:27 AM, Simon Slavin slav...@bigfraud.org wrote: On 5 May 2014, at 4:18pm, mm.w 0xcafef...@gmail.com wrote: an empty string

Re: [sqlite] select 1 where 1 - 1;

2014-05-05 Thread mm.w
LOL be careful not to break the stinger and leave it buried in the skin. Hello Petite Abeille, when you eval an expression, are you doing from the right or on the lvalue. Best. On Mon, May 5, 2014 at 1:03 PM, Petite Abeille petite.abei...@gmail.comwrote: On May 5, 2014, at 9:15 PM,

Re: [sqlite] select 1 where 1 - 1;

2014-05-05 Thread mm.w
Hihihi, some folks do not share the same references, anyway yes 3 passes that's named super bowle, LOL (warning many bad jokes inside) On Mon, May 5, 2014 at 3:31 PM, Petite Abeille petite.abei...@gmail.comwrote: On May 6, 2014, at 12:15 AM, Jay Kreibich j...@kreibi.ch wrote: Cross what

Re: [sqlite] WP8 compiled version

2014-04-27 Thread mm.w
Hello, not on win phone, for the other questions: yes never used Xamarin, as far I can see that's a mono based toolchain, I don't do C# Best On Sun, Apr 27, 2014 at 11:19 AM, Vadim Kantorov vadimkanto...@gmail.comwrote: Hello, I'm a newbie for SQLite. I am considering SQLite as the

Re: [sqlite] Most efficient storage for arrays

2014-04-23 Thread mm.w
Ok, you can store a JSON like structure, by reproducing the graf adapted to SQL I wrote that (for fun, not only writing code for my day to day job) [mostly that what core data does with all this mysterious ids, that's just a transpose vertical to horizontal], there are primitive-tables named by

Re: [sqlite] Most efficient storage for arrays

2014-04-23 Thread mm.w
Ok, you can store a JSON like structure, or plist, coding is a creative discipline, not a nerd stuff. On Wed, Apr 23, 2014 at 12:16 PM, mm.w 0xcafef...@gmail.com wrote: Ok, you can store a JSON like structure, by reproducing the graf adapted to SQL I wrote that (for fun, not only writing code

Re: [sqlite] about merge rows

2014-04-18 Thread mm.w
@hello, it looks like an old sybase http://en.wikipedia.org/wiki/Sybase_SQL_Server-ms-flatten-like export, if I understand well you got that just after splitting then pivoting the properties, am I wrong? On Thu, Apr 17, 2014 at 6:43 PM, Igor Tandetnik i...@tandetnik.org wrote: On 4/17/2014

Re: [sqlite] Any interest for open source multi-user 'SQLite database server' application?

2014-04-18 Thread mm.w
Hello, First off, agreed an ODBC interface would be more suitable and secure, don't trust today-most-web-devs to make the RPC layer secure [cruft-obfuscation open backdoor they know], not trolling around just the day to day reality; when I sit on some server-codes ... if you can call that code at

Re: [sqlite] Useful - A Portable Class Library (PCL) for low-level (raw) access to SQLite

2014-04-10 Thread mm.w
Hello, may you tag your message withC#, as far as I know [[a Portable low-level (raw) access to SQLite]] that's already named sqlite itself as per see, written in a portable low-levelable language named C, I might be mistaken thu. Best. On Thu, Apr 10, 2014 at 2:16 PM, Mike Parsons

Re: [sqlite] Establishing a connection and downloading tables from an SQLite server

2014-04-08 Thread mm.w
Hello, design your own RPC layer thru https with all the credentials you need. Best. On Mon, Apr 7, 2014 at 12:21 PM, Armando Gonzalez yomand...@gmail.comwrote: Donald: I appreciate the response. I guess that using a command line interface program could work. I used it for a local

Re: [sqlite] comma-separated string data

2014-04-07 Thread mm.w
Hello, Dear Petite Abeille, you may repeat it 1 times, they don't listen, they prefer adding to the previous mistake instead of fixing the origin (hiding behind falsehood constraints, like it is way it is...) until it will fall apart with unsolvable issues and developer-made-bugs, surely

Re: [sqlite] comma-separated string data

2014-04-07 Thread mm.w
But if the Customer can't tell the difference, does that make you a good pimp? Hello, you just don't get it then you don't get it, that's it. Best Regards On Mon, Apr 7, 2014 at 12:09 PM, RSmith rsm...@rsweb.co.za wrote: On 2014/04/07 20:57, Petite Abeille wrote: Lipstick Driven Design:

Re: [sqlite] comma-separated string data

2014-04-07 Thread mm.w
Hello, thus, good, incident closed, we've seen worse; I guess, the misunderstanding was triggered by not following up and well on the lipstick 8-p Best. On Mon, Apr 7, 2014 at 4:27 PM, RSmith rsm...@rsweb.co.za wrote: On 2014/04/08 01:02, David Simmons wrote: Why are these people allowed

Re: [sqlite] if possible point another table

2014-04-03 Thread mm.w
Hello, yep; else; it would require an eval or the support to sql scripting, as none of this exists, it has to be done at the program level; in a regular two queries run, nothing fancy or extraordinary. Best. On Thu, Apr 3, 2014 at 9:13 PM, Andy Goth andrew.m.g...@gmail.com wrote: On 4/3/2014

Re: [sqlite] if possible point another table

2014-04-03 Thread mm.w
refactoring the model using views might be an option too. On Thu, Apr 3, 2014 at 9:50 PM, mm.w 0xcafef...@gmail.com wrote: Hello, yep; else; it would require an eval or the support to sql scripting, as none of this exists, it has to be done at the program level; in a regular two queries

Re: [sqlite] SQLite3_create_collation

2014-04-02 Thread mm.w
Hello, First off, there are no Obj-C APIs for SQLite built into iOS yes or not that's named CoreData which saves its graph either to a plist or a sqlite db, Second off, don't use the sqlite-lib delivered by the sub-system; inline your own version, (don't ask why, just do), see build options

Re: [sqlite] SQLite3_create_collation

2014-04-02 Thread mm.w
to the CoreICU On Wed, Apr 2, 2014 at 2:21 PM, mm.w 0xcafef...@gmail.com wrote: Hello, First off, there are no Obj-C APIs for SQLite built into iOS yes or not that's named CoreData which saves its graph either to a plist or a sqlite db, Second off, don't use the sqlite-lib delivered by the sub

Re: [sqlite] apparent column data type affected by numeric operation elsewhere

2014-03-24 Thread mm.w
Hello, is it fixed in 3.8.4.1 or only in the repo? is that possible to add the date on the Download Page section? Best. On Mon, Mar 24, 2014 at 8:35 AM, Richard Hipp d...@sqlite.org wrote: Also worked correctly in 3.8.2. Problem introduced in 3.8.3. Fixed here:

Re: [sqlite] apparent column data type affected by numeric operation elsewhere

2014-03-24 Thread mm.w
Hello ok thx, I currently use 3.8.3.1 amalgamation, I try to keep on official updates, I have already mine to deal with Best. On Mon, Mar 24, 2014 at 10:10 AM, Richard Hipp d...@sqlite.org wrote: On Mon, Mar 24, 2014 at 1:07 PM, mm.w 0xcafef...@gmail.com wrote: Hello, is it fixed

Re: [sqlite] apparent column data type affected by numeric operation elsewhere

2014-03-24 Thread mm.w
Hello, attached my build settings/patches if it helps, I added stuff for win Best. On Mon, Mar 24, 2014 at 10:15 AM, mm.w 0xcafef...@gmail.com wrote: Hello ok thx, I currently use 3.8.3.1 amalgamation, I try to keep on official updates, I have already mine to deal with Best. On Mon

Re: [sqlite] Opening and closing an SQLITE3 db in PHP

2014-03-18 Thread mm.w
Hello, you should ask that on the php stream, they would probably know better about their wrapper implementation. try catching up with Ilia. Best Regards On Tue, Mar 18, 2014 at 4:49 PM, Tim Streater t...@clothears.org.uk wrote: Part of my app will, at user request, read some data from an

Re: [sqlite] How to query key-value-pairs similar to PostgreSQL HSTORE type?

2014-03-18 Thread mm.w
, 2014 at 6:09 PM, mm.w 0xcafef...@gmail.com wrote: Hello, you can do a pivot, depends how big the data are, the best option would be to extend a script like mysql2sqlite and then transform the DB to avoid serialized like oddities. other option use json On Tue, Mar 18, 2014 at 1:09 PM

Re: [sqlite] Weird out of memory problem a prepare

2014-03-04 Thread mm.w
Hello, what's your SharedSection value? [heap limitation] Best Regards. On Tue, Mar 4, 2014 at 12:16 PM, Clemens Ladisch clem...@ladisch.de wrote: Eduardo Morras wrote: Trying simple SELECT r.name FROM resource AS r WHERE r.name = ? gets Out of memory too calling preparev2. This has

Re: [sqlite] SQLite destroys civilization.

2014-03-03 Thread mm.w
LOL don't know if it will go thru see png layer or neuron out of bounds ! Best Regards. On Sun, Mar 2, 2014 at 2:04 PM, Richard Hipp d...@sqlite.org wrote: On Sun, Mar 2, 2014 at 12:34 PM, Richard Hipp d...@sqlite.org wrote: Reports on twitter say that the nanobots in the TV drama

Re: [sqlite] sqlite_compileoption_get + cte

2014-03-01 Thread mm.w
Hello, ? PRAGMA compile_options; Best Regards. On Sat, Mar 1, 2014 at 7:01 AM, Petite Abeille petite.abei...@gmail.comwrote: Just because we can: with Option( name, position ) as ( select sqlite_compileoption_get( 1 ) as name, 1 as position union all select

Re: [sqlite] sqlite_compileoption_get + cte

2014-03-01 Thread mm.w
Hello you meant that's for the Buzz 8) (joke inside) Best Regards On Sat, Mar 1, 2014 at 11:06 AM, Petite Abeille petite.abei...@gmail.comwrote: On Mar 1, 2014, at 6:30 PM, mm.w 0xcafef...@gmail.com wrote: ? PRAGMA compile_options; Yes, sure. But much snazzier to use a CTE, no? :D

Re: [sqlite] compile problem with sqlite 3.7.6.3 on ubuntu

2014-02-27 Thread mm.w
Hello that's an undefined symbol of some lib/fork sqlite_shell_init_icu, this is not part of sqlite standard amalgamation, I guess you need to add shell_icu_linux.c from the fork at compile time. Best Regards On Thu, Feb 27, 2014 at 11:35 AM, Nabeel Younus nyk2...@gmail.com wrote: HI,

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, I don't know anything about c# and the Entity Framework, but something obvious where do you close your connection? Best Regards. On Wed, Feb 26, 2014 at 11:46 AM, Joe Strommen joe.strom...@gmail.comwrote: Hi all, I'm using SQLite with Entity Framework 6 and having a problem. I

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
at 12:28 PM, Joe Strommen joe.strom...@gmail.comwrote: The end of the using() block automatically closes the connection. If I remove the line with efContext.TestEntities.Count() then it works fine. On Thu, Feb 27, 2014 at 2:09 PM, mm.w 0xcafef...@gmail.com wrote: Hello, I don't know

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
(Data Source= + path)) block will close the connection. I'm not relying on Entity Framework to close the connection for me. On Thu, Feb 27, 2014 at 2:33 PM, mm.w 0xcafef...@gmail.com wrote: Hello, reading quickly the doc Constructs a new context instance using the existing connection

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, is it the class you use? https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs then extend SQLiteConnection and overwrite public void Dispose () to trace what's happening Best Regards. On Thu, Feb 27, 2014 at 12:33 PM, mm.w 0xcafef...@gmail.com wrote: Hello, reading

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
to get it re-opened. Thanks Joe On Thu, Feb 27, 2014 at 2:49 PM, mm.w 0xcafef...@gmail.com wrote: Hello, is it the class you use? https://github.com/peterhuene/sqlite-net/blob/master/src/SQLite.cs then extend SQLiteConnection and overwrite public void Dispose () to trace what's

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
a comment to the ticket. It would be great if a dev working on SQLite-LINQ integration gave this a look. Thanks much! On Thu, Feb 27, 2014 at 2:55 PM, mm.w 0xcafef...@gmail.com wrote: Hello, so then move your code out of a scoped using block or force the gc at the end before deleting

Re: [sqlite] EF6 - SQLite file remains locked after dispose

2014-02-27 Thread mm.w
Hello, my bad learning c# on the rock, I feel dirty. Best Regards. On Thu, Feb 27, 2014 at 1:17 PM, mm.w 0xcafef...@gmail.com wrote: Hello tell him to add a call named close() ... but anyway try that: var sqliteConnection = null; using (sqliteConnection = new

Re: [sqlite] Query Flattening / Query Optimization / Correlated Subquery Substitution

2014-02-25 Thread mm.w
25, 2014 at 6:18 AM, Keith Medcalf kmedc...@dessus.com wrote: On Monday, 24 February, 2014 21:53, mm.w 0xcafef...@gmail.com said: I don't want to be annoying but why nowadays people are sub-abusing-sub-selecting instead of using JOINs? moreover, that is in most cases faster (a lot

Re: [sqlite] Query Flattening / Query Optimization / Correlated Subquery Substitution

2014-02-24 Thread mm.w
Hello, I don't want to be annoying but why nowadays people are sub-abusing-sub-selecting instead of using JOINs? moreover, that is in most cases faster (a lot) and certainly more Human Readable. Best Regards On Mon, Feb 24, 2014 at 8:34 PM, Keith Medcalf kmedc...@dessus.com wrote: Previous

Re: [sqlite] Problem with .mode line

2014-02-21 Thread mm.w
hello, this is only a problem of carriage returns or/and line feed. http://notepad-plus-plus.org/ Best Regards. On Thu, Feb 20, 2014 at 6:58 AM, pelek i...@mdpserwis.pl wrote: indeed ! I tried to open same file with Programers Notepad and file looked exacly like I need. But when I was

Re: [sqlite] partially excluding records

2014-02-21 Thread mm.w
Hello I would simply inner join, then filtering. Best Regards. On Fri, Feb 21, 2014 at 12:11 PM, David Bicking dbic...@yahoo.com wrote: On Fri, 2/21/14, Igor Tandetnik i...@tandetnik.org wrote: Subject: Re: [sqlite] partially excluding