Re: [sqlite] "select disctict" calles tcl functions twice?

) ) to create the result, instead of just using the already computed values in the Ephemeral table. Is it possible to fix this so that functions that have side effects or are time consuming to compute are called only once? John On Feb 28, 2011, at 6:08 PM, John wrote: > > That doesn't reall

Re: [sqlite] "select disctict" calles tcl functions twice?

That doesn't really make any sense. I'm not calling "fun" from the tcl body, just in the select statement. It didn't make any difference either. Any Ideas? John On Feb 28, 2011, at 8:49 AM, Black, Michael (IS) wrote: > I think your problem may be that fun() in your eval is

[sqlite] "select disctict" calles tcl functions twice?

Hi All, In my example code here the function "fun" is called twice for each row. The first set of calls is made in the initial evaluation of the sql statement, then "fun" is called again as the tcl body is evaluated for each row. I wasn't expecting

Re: [sqlite] Sqlite management

please give a suggestion? > The big question is what will you offer that is not available on the currently available opensource or free tools? John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Can't delete a row

I now have the script running as required on the remote server, apart from a couple of creases I'd like you to help me iron out. What I unwittingly held back, and which you would have picked up on straight way, was my connect routine, to which I added "{ RaiseError => 1, AutoCommit => 0 }"

Re: [sqlite] Can't delete a row

