RE: [sqlite] Trigger update of multiple columns

2007-06-18 Thread Fred Williams
I think maybe "Normalization" could be one of the best underutilized features of modern database design by most practicing "Database Consultants." Never have I seen such a rule with so many exceptions! Each normalization decision must be prefaced with "It Depends" in every instance. Ah the

RE: [sqlite] Proper way to transfer a live sqlite database

2007-06-18 Thread Fred Williams
It would most likely be much quicker (and simpler) just to utilize the OS's file coping feature to copy the table. What would be gained with the attaching databases approach over just a straight file copy? Fred > -Original Message- > From: Rich Rattanni [mailto:[EMAIL PROTECTED] > Sent:

RE: [sqlite] Suggests for improving the SQLite website

2007-11-09 Thread Fred Williams
For what reason would "non-technical" types need to look on the SQLite website? :-) I kind'a like it the way it is. Plain and simple, with no over wrought graphics and other worthless fluff. It is a website for a very bare bones, plain and simple database. Those who access it are not looking for

RE: [sqlite] Suggests for improving the SQLite website

2007-11-09 Thread Fred Williams
Great idea! Why don't we give them little printable chits for free chips and beer as well?! Just the facts m'am. -- Jack Webb > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, November 09, 2007 5:51 PM > To: sqlite-users@sqlite.org > Subject: Re:

RE: [sqlite] Re: Different between BEGIN, END and "begin transaction", "

2007-11-29 Thread Fred Williams
Actually the first looks like Pascal and the second COBOL (Well, it should be all upper case)... > -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 29, 2007 12:47 PM > To: SQLite > Subject: [sqlite] Re: Different between BEGIN, END and "begin

RE: [sqlite] Should the next release be 3.5.4 or 3.6.0?

2007-12-13 Thread Fred Williams
If you suspect "Group By" also may be broken, why not to an interim "bug fix" release and then do the version number change when both "Order By" and "Group By" are fixed? I seem to remember instances where both Order BY and Group By have given me "unexpected" results. But then again, my logical

RE: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-15 Thread Fred Williams
This discussion reminds me of another long, long ago in a galaxy far, far away. (When I worked on "Mainframes" with 32 K or less "core" memory.) Discussing the then lopsided world with my non-IBM salesman, in a local watering hole, after a particularly trying day of dealing with "management."

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Fred Williams
A hundred or so Visual Basic programmers are cheaper to replace and "maintain" than one good Delphi/C++ programmer. ;-) That is the reason management likes "Visual ." Been there, learned that. Hire the staff from the largest pool, not the most effective. Besides it's damn hard to be a

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Fred Williams
myself :) > > -- > Eric Pankoke > Founder / Lead Developer > Point Of Light Software > http://www.polsoftware.com/ > > -- Original message -- > From: "Fred Williams" <[EMAIL PROTECTED]> > > A hundred or so Visual Basic p

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDeviceSQL?

2007-12-17 Thread Fred Williams
] > Sent: Monday, December 17, 2007 6:16 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite. Anyone heard > ofDeviceSQL? > > > James Steward wrote: > > On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: > > > >> A hun

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread Fred Williams
It's the ones who never figure out how little they know that do all the damage... Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 6:22 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite.

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread Fred Williams
sunderstanding...I mean - right off the > forklift. I'm sure > > anyone with the proper motivation can learn to program, but > it took me > > 25 years to realize how little I really knew. > > I didn't write the original about forklift operators. It was Fred > Williams, AFAI

RE: [sqlite] database column attributes

