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
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:
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
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:
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
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
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."
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
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
]
> 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
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.
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
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
> -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,
> -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,
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
> -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
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
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
> -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
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
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
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
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?
>
>
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
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?
>
>
>
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,
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
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 &
>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
> -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
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
> -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
> -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
> -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:
> >
>
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
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:
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:
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,
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
>
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
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.
> >>
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
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
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
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
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
>
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.
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.
>
>
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:
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
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,
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:
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
> -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
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
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;
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
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 ?
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:
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
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:
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
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:
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
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
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:
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
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
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'
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
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,
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
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
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
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
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
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
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
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
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
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
: 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
That's all you are suppose to get when querying the Master table for table
names.
You ask how to get a list of tables. That is what you got.
What you are asking for now is more complex.
Try:
Select Name, SQL from "SQLite_master";
for even more fun try:
Select * from "SQLite_master"
Fred
1 - 100 of 199 matches
Mail list logo