Google mail seems to have chosen a convenient moment to go AWOL. I wrote: print qq~\$q{BUTTON} was: $q{BUTTON}~; if ($q{BUTTON} =~ s~^Delete[^\d]+~~i){ print qq~\$q{BUTTON}=$q{BUTTON}~; ###my $rows = $dbh->do("DELETE FROM contacts WHERE rowid = $q{BUTTON}"); my $sth =

Re: [sqlite] Can't delete a row

On 28 January 2011 16:37, I wrote: > Once I 'd deleted the second line it did work in the standalone > script.  But the duplication is not in the cgi version.  Nevertheless > now I am assured that it does work, I've just got to find what silly > mistake I've made in the main script.  I already

Re: [sqlite] EXTERNAL:Re: Can't delete a row

At 11:33 -0600 28/01/2011, Puneet Kishor wrote: > > Why would you do this rather than use $dbh->do ? It seems to add a >> line of code to no purpose. > >Because I find using bind values easier, clearer, and safer, even for >one-off execute statements. Well, that makes sense. > > And

Re: [sqlite] EXTERNAL:Re: Can't delete a row

At 11:08 -0600 28/01/2011, Puneet Kishor wrote: >Can't really say what you are doing wrong, but you code is needlessly >complicated; all those tildes are making my eyes swim. I also have difficulty interpreting escaped toothpicks, and I didn't joint the sqlite list to have my Perl style

Re: [sqlite] Can't delete a row

At 16:44 + 28/01/2011, Black, Michael (IS) wrote: >Me thinkst you need to put singled quotes around $q{BUTTON}. > >my $rows = $dbh->do("DELETE FROM contacts WHERE rowid =\'$q{BUTTON}\'"); SInce the statement is in double quotes I surely wouldn't want to escape the single quotes, but, as I

Re: [sqlite] Can't delete a row

On 28 January 2011 16:19, Simon Slavin wrote: > I strongly suspect that your value for $q{BUTTON} is wrong.  Can you add a > diagnostic like to display it ? Yes, I realised immediately after posting that I had duplicated the substitution in the stand-alone script so

[sqlite] Can't delete a row

I thought I was making a bit of progress but I've come up against a brick wall trying to do what appears to be the most simple thing. A button pressed in the page to delete a selected record is stripped of its display name to become simply the rowid. When I run the statement in the sqlite

Re: [sqlite] Getting a table's field labels with Perl, DBI

At 22:41 -0800 25/01/2011, Darren Duncan wrote: >How long have you been using Perl? > >Anyway, to start with I would replace the last couple lines with: > >my $catalog_rowset = $dbh->selectall_arrayref("PRAGMA >table_info(contacts)") ; >my @col_names = map { $_->[1] } @{$catalog_rowset};

Re: [sqlite] Getting a table's field labels with Perl, DBI

Hello John Delacour...nice to see you join the SCLite list. Folks, John may be a SCLite beginner, but he has quite a reputation on the MacScript list. I personally am glad to see him here. R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite

[sqlite] Getting a table's field labels with Perl, DBI

I've only been using SQLite for 5 days so I'm very much a beginner. I just spent an hour or so working out how to get a list of column headers from a table and come up with the script below, which will do fine, but I wonder if there's a more elegant way to do it. #!/usr/local/bin/perl use

Re: [sqlite] how to speed up this ?

On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane <svandercl...@yahoo.fr> wrote: > that very very much expensive :( how much you thing ? > $500 to $600 US. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:

Re: [sqlite] how to speed up this ?

> i m affraid so ... but what it's will be with 50 000 000 rows ? i don't > have 100 gigabytes of memory :( I would get a 256GB SSD. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Troubleshooting...

Thank you Igor. That explanation makes sense. And it fits all the information I had collected. R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Igor Tandetnik > Sent: Monday, December 20, 2

[sqlite] FW: Troubleshooting...

ables.txt sqlite> select * from Names; ( It was this field) V 1||µàäµ╣▓µ▒Ñ|JohnDarnell, John||0|1|0 2||µàäµ╣▓µ▒Ñ|John|A|M||Darnell, John A M||0|1|0 3||µòäµà¼µò«|PatrickDelaney, Patrick||0|1|0 4||µàìµ╜│Γ╡«µàäµ╣▓µ▒Ñ|ToddMason-Darnell, Todd||0| 5||Θëŵ╜äµæ╖|WilliamOÆDowd, Wi

Re: [sqlite] Troubleshooting...

Thank you for the reminder, Mr. Archer. The basic_string is actually stored as part of a STL map and is fairly long-lived; once it is created, it remains until the plugin's destructor clears the map. R, John > -Original Message- > From: sqlite-users-boun...@sqli

Re: [sqlite] Troubleshooting...

then that could have been my problem. I hope I have answered all of your questions. As far as I am concerned, my problem is solved so unless you have some new insight that will greatly speed my program or enhance efficiency, you do not have to respond to this email. R, John > -Origi

Re: [sqlite] Troubleshooting...

e.txt Select * from Names; When I went to the root of C: I did not find the file. So I removed the path from the filename and later found it in the SQLLite directory from which I was running the shell. R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailt

Re: [sqlite] Troubleshooting...

Pavel, I really appreciate you hanging with me on this subject. I can sometimes be a bit thick and your patience in dealing with my situation is greatly appreciated. The data I am using is a very small set of names pulled from an InDesign document text frame. They look like this: John

Re: [sqlite] Troubleshooting...

to the insert statement: idx = -1; idx = sqlite3_bind_parameter_index(ResultStmt, ":disp"); sqlite3_bind_text(ResultStmt, idx, CurrentName -> second.GetDisplayName().c_str(), -1, SQLITE_STATIC); //sqlite3_bind_text(ResultStmt, idx, "Smith, John Jacob

Re: [sqlite] Windows performance problems associated with malloc()

On Fri, Dec 17, 2010 at 3:12 PM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Dec 17, 2010 at 2:27 PM, John Drescher <dresche...@gmail.com> wrote: > >> > >> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. >> > >> That is visual st

Re: [sqlite] Windows performance problems associated with malloc()

> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. > That is visual studio 2010 runtime. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Troubleshooting...

Thanks, Pavel. I will do this. R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Pavel Ivanov > Sent: Friday, December 17, 2010 9:22 AM > To: General Discussion of SQLite Database > Su

Re: [sqlite] beginner

r 17, 2010 9:01 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] beginner > > On Fri, Dec 17, 2010 at 08:42:54AM -0600, john darnell scratched on the wall: > > > I am learning SQLite based on the O'Reilly book by Jay Kreibich, > > called &q

Re: [sqlite] beginner

Hello Srindhi: From one SQLite beginner to another... SQLite and SQL are two different subjects. So you need to clarify for yourself what you want to do. Do you want to learn SQL? Then there are a number of good books you can get from Amazon to help you learn, and there are a number

Re: [sqlite] Troubleshooting...

table). Is there some setting within SQLite3 that I should be manipulating to provide me UTF8 output? The last four fields lead me to believe that my problem may be up front, on input. They accurately reflect the values that I am storing. The only difference between them and the earlier field

[sqlite] Troubleshooting...

statement that the Insert statement did not work. Once I bind the data to the Insert statement, how can I look at the final statement to see what I have done wrong when the statement does not work? R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also

Re: [sqlite] SQLite Documentation v2

> Indeed, Windows Explorer. > > Please investigate the options in the popup menu (maybe you should > choose "Properties" first and then look in the dialog box... I'm not > sure). It has to be there :) > > -- > Regards, > Serge Igitov

Re: [sqlite] SQLite Documentation v2

r, then click "Unblock") - thanks to Luuk34 for the tip. > >> > > Stupid question I know, but you did mean Windows Explorer, did you not? Anyway, stupid question or not, when I right-click the file in Windows Explorer, I see no option to unblock. I'm using XP SP3. Is there another option? R, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] enums

> -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Dagdamor > Sent: Tuesday, December 07, 2010 12:46 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] enums > >