2007-12-21 Thread Fred Williams
Answers in line. > -Original Message- > From: arbalest06 [mailto:[EMAIL PROTECTED] > Sent: Friday, December 21, 2007 9:23 AM > To: sqlite-users@sqlite.org > Subject: [sqlite] database column attributes > > > > good day! > > i want to create a database with a table that has a column which

RE: [sqlite] "always-trim" - feature suggestion

2008-01-09 Thread Fred Williams
> -Original Message- > From: Zbigniew Baniewski [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 09, 2008 11:08 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] "always-trim" - feature suggestion > > > On Wed, Jan 09, 2008 at 11:25:01AM -0500, Rob Sciuk wrote: > > > You know,

RE: [sqlite] Re: "always-trim" - feature suggestion

2008-01-09 Thread Fred Williams
> -Original Message- > From: Aristotle Pagaltzis [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 09, 2008 1:27 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Re: "always-trim" - feature suggestion > > > * Zbigniew Baniewski <[EMAIL PROTECTED]> [2008-01-09 18:15]: > > On Wed,

RE: [sqlite] SQLite --> PostGres

2008-01-11 Thread Fred Williams
I like the idea of keeping SQLite strictly SQL Standard compliant. With strict compliance one has a very strong and highly transportable development platform to migrate a finished application to any SQL Standard compliant database. If all those vendor specific SQL Standard "extensions" are

RE: [sqlite] Next Version of SQLite

2008-01-14 Thread Fred Williams
> -Original Message- > From: Nicolas Williams [mailto:[EMAIL PROTECTED] > Sent: Monday, January 14, 2008 10:29 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Next Version of SQLite > > > On Sun, Jan 13, 2008 at 08:46:03PM -0600, Rick Langschultz wrote: > > I was wondering what

Re: [sqlite] Updatable views

2008-02-12 Thread Fred Williams
I agree very much with your suggestion. Although all those vendor specific "extensions" generally make the designers and coders lives easier, the wheels tend to come off in onerous ways when a heavily extended project migration is attempted. Even when using a given vendor's product I have, based

RE: [sqlite] SQLite Vs VistaDB - Comparison ???

2006-06-16 Thread Fred Williams
I suggest we don't pick Access/Jet MDB as our shining example of SQLite's future Borland's old, dead, and gone Paradox was Access' main reason to come into existence. Inspire of outliving Paradox, only because of marketing reasons, Access has never been able to leapfrog or even measure up to old

RE: [sqlite] Re: problem with creating a table

2006-06-25 Thread Fred Williams
> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Sunday, June 25, 2006 10:19 AM > To: SQLite > Subject: [sqlite] Re: problem with creating a table > > > Bijan Farhoudi > wrote: > > A. Pagaltzis wrote: > >> SELECT [order] FROM foo > >> > > But how would

RE: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Fred Williams
I would guess from the drift of things, you really should be working at learning the database language "SQL" and not "learning" SQLite. SQLite is only one of a multitude of modern relational databases which use SQL as their language of choice for their user interface. Actually using SQLite once

RE: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Fred Williams
Then how 'bout letting me know the next time you see a market "bubble" coming? :-) > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Friday, July 07, 2006 8:53 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] i have a few Qs - sqlite3 > > > ??? I am in

RE: [sqlite] i have a few Qs - sqlite3

2006-07-08 Thread Fred Williams
I think with that last one you best witch to some other database. I fear you will get no help here. Your lack of command of the English language does not excuse your extremely misaligned mind. No one on the face of this planet would place me in the "politically correct" crowd, but this last

RE: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Fred Williams
What language are you using? Can't you do a dynamic array? > -Original Message- > From: John Newby [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 13, 2006 7:37 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How do you find out the names of the > fields within > a table? > >

RE: [sqlite] How do you find out the names of the fields within a table?

2006-07-13 Thread Fred Williams
Did not realize he was using VB when I sent my last message. I'd bet VB still can't do anything dynamic. That's only one of the reasons I walked away from VB's "Daddy" (Quick Basic) years ago. > -Original Message- > From: Martin Jenkins [mailto:[EMAIL PROTECTED] > Sent: Thursday, July

RE: [sqlite] locked implies exception?

2006-07-24 Thread Fred Williams
Good Grief! Everybody knows CRUD is what you clean off on US Navy ships at least once a week. > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 10:32 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] locked implies exception? > > >

RE: [sqlite] IO Access Time

2006-08-01 Thread Fred Williams
Using an SQL engine to drive a relatively small database is not really very simple, IMHO. But you will notice I am a member of the SQLite fan club for some time now. My largest dataset is somewhere just over 10K rows. I justify using SQLite by noting the advantage of using a well maintained,

RE: [sqlite] converting a sqlite table to dbf

2006-08-29 Thread Fred Williams
Kind'a like chucking your Pentium 5 and going back to scratching on the cave wall with a rock, Eh? I'd export the tables to a CVS files using something like SQLiteAdmin.exe. Open the CVS files with Excel and save the resulting spreadsheets as .DBF files (My Excel has a choice of DBASE II

RE: [sqlite] converting a sqlite table to dbf

2006-08-29 Thread Fred Williams
Damn acronyms anyhow! Thanks. > -Original Message- > From: Jay Sprenkle [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 29, 2006 6:47 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] converting a sqlite table to dbf > > > On 8/29/06, Fred Williams &

RE: [sqlite] Re: two questions about formatting output

2006-08-29 Thread Fred Williams
>From experience. Most "free form" output routines I have used utilizes the content of the first row to establish the width of "columns." (i.e. Reflected in the result per your "Administrative Assistant") If you can "throw away" your first row of output, you could insert a first row in your

RE: [sqlite] Re: Re: Re: Which API to use to get resultant of query

2006-09-15 Thread Fred Williams
> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Friday, September 15, 2006 10:27 AM > To: SQLite > Subject: [sqlite] Re: Re: Re: Which API to use to get > resultant of query > > > sandhya <[EMAIL PROTECTED]> wrote: > > But where as when i am executing the

RE: [sqlite] The term "flat-file" as applied to sqlite

2006-09-25 Thread Fred Williams
Unless you have a very funny shaped disk drive all the files are "Flat" :-) I tend to agree stating SQLite is a "Flat file" somewhat oversimplifies things to me as my definition of a "flat file" is a simple sequential set of data written in no particular order and retrievable only by opening the

RE: [sqlite] import syntax and null values

2006-10-02 Thread Fred Williams
> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Monday, October 02, 2006 9:26 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] import syntax and null values > > > Rich Shepard wrote: > > On Mon, 2 Oct 2006, Eric Matthew Finnin wrote: > > > >> Could

RE: [sqlite] import syntax and null values

2006-10-02 Thread Fred Williams
> -Original Message- > From: Gerry Snyder [mailto:[EMAIL PROTECTED] > Sent: Monday, October 02, 2006 12:42 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] import syntax and null values > > > Fred Williams wrote: > > Would it not be more logical

RE: [sqlite] import syntax and null values

2006-10-02 Thread Fred Williams
> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Monday, October 02, 2006 1:44 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] import syntax and null values > > > Fred Williams wrote: > > >

RE: [sqlite] Can anyone recommend some ISAM db to me?

2006-10-08 Thread Fred Williams
Well there's always XBase. Old, solid, widespread. But, I doubt XBase will be that much different overhead, and complexity wise. SQLite is really hard to beat for its intended purpose. And as far as superior implementation, I have never seen an XBase implementation that can even come close to

RE: [sqlite] new sqlite-based webserver

2006-10-09 Thread Fred Williams
What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Not going to stir much interest with response times like that! > -Original Message- > From: G√ľnter Greschenz [mailto:[EMAIL PROTECTED] > Sent: Monday, October 09, 2006 12:04 PM > To:

RE: [sqlite] IS there some way of viewing an SQLite Database?

2006-11-04 Thread Fred Williams
Or, simply look here for a whole range of selections. http://www.sqlite.org/cvstrac/wiki?p=ManagementTools I currently prefer SQLiteAdmin.exe Fred > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, November 04, 2006 3:58 PM > To:

RE: [sqlite] SELECT on empty fields ??

2006-11-27 Thread Fred Williams
That is why everything in the world is not painted grey. There are those of us who find null values distinct and meaningful and those who don't. I personally prefer null (Unknown, etc.) values versus contrived values which in effect mean I don't like dealing with nulls so here's a blank string,

RE: [sqlite] Dealing with dates in the format yyyymmdd

2006-12-03 Thread Fred Williams
Is there a reason you can use Excel's "Format Cells" to accomplish what you wish? Enter a "Custom" format of "\mm\dd" in a cell and enter "=today()" as a value in that cell. Have not fooled with Excel much lately, but I think you can even format a spreadsheet programmatically. Fred >

RE: [sqlite] Dealing with dates in the format yyyymmdd

2006-12-03 Thread Fred Williams
h Excel and I have tried that but it doesn't work. > I find the only reliable way to put dates in Excel is to put > the integer > Excel date in like for example 39054 and then set the date > format in the > sheet. > > RBS > > -Original Message- > From: Fred Williams

RE: [sqlite] Dealing with dates in the format yyyymmdd

2006-12-03 Thread Fred Williams
date storage format based on an > epoch way > >>>back in antiquity so that you can present it in any > national format. > >>> > >>>Using the internal format date comparison is just a > numeric compare, > >>>which is efficient. > >>

RE: [sqlite] Query generation

2006-12-06 Thread Fred Williams
Pusedo code: set s.sql = 'select a from mytable where (b=0)'; if got.more then set s.sql = s.sql + ' and ' + s.userinput; ... set s.sql = s.sql + ';'; > -Original Message- > From: Lloyd [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 07, 2006 2:46 AM > To: sqlite-users@sqlite.org

RE: [sqlite] Interbase to SQLite

2006-12-07 Thread Fred Williams
well, now that you have one of the most powerful development platforms in the known universe installed, study up a bit (won't require much) on the "VCL" concept. There are VCL's available for both Interbase and SQLite. Install them and sail on... Or, if you are an old "C" coder break out the

RE: [sqlite] Interbase to SQLite

2006-12-09 Thread Fred Williams
t: RE: [sqlite] Interbase to SQLite > > > OK, I think I get it now. > There is no ready made dll, but I have to write one in C or C++. > Trouble is I only know VB/VBA, so not too easy then. > > RBS > > > -Original Message- > From: Fred Williams [mailto:[EMAIL PR

RE: [sqlite] multiple order by value bug?

2006-12-12 Thread Fred Williams
I also have an issue with "Order By" with one of my queries as well. I am doing a multi field Order By and the second of the two fields does not sort in the correct order. I do not have the code in front of me, so can't supply any details. I have been killing bigger alligators on that

RE: [sqlite] Question about SQLite for Symbian

2006-12-21 Thread Fred Williams
Just looked and my old link to the Symbian/Borland C++ link is gone. THere is a new link to something called "Carbide C++" Must be "Ford Tough." Anyhow, here's the link: http://www.forum.nokia.com/info/sw.nokia.com/id/fd975c95-4c71-4ec2-ad1d- 338f52156503/Carbide_cpp_Express.html >

RE: [sqlite] calculate age

2006-12-23 Thread Fred Williams
Unfortunately our Congress seems to have a short memory, on top of constantly appearing embarrassingly stupid and crooked as a snake. I remember the last time they messed with DST. Seems little Yankee school munchkins were being squashed by school buses in the resulting early morning darkness.

RE: [sqlite] ETA for SQLite 3.3.9 ?

2006-12-23 Thread Fred Williams
If it ain't broke, don't "fix" it? > -Original Message- > From: Joe Wilson [mailto:[EMAIL PROTECTED] > Sent: Saturday, December 23, 2006 12:33 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] ETA for SQLite 3.3.9 ? > > > it's been a while since 3.3.8. > >

RE: [sqlite] ETA for SQLite 3.3.9 ?

2006-12-25 Thread Fred Williams
Sounds like an assumption is being made that the sqlite.h file will always be present. Never have received the *.h file without downloading the source, which most wrapper users never do. And most likely don't want to know what an *.h file is anyway. Fred > -Original Message- > From:

RE: [sqlite] Using sqlite.exe

2006-12-30 Thread Fred Williams
Don't know why you are using the "backdoor" approach (Calling the SQLite.exe module) accessing an SQLite database from Delphi, but you might want to look at what these people have to offer: www.aducom.com I have been using their components for a while now and have been quite happy with the

RE: [sqlite] sqlite performance, locking & threading

2006-12-30 Thread Fred Williams
Been following this a while... You have access to the source, and apparently are a "threading genius." Please make the required minor changes and post a link here so we can all benefit. Fred > -Original Message- > From: Emerson Clarke [mailto:[EMAIL PROTECTED] > Sent: Saturday,

RE: [sqlite] sqlite performance, locking & threading

2007-01-06 Thread Fred Williams
Sounds like a H-- of a plan to me! I'll call Larry Ellison and warn him to put the 12 meter yacht up for sale, he's about to get steam rolled! :-) Fred > -Original Message- > From: Bill King [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 06, 2007 1:15 AM > To:

RE: [sqlite] Sqlite Preprocessor

2007-01-11 Thread Fred Williams
Or my contempt of code generators in general :-) Fred > -Original Message- > From: Ken [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 11, 2007 12:46 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Sqlite Preprocessor > > > I think the fact that sqlite is typeless actually

RE: [sqlite] How to conditionally drop a table?

2007-01-25 Thread Fred Williams
> -Original Message- > From: G. Roderick Singleton [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 25, 2007 12:06 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] How to conditionally drop a table? > > > On Thu, 2007-01-25 at 11:13 -0600, John Stanton wrote: > > If you find a

RE: [sqlite] Limit statement size?

2007-01-28 Thread Fred Williams
Wow! Talk about obfuscated code! I didn't even try to dig deeper than a quick scan, but could this abomination be broken into multiple update queries? On the surface it looks like each "group" is unique. If so, wouldn't a transaction with multiple update statements be much more efficient and a

Re: [sqlite] [Delphi7] TEXT vs. (VAR)CHAR?

2008-03-04 Thread Fred Williams
You might want to test a little further with Aducom's stuff. I'm using Aducom and have the following working code in at least one app: begin AList.Fields.FieldByName(FldName[j+1]).Value := Trim(ExtractData(RS)); if RP >= Length(RS) then break; end;

Re: [sqlite] Populating and scrolling the Listbox using query

2008-04-14 Thread Fred Williams
Might want to download the free source for the Delphi VCL set for Sqlite DB access componenets provided at Aducom.com and review the releven source code. Sorry, it is written that highly "inelegant" Object Pascal. But I'm an old "C" coder from way back and do read and write Object Pascal more so

Re: [sqlite] Delphi dbExpress driver for SQLite3 ?

2008-04-22 Thread Fred Williams
Try this: http://www.aducom.com/sqlite/ You can dump DBExpress completely. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of LacaK Sent: Tuesday, April 22, 2008 2:15 AM To: sqlite-users@sqlite.org Subject: [sqlite] Delphi dbExpress driver for SQLite3 ?

Re: [sqlite] Virtual tables declaration statements

2008-05-05 Thread Fred Williams
Don't think that will happen. "Dot" notation is used as in "databasename.tablename" and is therefore a restricted use notation. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Aladdin Lampe Sent: Monday, May 05, 2008 8:57 AM To:

Re: [sqlite] transaction recovery question

2008-06-03 Thread Fred Williams
That's why I continue to monitor SQLite messages even when I'm not actively developing with SQLite. There is an inherent entertainment value that appears built in. Over time I'm certain I have been guilty of posting some shall we say "entertaining" messages myself. Sometimes I think SQLite is

Re: [sqlite] SQL understanding problem

2008-06-26 Thread Fred Williams
If all the collum contents are identical why should it matter wich one is modified? Just do a select ... Limit 1 subquery in the update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of c.panel Sent: Thursday, June 26, 2008 4:57 PM To:

Re: [sqlite] Proposed removal of (mis-)feature

2008-08-07 Thread Fred Williams
Henceforth and forward: Let the standards violator suffer his just rewards!" :-) Dr., your just trying to supply the worlds greatest database, not take a bunch of slovenly coders to raise... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of D. Richard Hipp

Re: [sqlite] 2 Questions from a newbie

2008-08-19 Thread Fred Williams
Third normal says: Table: Stock ID Integer Primary Key, Symbol Varchar(n), ... Other stuff Table: DaylyPrice (I'd call it "Price") StockID Integer (Foreign key:

Re: [sqlite] 2 Questions from a newbie

2008-08-19 Thread Fred Williams
1. Third Normal, as in "Database normalization." (Database 101) No offence intended, you said you are a beginner. 2. Right. My "unlimited" stock and prices advantage. No creating a table for each new stock. No creating a table or adding columns (Both time and logically intensive.) for

Re: [sqlite] Entity Relationship Diagram Tool for SQLite

2008-09-03 Thread Fred Williams
What is so unique to SQLite that it would require its very own Entity Relationship engine? Relational databases are relational databases. Granted some are "more" relational than others, but that is where the designer's mind is required to function above a video game level. Fred -Original

Re: [sqlite] best language match for SQLite?

2008-09-16 Thread Fred Williams
I haven't met a real programmer since I wrote my last TASM program quite a few years ago. :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of palmer ristevski Sent: Tuesday, September 16, 2008 11:19 AM To: General Discussion of SQLite Database Subject: Re:

Re: [sqlite] Vista frustrations

2008-09-17 Thread Fred Williams
Possibly the reason a large number of us are still running Win 2000 :-) It seems to be the least Windows like Windoze ever released... When follow on support degrades to an untenable level, I'll either switch to Linux with a Windoze emulator or maybe run whatever the future ruler of the Universe

Re: [sqlite] Vista frustrations

2008-09-17 Thread Fred Williams
Have you ever actually used a version of Windows? ANY OS that attempts to read in a xGigibyte file into real memory to the detriment of the entire system load is not working correctly. Call it a bug or a feature it still sucks. I expect nothing less from Microsoft with each new version. I

Re: [sqlite] Vista frustrations

2008-09-18 Thread Fred Williams
Is a sad day when an application program is forced to compensate for pitiful OS design and performance :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Simpson Sent: Thursday, September 18, 2008 10:31 AM To: 'General Discussion of SQLite Database'

Re: [sqlite] Vista frustrations

2008-09-18 Thread Fred Williams
r, Molly is no longer handling the cache manager. I believe she has moved back into the kernel group after a brief departure, but is working on something else. I haven't seen the talks that Robert refers to, but suspect they are close to the versions I have seen in person. I would bet they are still v

Re: [sqlite] seeking storage design assistance

2008-10-01 Thread Fred Williams
One rule used in basic systems design is: Define the input, define the output, and the rest will become obvious. If only it were that simple:-) But, a point to ponder. Fred -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Godfrey Sent: Wednesday,

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Fred Williams
Should not the GENERAL.ID be enclosed in double quotes? Or did I misread the SQL Standard? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of D. Richard Hipp Sent: Tuesday, January 27, 2009 8:06 AM To: General Discussion of

Re: [sqlite] SELECT issue with SQLite 3.6.10

2009-01-27 Thread Fred Williams
Subject: Re: [sqlite] SELECT issue with SQLite 3.6.10 On Jan 27, 2009, at 10:08 AM, Fred Williams wrote: > > Should not the GENERAL.ID be enclosed in double quotes? Or did I > misread > the SQL Standard? You can use double-quotes to conform to the SQL standard. But SQLite also all

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

2009-02-22 Thread Fred Williams
Since the dawn of digital computers the CPU has been waiting on the I/O. Want to go faster? Get a faster mass storage device. Then your CPU usage will most likely jump all the way up to 9% - 14%! You can't believe what a 300 card per minute 80 column card reader does to throughput when you use

Re: [sqlite] Windows XP: How Can I Get Higher CPU usage from SQLite

2009-02-23 Thread Fred Williams
That's the reason in memory databases are so fast. If a DB is small enough you can spool the whole thing into RAM on open and spool it back out on close. If you are attempting to use the DB in any kind of multi user environment client system large cache sizes are going to play H--- with

Re: [sqlite] sqlite programmed in C++

2009-06-02 Thread Fred Williams
I figure the only reasons it is written in C is for portability and Assembler programming is a bitch! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of P Kishor Sent: Tuesday, June 02, 2009 10:36 AM To: General Discussion of

Re: [sqlite] sqlite programmed in C++

2009-06-03 Thread Fred Williams
Well said! C++ provides the average programmer "automated" Object Orientation, or better stated, good programming practices, at a price. A good C programmer can equal and most times exceed the results of a C++ programming project. As previously stated C is really just a lazy man's Assembler, and

Re: [sqlite] Db design question (so. like a tree)

2009-06-04 Thread Fred Williams
Nothing to do with relational databases, but if you are developing for a future animal husbandry environment I would plan on supporting clones. Like it philosophically or not. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of

Re: [sqlite] Topics 1 - Re: sqllogictest tool - please help :-)

2009-06-10 Thread Fred Williams
I think your problems have nothing to do with SQLite, yet. To begin you need some help related to the "C" programming language. The three files you have listed are the "Make", "Source" and "Header" files for a C program. You must compile these to develop an executable program. Once you have

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
Is this a violation of SQL Standards? Seems like it should be. I'm not for dumbing down the system to compensate for the occasional idiot programmer. After all, we are not the government, nor should we strive to act like it (IMHO). If someone chooses to attempt to create a

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
Is this a violation of SQL Standards? Seems like it should be. I'm not for dumbing down the system to compensate for the occasional idiot programmer. After all, we are not the government, nor should we strive to act like it (IMHO). If someone chooses to attempt to create a

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Igor Tandetnik Sent: Tuesday, June 16, 2009 10:57 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams <f.willi...@verizon.net> wrote: > Is this a violation of SQL

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
To: sqlite-users@sqlite.org Subject: Re: [sqlite] Datatypes (D. Richard Hipp) Fred Williams <f.willi...@verizon.net> wrote: > What! The standard is lacking? Will wonders never cease? > > Thanks, you saved me from some boring reference reading. > > Still think, logically sp

Re: [sqlite] Datatypes (D. Richard Hipp)

2009-06-16 Thread Fred Williams
6, 2009 12:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Datatypes (D. Richard Hipp) On 16 Jun 2009, at 5:32pm, Fred Williams wrote: > Still think, logically speaking, the construct should throw an error > message, rather than make stealth changes to the expected re

Re: [sqlite] [Columns] Keeping internal + beautified names?

2009-07-14 Thread Fred Williams
For overall performance and efficiency, I recommend you keep the "pretty" in the GUI where such things are traditionally implemented. Pick two of three: "COOL, Fast, Tight." Fred -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Fred Williams
Reminds me of the old days BTW (Before The Web) when the News Net's main recreation was "C" language curly brackets formatting flame wars :-) I was kind'a wondering what on earth is so complicated in SQLite that would take an entire book to cover? Is it a thin book? How 'bout big print for us

Re: [sqlite] The SQL Guide to SQLite

2009-07-19 Thread Fred Williams
Ahhh! The price of using the company e-mail :-) "Mustang Vineyards" is willing to let the world receive and store for all posterity edification and benefit, the sage ramblings in every message! Read on you lucky masses! :-) Fred No company disclaimer attached. -Original Message- From:

Re: [sqlite] Installing SQLite

2009-07-23 Thread Fred Williams
I think you guys are most likely feeding a Troll, or the original poster might ought to contact his IS support department, or enroll in some introductory basic home computer continuing education courses in his local area. -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Installing SQLite

2009-07-23 Thread Fred Williams
That might be an option to consider. But, I think there might be a rather small number of potential SQLite users interested. I would think the group with the greatest benefit of that kind of package would be students and serious rookies. Most users I feel either pre possess the required

Re: [sqlite] .lib file?

2009-07-25 Thread Fred Williams
Paul, If you wish I can send yoou a SQLite3.lib file I just generated using my old Borland C++ Builder 5 Lib utility. Can't attach it here so contact me: fwillia...@gmail.com And I'll attach it to a reply. Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] .lib file?

2009-07-25 Thread Fred Williams
r, for that matter, .obj) files created by Borland compilers are not compatible with the Microsoft toolchain, and vice-versa. Borland uses a variant of the OMF object format, and Microsoft uses a variant of COFF. On 07/25/2009 08:09 PM, Fred Williams wrote: > Paul, > > If you wish I can send yoou a S

Re: [sqlite] .lib file?

2009-07-25 Thread Fred Williams
te.org] On Behalf Of Fred > Williams > Sent: Saturday, July 25, 2009 4:44 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] .lib file? > > Hum. So Mickeysoft does not supply a lib converter/creator utility? I even > have a "Make" and "Grep&qu

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-01 Thread Fred Williams
Hummm... Guess there is a reason there are no implementations of C# external to the Mickeysoft world :-) Guess if I had a lot of time to kill I could port it to Delphi... BTW, what's the memory footprint? Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-01 Thread Fred Williams
version to be faster. I don't know the background of why this programmer did a port directly to C# instead of binding C# to the existing C library, but I assume he had his reasons. - Original Message - From: "Fred Williams" <f.willi...@verizon.net> To: "General Discussi

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-02 Thread Fred Williams
und of why this programmer did a port directly > to C# instead of binding C# to the existing C library, but I assume he > had his reasons. > > - Original Message - > From: "Fred Williams" <f.willi...@verizon.net> > To: "General Discussion of SQLite Da

Re: [sqlite] ANN: SQLite 3.6.16.C#

2009-08-02 Thread Fred Williams
Thank you for your understanding. And best of luck with XXLite? I know you have a large captive audience out there. It is the only reason I swallow my pride and admit knowledge of the most pervasive OS currently on the planet. Not the "best" technically, but best "marketed." Fred

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-11 Thread Fred Williams
Having had the unfortunate opportunity to use a couple of language translators as well as spending about six fruitless months developing one which in the end was no better, I say there is no known translation that would allow the three SQLite, "Small, Fast, Reliable" adjectives to translate into

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-12 Thread Fred Williams
inns Sent: Wednesday, August 12, 2009 12:09 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLJet - pure Java implementation of SQLite -BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Fred Williams wrote: > I say there is no known translation that > would allow the three SQLi

Re: [sqlite] SQLJet - pure Java implementation of SQLite

2009-08-12 Thread Fred Williams
translate the object code. It's also possible to translate bytecode (for example, from Java to .NET). - Original Message - From: "Fred Williams" <f.willi...@verizon.net> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Wednesday,

  1   2   3   >