Re: [sqlite] enums

Thanks for the information, Max. R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Max Vlasov > Sent: Tuesday, December 07, 2010 12:15 PM > To: General Discussion of SQLite Database > Subject: Re: [s

[sqlite] enums

Is there any way to build an SQLite table that recognizes enums? It's a lot easier to understand at data that looks like this: kHard kSoft kAlt kSoft kSoft kHard than this: 1 2 3 2 2 1 R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also be reached

[sqlite] creating a database

Okay, I seem to have figured it out. One needs to create the database and then add a table before the database will be created. Sorry for the baby steps. R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also be reached at johnamdarn...@gmail.com

[sqlite] Creating a database.

Enter SQL statements terminated with a ";" sqlite> I quit out of the SQLite shell and looked for test.db and did not find it. So my question remains. How do I create a database? R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also be re

Re: [sqlite] Just compiled SQLite in Visual Studio

Thanks Igor. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, November 29, 2010 7:11 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Just compiled SQLite in Visual Studio john darnell

Re: [sqlite] Just compiled SQLite in Visual Studio

Thanks, Simon. I'll take your advice. Oh and BTW, I apologize for the "Mac truck" remark--I meant no offense to my friends who code for the Mac (grin). R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] >

[sqlite] Just compiled SQLite in Visual Studio

any errors. Is it really that easy, or am I about ready to be hit by a Mac truck filled with bugaboos? R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also be reached at johnamdarn...@gmail.com<mailto:johnamdarn...@gmail.com> Trivia SF questio

Re: [sqlite] sqlite3 question

Also what's your journal_mode and synchronous setting? ( http://www.sqlite.org/pragma.html#pragma_synchronous) Depending on how these are set, if your application terminates early, or system crashes, you will likely corrupt your DB. 2010/10/30 Martin Engelschalk >

Re: [sqlite] Multilple tables with the same schema and prepare query performance

tables used by the query. > > > Pavel > > On Fri, Oct 29, 2010 at 11:52 AM, john Papier <johnpap...@gmail.com> > wrote: > > Hi, > > > > I need to create multiple tables all having the same schema. The > > number/names of the tables will by dynamic.

Re: [sqlite] Multilple tables with the same schema and prepare query performance

eed an explcity ORDER BY, which would make the query more expensive. On Fri, Oct 29, 2010 at 9:11 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 29 Oct 2010, at 4:52pm, john Papier wrote: > > > The thing is, I need to keep a cursor to where in the > > table I was las

[sqlite] Multilple tables with the same schema and prepare query performance

Hi, I need to create multiple tables all having the same schema. The number/names of the tables will by dynamic. There would be somewhere in the order of 10 to 100 of these tables. When doing operations on these tables, I want to avoid having to do a prepare_query every time for performance

Re: [sqlite] Run Time Error #1 in VS2008

le: > >        char c = (i & 0xFF); > > Changing the code in this way will not affect the quality of the resulting > optimized code. > > > > Is this a common Multibyte versus Unicode error issue? > Mixing debug and release? John ___

[sqlite] drop trigger - create trigger leading to malformed database

have not seen a document describing all the functions in the DLL, so I am looking for help determining if there is a more appropriate function to call when dropping a trigger. Thanks in advance for any advice. John ___ sqlite-users mailing list sqlite

[sqlite] Temporary views across attached databases

I see that normal views across attached databases do not work but it looks like I can create a temporary view across attached databases. Is this a supported configuration? I want to make sure before I put this in my application. -- John M. Drescher

Re: [sqlite] Query to compare two sqlite databases

Hello, The following query works for me. select * from db2.table where not exists (select * from db1.table where db1.table.column1 = db2.table.column1); Thanks again for the assistance. --- On Fri, 9/24/10, Oliver Peters wrote: From: Oliver Peters

Re: [sqlite] Query to compare two sqlite databases

Hello, Thanks for your response. I'm almost there but I keep getting sql syntax error (near col1) with the last part of the query where(not exists in db2); Here's where I'm at: select 'db1', db1.table1.col1, 'db2', db2.table2.col1 from db1.table1, db2.table2 WHERE (NOT EXISTS col1 IN db2);

[sqlite] Query to compare two sqlite databases

Hello, I compare an application every few days which has sqlite as it's client database. I look at the content and check whether documents have made it into the application after it has been built. I also check the metadata in the sqlite client database for changes. So, I am constantly

[sqlite] Searching in multiple tables .

Hi, I'm very beginner in SQL query syntax and my problem is : I have a database that contains several objects and their properties. Each object has it's own table where its properties are stored ( TEXT Keyword, REAL Value ). So, in each table we find Keywords such as : Weight, Length, Cost,...

[sqlite] Re Populating a database from a file

Thanks for the prompt reply. What form should the file take. I've tried enclosing the data for each column in double quotes and separating them with either a comma, tab or space but I get an error "expected 5 columns but only found 1. Using | I get "datatype mismatch" Also when I use .dump does

[sqlite] Populating a database from a file

If I'm using MySQL I can populate a database with "Load data infile '/tmp/data.txt' into table table_1" Is there a similar way of loading data into a sqlite3 database? Thanks ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Sqlite Insert Speed Optimization

> Thanks for all the feedback! > > It helped a lot. > 1. I'm going to try and see what happen if I leave the "end transaction" > until 5 insert was done. This is what I meant also when I said 500 was too small. John ___

Re: [sqlite] Compiling as part of MFC C++ project

> > This is a basic Visual C++ question. > > http://www.delphifaq.com/faq/f923.shtml > Sorry for the noise. I guess I should not try reading mail while playing a flash game in a second window.. John ___ sqlite-users mailing list sqlite-

Re: [sqlite] Compiling as part of MFC C++ project

isual C++ question. http://www.delphifaq.com/faq/f923.shtml John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite Insert Speed Optimization

On Tue, Jul 13, 2010 at 12:48 PM, John Drescher <dresche...@gmail.com> wrote: >> I was wondering if that's really so.  Wouldn't the marginal speed >> improvement be quite small?  Is the percentage of the final rowcount really >> a criterion? > > Each transaction cos

Re: [sqlite] Sqlite Insert Speed Optimization

> I was wondering if that's really so.  Wouldn't the marginal speed improvement > be quite small?  Is the percentage of the final rowcount really a criterion? Each transaction costs at least 1 disk seek. Doing thousands of seeks the result would be very slow.

Re: [sqlite] Sqlite Insert Speed Optimization

ge of a million. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Journal file not locked - problems with virus checkers

ase the journal file exists all the time, so it's not inconceivable that you could keep a file handle open all the time. I guess the other issue is that it returns SQLITE_FULL instead of something more useful. Any thoughts, suggestions? John ___ sqlit

Re: [sqlite] how can i unsubscribe from this forum?

te.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- John M. Drescher ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] normalization example(s)

On 6/25/2010 10:51 PM, Simon Slavin wrote: > > On 26 Jun 2010, at 3:47am, John wrote: > >> I don't know if SQLite now supports foreign keys yet or not. > > So you're posting to a mailing list you don't read ? I read this! ;-) Actually, I did do one project early this yea

Re: [sqlite] normalization example(s)

On 9/26/2009 10:17 PM, John wrote: > I have "The Definitive Guide to SQLite" and it has jump > started me with databases. (the index could stand a lot > of improvement though). > > I am looking for a "quick start" example of the normalization > case where one

[sqlite] Issue with locked journal file

). Although it's surprising that this would happen (as the journal file is in a hidden system directory (e.g. C:\users\john\AppData\Local\MyApp)) I guess badly behaved apps may well briefly open and lock recently changed files. (As an aside, this is clearly an issue the sqlite team have tried

[sqlite] Strange SQLITE_FULL error

ase SQLITE_FULL might actually be because of an IO error which SQLite is incorrectly interpreting? Or if not an IO error, then a system resources problem (I have some other anecdotal evidence to suggest other crashes are related to low system resources). Can anyone concur with this, or suggest other

[sqlite] sqlite connection?

hi all, i'm new to this forum and sqlite. is it possible to have an executable (i.e. .exe) with connections to 2 sqlite databases? i've read doc and it doesn't speak to this one way or the other. thanks, john ___ sqlite-users mailing list sqlite

Re: [sqlite] Fw: SQLite and Windows 7

>> in the near future we will implement windows 7. My question: Is >> SQLite running on windows 7? >> I have been using sqlite under windows 7 for at least 8 months without a single issue. John ___ sqlite-users mailing list sqlite-use

Re: [sqlite] sqlite3_close ==> " library routine called out of sequence"

Forgot to say that the error occurs at the sqlite3_close function. John On Feb 23, 11:17 am, John <mail_ch...@yahoo.fr> wrote: > Hi All, > > The very simple C-code below returns error message " library routine > called out of sequence" . > I really don't underst

[sqlite] sqlite3_close ==> " library routine called out of sequence"

sqlite3_close(db); return; } if( sqlite3_close( db ) != SQLITE_OK ); { wxMessageBox( wxString("Database can not be closed properly !\n\n") << sqlite3_errmsg( db )); return( -1 ); } -

Re: [sqlite] parallelizing an update

be able to do so up to the limit of the cores in the machine or by distributing the load over many machines, however, the implication to me of a long running process is something that is consuming large amounts of CPU time. It is possible that running multiple processes per proc

Re: [sqlite] minor bug in 3.6.22 src tarball Makefile.in

Sorry, mailman stripped the patch from my message. j...@work:~$ cat sqlite_tclsh_freebsd.patch diff -Nur sqlite-3.6.22.orig/Makefile.in sqlite-3.6.22/Makefile.in --- sqlite-3.6.22.orig/Makefile.in 2010-01-04 18:02:40.0 -0600 +++ sqlite-3.6.22/Makefile.in 2010-01-07

[sqlite] minor bug in 3.6.22 src tarball Makefile.in

I realize this tarball and its autotools scripts aren't supported, but I figured I'd share the patch anyway. On my FreeBSD 8 system I don't have a "tclsh" command but I do have "tclsh8.4" and it is detected by configure. ___ sqlite-users mailing list

Re: [sqlite] BUG: the rowid column in view is autom a tically named as id

raints of INTEGER PRIMARY KEY. The behavior does, admittedly, produce a result which does not correspond to expectations and therefore is a possible source of downstream bugs. Perhaps it merits investigation. Personally, I would expect the result: rowid|id 1|I am "id" field But that

Re: [sqlite] SQL question

ite, in which case the suggestion to obtain the extensive knowledge available from books is valid or b. your statement mislead the group by misinforming them as to your state of knowledge. FWIW John ___ sqlite-users mailing list sqlite-users@sqlite.org htt

Re: [sqlite] Commit failing due to DB locked.

Hi Thanks for responding, I've added my comments in below. On Dec 9, 2009, at 11:30 AM, Kees Nuyt wrote: > On Tue, 08 Dec 2009 22:07:34 +0100, John Clayton > <john_clay...@me.com> wrote: > >> Hi >> >> I've got two processes opening up two sqlite databases. Ass

[sqlite] Commit failing due to DB locked.

anyone seen this kind of locking error or have suggestions as to how I could track it down? Thanks -- John Clayton Skype: johncclayton ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The next release of SQLite....

ing VACUUM, in contrast to a usual ROWID. It is unclear here if the FTS3 rowid does or does not change during vacuum. - John Brooks On Thu, Dec 3, 2009 at 4:15 PM, Nicolas Williams <nicolas.willi...@sun.com> wrote: > Use the glob operator. > ___

Re: [sqlite] is ticket 4037 not a bug?

pported by SQLite. IMHO it's a bug (or oversight): C:\Users\John\Documents>sqlite3 test.db3 SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table foo (id integer, value varchar); sqlite> .q C:\Users\John\Docum

Re: [sqlite] Local data structures vs sqlite

implementations rigidly built into many fashionable >languages. I would go crazy if I had to use a language without any structures, objects, or arrays. How could a man LIVE without arrays? Heck, even assembly language has arrays and/or structures (allocate your memory, and use offsets). John

Re: [sqlite] Local data structures vs sqlite

formats. SQLite is far more flexible, and the moment you need to adjust the schema, or and an index, SQLite will immediately become worth it. I wouldn't use SQLite for most in memory data that never needs to be stored on disk, but I STRONGLY recommend SQLite for persistent data. John

Re: [sqlite] in-memory database concept

Hi Serdar, For Solaris, you need: ramdiskadm -a mydisk 2m newfs /dev/rramdisk/mydisk mkdir /mnt/ramDisk mount /dev/ramdisk/mydisk /mnt/ramDisk John -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf

Re: [sqlite] Table within a table??

lobs. If you need to query against the array elements, use a custom function (though, if you need to query against the elements in the array, you should REALLY be using a relational table.) As far as order goes, it is reasonably easy to order the rows using a field for that purpose. John __

Re: [sqlite] User-defined infix functions

In your specific example you could simply define a custom "LIKE" function, and LIKE could become Unicode aware without any goofy new operators. John -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jean-Christophe

Re: [sqlite] feature proposal - strong but dynamic typing

typed SQLite, then Apache is updated to use the latest PHP, finally, one by one, web hosting providers throughout the world update to the latest Apache. And a whole rash of websites suddenly have problems. These sites changed NOTHING, but suddenly their sites don't work? I see SERIOUS problems with this proposal, especially in terms of backwards compatibility. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some clarification needed about Unicode

. For Win2k, only UCS-2 is supported. Starting with XP, the Win32 APIs accept full UTF-16. On any version, MultiByteToWideChar() should return data in the proper encoding for that system. Igor and the others helped hash this through until the real answer could be

Re: [sqlite] Idea for improving page cache

a you tried to attach, but I couldn't because the attachment was blank except for a message footer. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to input a double num?

level, not the SQLite or printf level. You'll need an arbitrary precision math library, sqlite3_bind_blob(), and sqlite3_prepare_v2(). You can't use sqlite3_bind_double() because your number is too big for a double. FYI, those arbitrary precision libraries are brutes, so brace yourself.

Re: [sqlite] feature proposal - strong but dynamic typing

like the current behavior better. Just my 2 cents. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some clarification needed about Unicode

the wide APIs myself, and if I was making a horrible mistake I wanted to know. Besides, I figured the OP would prefer accurate information. Many thanks for making sure I had my facts straight. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to input a double num?

> He's probably measuring the number of atoms in a city or something. LOL. Actually my bet is that field of the project has more to do with number theory. That's the only likely way to get a number that large with such high precision. John ___ sql

Re: [sqlite] Late data typing. Am I missing something?

> Um...how do I go to the page that describes the date-time information > without just 'knowing' it's there? For example, there seems to be no > path to http://www.sqlite.org/lang_datefunc.html from > http://.sqlite.org. I used Google personally. "sqlite date

Re: [sqlite] Some clarification needed about Unicode

ove should (according to Kaplan and Chen) support UTF-16 for API calls. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some clarification needed about Unicode

any reliable documentation on this either way. It would be good if the APIs accept UTF-16, because that would mean they also accept UCS-2, but I couldn't find anything reliable to support this idea. Some folks say yes. Some say no. The documentation says nothing. John -Original Message--

Re: [sqlite] Late data typing. Am I missing something?

, where the strong typing of the API clarifies things. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Some clarification needed about Unicode

to suggest that UCS-2 must be used, however, there is some reason to believe that perhaps UTF-16 is handled correctly as well. Couldn't find anything reliable one way or the other though. (Though there are plenty of folks taking whichever position, so at least I'm not the only one who's confused now.

Re: [sqlite] Some clarification needed about Unicode

ful enhancements as needed. All said it wasn't too bad. This is the route I would recommend. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SELECT * vs SELECT columns ?

added to the schema, but those fields are never used, you sacrifice performance. On the other hand, if fields are added to the schema and you need to use them, you still have to modify the code to retrieve and use the column. Adding the new fields to the query at the same time isn't a big deal.

Re: [sqlite] Some clarification needed about Unicode

like SetWindowText()). Odds are that the only library you are using which supports UTF-16 is SQLite. You should always be converting the text to UCS-2 before you use it. John -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dan

Re: [sqlite] Some clarification needed about Unicode

and you've been passing 8bit strings to SQLite, you may already have a problem, since some of the data stored may be invalid if you attempt to treat it as a UTF-8 string. You may find that you'll need to dump the data, then convert from ASCII to UTF-8 and rebuild the database. John -Origin

<    2   3   4   5   6   7   8   9   10   11   >