[sqlite] typeless in sqlitedataset?

[Xuer]

i'm using sqlitedataset (http://sqlitedataset.sourceforge.net/cms/) for
c++ programming.
when i use function get_fType() to retrieve the filed_value datatype, it
always is 0,which means string.

is there a problem? and how could i tell the 1 is char "1" or integer 49?


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Adding and subtracting decimals is not accurate

[Gerry Snyder]

Randall Fox wrote:
After reading the FAQ and type information over, I went and tried the
following:
CREATE TABLE M (A numeric, B text);
INSERT INTO M VALUES (1.2);
INSERT INTO M VALUES (1.2);
INSERT INTO M VALUES (1.2);
.
.
 ; did this about 45 times
.
.
SELECT SUM(A) FROM M;
result was 52.8001

Is there a work around to accurately add fixed point numbers? 
You mean like rounding once in a while to the number of significant 
decimal places? Once every few billion additions like those above should 
suffice.

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Adding and subtracting decimals is not accurate

[Randall Fox]

After reading the FAQ and type information over, I went and tried the
following:

CREATE TABLE M (A numeric, B text);
INSERT INTO M VALUES (1.2);
INSERT INTO M VALUES (1.2);
INSERT INTO M VALUES (1.2);
.
.
 ; did this about 45 times
.
.
SELECT SUM(A) FROM M;

result was 52.8001

Defining the field as text made no difference, and in fact the best
way was to put in the number without the decimal, to guarantee it will
be treated as an integer (i think) instead of a float.  But this could
be confusing to the end user who doesn't understand the details of
floating point arithmetic..

Is there a work around to accurately add fixed point numbers?   Or
more generally, has this been addressed before?  I couldn't find any
reference to it on the FAQ or web site.. 

This problem becomes more obvious when the 1.2 is interpreted as $1.20

Thank you

Randall Fox

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Join query help

[Kurt Welgehausen]

>  select customers.*, ctots.total
>  from customers,
>   (select customer_id cid, sum(invoice_amount) total
>from invoice_master group by cid) ctots
>  where customers.customer_id = ctots.cid

You're right -- sorry, I wan't paying attention.

For 'customers, (subquery) where' substitute
'customers left join (subquery) on', and
for 'ctots.total' subsitute 'coalesce(ctots.total, 0.00)'.

select customers.*, coalesce(ctots.total, 0.00)
from customers left join
 (select customer_id cid, sum(invoice_amount) total
  from invoice_master group by cid) ctots
on customers.customer_id = ctots.cid

Regards

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[rene]

Hi,

no, i didn't realize that. both personal and at my payed job we still use delphi5..

this licensing issues makes it for us as independent R partner far to expensive to 
upgrade
development tools on a frequent base.. i've been begging for a new delphi for ages now.

ironically, one of our partners, the local university/research center(last one as 
commercial) are
allowed academic licenses. that is not too bad, but also they have an agreement with 
brussels
that they can calculate 'external' tarives for the job done, whereas private sector 
(we, it's R
but considered commercial) can only bring real salaries in expense.. so, the academics 
get
double (make that triple or quadruple) profits, where we are glad to get 40% paid...

anyhow, that's all off-topic.. but it's true it bites me that collegues at the 
institute have their
delphi 7 enterprise for about $35, while we're stuck to delphi 5 since we simply 
cannot afford
the updates.

rene

Op vrijdag, juni 4. 2004 20:40:07 schreef "Shawn Anderson" <[EMAIL PROTECTED]> :
> You do realize that you do not need BDE anymore to just use the TDataSet,
> right?  Borland got rid of that requirement about 2 years ago (Around Delphi
> 6), if memory serves :)
>
> Other than that, I agree, the free edition is a totally acceptable choice.
>
> Shawn
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 04, 2004 1:59 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: [sqlite] re: academic software licensing (delphi)
>
> "you get to use all of the great database functionality that Borland's VCL
> offer"
>
> unless of course you think borland's data-aware components aren't so great..
> imho, they are just unnecessary overhead, making things more complex than
> they should and limit you in usage of features that makes particulair sql
> databases so great.
> i agree that for vcl apps they may be ok, but as soon as 95% of your apps
> database interventions has nothing to do with user interaction, it is just a
> waist of resources and lines of code.
>
> there are several wrappers for sqlite available for delphi, which indeed may
> take some initial learning time instead of dropping some components on a
> form, but the results are there. i use sqlite in some dll's for example, i
> must not even think about having clients to install the BDE. in one app i
> need every bit of speed sqlite can offer, and even that is hardly enough
> (did some caching where possible, but even then sqlite is very rapidly a lot
> faster than your own non-indexed lookup table)..
>
> it entirely depends on the type of app you build, but even where i have
> user-forms filling some database content, i prefer to do it manually because
> you are far more flexible, and most of the time there are special conditions
> or checks that would be impossible (or very tough) to implement if all
> controls were data-aware.
>
> but, even if you favour data-aware, there is no need at all to use delphi or
> kylix professional editions. ZEOS components let you have data-aware (and
> borland-compatible) components that will work in the personal editions. I
> did not verify if they implement sqlite yet, but i bet they did and else
> they probably will do so soon.
>
> just my 2 cents..
>
> rene
>
> Op vrijdag, juni 4. 2004 17:50:01 schreef "Shawn Anderson"
> <[EMAIL PROTECTED]> :
> > Yes, but it you right the component around TdataSet you get to use all
> > of the great database functionality that Borland's VCL offers, as well
> > as tons of 3rd party components.
> >
> > Shawn
> >
> > -Original Message-
> > From: Jay Macaulay [mailto:[EMAIL PROTECTED]
> > Sent: Friday, June 04, 2004 11:34 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [sqlite] re: academic software licensing (delphi)
> >
> > > hi-
> > >
> > > i dont think delphi 7 personal edition will work with sqlite (not
> > > 100% sure though).
> > > i believe i need more than a tdataset that works with sqlite to get
> > > it to work with delphi 7 personal edition.
> > > there is an alternative however. http://ibobjects.com seems to be
> > > very generous with licensing of the products for a hobbyist as long
> > > as you abide by NOT writing commercial software.
> > > It looks like exactly what i was
> > > searching for.  I will write the company and see if i can get the
> > > special license.  Only thing is i will be using firebird if i go
> > > this route instead. They have a nice brand new manual at amazon (800
> > > pages) on firebird databases.
> > >  
> >
> > Just a quick note, you don't need a TDataSet to use sqlite.  In fact I
> > avoid TDataSet because I have no need for everything it offers.  I
> > just wrote my own code around the sqlite.dll and then wrote a
> > component around that to make it a bit more robust.  Basically the
> > same way you'd do it in C.  Delphi is a great language to learn if you
> > want to write up some quick apps in windows/linux.  If you're looking
> > to 

Re: [sqlite] Join query help

[Mitchell Vincent]

Very nice, however that still only gives me the customer records if they 
have an invoice in the invoice_master table..

A sub-select or outer join or something of the sort is needed but I 
can't get it to work..

In PostgreSQL I might do :
SELECT *,(SELECT sum(total) FROM invoice_master WHERE 
invoice_master.customer_id = customers.customer_id) as total FROM customers;

However I can't get that beast to work in SQLite.
Many thanks!
Kurt Welgehausen wrote:
...get all customers records, plus the sum of a column in the invoice...

The idea is to get customer_id and the sum from the invoice table,
then join that with the rest of the customer info.  Of course, if
you want to do it in one SQL statement, you have to write those
steps in reverse order:
 select customers.*, ctots.total
 from customers,
  (select customer_id cid, sum(invoice_amount) total
   from invoice_master group by cid) ctots
 where customers.customer_id = ctots.cid
If this doesn't make sense to you, try using a temporary table:
 create temp table ctots (cid integer primary key, total float)
-- or whatever types are appropriate
 insert into ctots select customer_id, sum(invoice_amount)
   from invoice_master group by customer_id
 select customers.*, ctots.total
 from customers, ctots
 where customer_id = cid
Regards
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[Shawn Anderson]

You do realize that you do not need BDE anymore to just use the TDataSet,
right?  Borland got rid of that requirement about 2 years ago (Around Delphi
6), if memory serves :)

Other than that, I agree, the free edition is a totally acceptable choice.

Shawn

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 04, 2004 1:59 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [sqlite] re: academic software licensing (delphi)

"you get to use all of the great database functionality that Borland's VCL
offer"

unless of course you think borland's data-aware components aren't so great..
imho, they are just unnecessary overhead, making things more complex than
they should and limit you in usage of features that makes particulair sql
databases so great.
i agree that for vcl apps they may be ok, but as soon as 95% of your apps
database interventions has nothing to do with user interaction, it is just a
waist of resources and lines of code.

there are several wrappers for sqlite available for delphi, which indeed may
take some initial learning time instead of dropping some components on a
form, but the results are there. i use sqlite in some dll's for example, i
must not even think about having clients to install the BDE. in one app i
need every bit of speed sqlite can offer, and even that is hardly enough
(did some caching where possible, but even then sqlite is very rapidly a lot
faster than your own non-indexed lookup table)..

it entirely depends on the type of app you build, but even where i have
user-forms filling some database content, i prefer to do it manually because
you are far more flexible, and most of the time there are special conditions
or checks that would be impossible (or very tough) to implement if all
controls were data-aware.

but, even if you favour data-aware, there is no need at all to use delphi or
kylix professional editions. ZEOS components let you have data-aware (and
borland-compatible) components that will work in the personal editions. I
did not verify if they implement sqlite yet, but i bet they did and else
they probably will do so soon.

just my 2 cents..

rene

Op vrijdag, juni 4. 2004 17:50:01 schreef "Shawn Anderson"
<[EMAIL PROTECTED]> : 
> Yes, but it you right the component around TdataSet you get to use all 
> of the great database functionality that Borland's VCL offers, as well 
> as tons of 3rd party components.
> 
> Shawn
> 
> -Original Message-
> From: Jay Macaulay [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 04, 2004 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] re: academic software licensing (delphi)
> 
> > hi-
> >
> > i dont think delphi 7 personal edition will work with sqlite (not 
> > 100% sure though).
> > i believe i need more than a tdataset that works with sqlite to get 
> > it to work with delphi 7 personal edition.
> > there is an alternative however. http://ibobjects.com seems to be 
> > very generous with licensing of the products for a hobbyist as long 
> > as you abide by NOT writing commercial software.
> > It looks like exactly what i was
> > searching for.  I will write the company and see if i can get the 
> > special license.  Only thing is i will be using firebird if i go 
> > this route instead. They have a nice brand new manual at amazon (800 
> > pages) on firebird databases.
> >  
> 
> Just a quick note, you don't need a TDataSet to use sqlite.  In fact I 
> avoid TDataSet because I have no need for everything it offers.  I 
> just wrote my own code around the sqlite.dll and then wrote a 
> component around that to make it a bit more robust.  Basically the 
> same way you'd do it in C.  Delphi is a great language to learn if you 
> want to write up some quick apps in windows/linux.  If you're looking 
> to distribute source code, then the most universally known language would
be C obviously.
> 
> 
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Join query help

[Kurt Welgehausen]

> ...get all customers records, plus the sum of a column in the invoice...

The idea is to get customer_id and the sum from the invoice table,
then join that with the rest of the customer info.  Of course, if
you want to do it in one SQL statement, you have to write those
steps in reverse order:

 select customers.*, ctots.total
 from customers,
  (select customer_id cid, sum(invoice_amount) total
   from invoice_master group by cid) ctots
 where customers.customer_id = ctots.cid

If this doesn't make sense to you, try using a temporary table:

 create temp table ctots (cid integer primary key, total float)
-- or whatever types are appropriate

 insert into ctots select customer_id, sum(invoice_amount)
   from invoice_master group by customer_id

 select customers.*, ctots.total
 from customers, ctots
 where customer_id = cid


Regards

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[rene]

"you get to use all of the great database functionality that Borland's VCL offer"

unless of course you think borland's data-aware components aren't so great.. imho, 
they are just
unnecessary overhead, making things more complex than they should and limit you in 
usage of
features that makes particulair sql databases so great.
i agree that for vcl apps they may be ok, but as soon as 95% of your apps database
interventions has nothing to do with user interaction, it is just a waist of resources 
and lines of
code.

there are several wrappers for sqlite available for delphi, which indeed may take some 
initial
learning time instead of dropping some components on a form, but the results are 
there. i use
sqlite in some dll's for example, i must not even think about having clients to 
install the BDE. in
one app i need every bit of speed sqlite can offer, and even that is hardly enough 
(did some
caching where possible, but even then sqlite is very rapidly a lot faster than your own
non-indexed lookup table)..

it entirely depends on the type of app you build, but even where i have user-forms 
filling some
database content, i prefer to do it manually because you are far more flexible, and 
most of the
time there are special conditions or checks that would be impossible (or very tough) to
implement if all controls were data-aware.

but, even if you favour data-aware, there is no need at all to use delphi or kylix 
professional
editions. ZEOS components let you have data-aware (and borland-compatible) components 
that
will work in the personal editions. I did not verify if they implement sqlite yet, but 
i bet they did
and else they probably will do so soon.

just my 2 cents..

rene

Op vrijdag, juni 4. 2004 17:50:01 schreef "Shawn Anderson" <[EMAIL PROTECTED]> :
> Yes, but it you right the component around TdataSet you get to use all of
> the great database functionality that Borland's VCL offers, as well as tons
> of 3rd party components.
>
> Shawn
>
> -Original Message-
> From: Jay Macaulay [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 04, 2004 11:34 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] re: academic software licensing (delphi)
>
> > hi-
> >
> > i dont think delphi 7 personal edition will work with sqlite (not 100%
> > sure though).
> > i believe i need more than a tdataset that works with sqlite to get it
> > to work with delphi 7 personal edition.
> > there is an alternative however. http://ibobjects.com seems to be very
> > generous with licensing of the products for a hobbyist as long as you
> > abide by NOT writing commercial software.
> > It looks like exactly what i was
> > searching for.  I will write the company and see if i can get the
> > special license.  Only thing is i will be using firebird if i go this
> > route instead. They have a nice brand new manual at amazon (800 pages)
> > on firebird databases.
> >  
>
> Just a quick note, you don't need a TDataSet to use sqlite.  In fact I avoid
> TDataSet because I have no need for everything it offers.  I just wrote my
> own code around the sqlite.dll and then wrote a component around that to
> make it a bit more robust.  Basically the same way you'd do it in C.  Delphi
> is a great language to learn if you want to write up some quick apps in
> windows/linux.  If you're looking to distribute source code, then the most
> universally known language would be C obviously.
>
>
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Database Locking

[Pix]

I'm  using SQLite on a Windows XP system with 1GB of RAM. I'm writing a 
server  which spawns multiple threads for it's connections. It is 
querying and  writing to an SQLite database within each thread. Whenever 
a query or  insert/update statement is issued, the SQLite database is 
opened,  queried/written to, and closed again. When a bunch of queries 
come in  (about 10 in a second, for instance), SQLite reports that the 
database is  locked despite my setting the sqlite_busy_timeout to 150 or 
so. Certain  database writes thus do not take place, which is a major 
problem. If I  detect when my call returns SQLITE_BUSY and sleep for a 
while (about 100  ms) and re-try the call, it continuously says that the 
database is  locked.

Try setting a bigger busy_timeout... I think that 150 is too small... 
maybe about 1000 it is better to set a bigger timeout than set a 
small timeout and call many Sleep().

Are you sure you finalize your queries?
I'm using the CppSQLite Wrapper in an application where I've many 
threads accessing the DB but I never had your problem... I think that 
the problem is in your implementation...

Paolo

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Database Locking

[WeiChin3]

 
In a message dated 6/4/2004 11:53:05 AM Eastern Daylight Time,  
[EMAIL PROTECTED] writes:

I'm  using SQLite on a Windows XP system with 1GB of RAM. I'm writing a 
server  which spawns multiple threads for it's connections. It is 
querying and  writing to an SQLite database within each thread. Whenever 
a query or  insert/update statement is issued, the SQLite database is 
opened,  queried/written to, and closed again. When a bunch of queries 
come in  (about 10 in a second, for instance), SQLite reports that the 
database is  locked despite my setting the sqlite_busy_timeout to 150 or 
so. Certain  database writes thus do not take place, which is a major 
problem. If I  detect when my call returns SQLITE_BUSY and sleep for a 
while (about 100  ms) and re-try the call, it continuously says that the 
database is  locked.



I have an application basically does the same thing and retry after  
SQLITE_BUSY works like a champ. So I would say the problem is not sqlite but  your 
implementation. Maybe you can post your busy-retry code so I can take a  look and 
make suggestion?
 
Wei
 

[sqlite] Join query help

[Mitchell Vincent]

So I'm sitting here in a pinch and my brain just refuses to work...
2 tables, a customer and an invoice table. What is the proper SQL to get 
all customers records, plus the sum of a column in the invoice table 
with a relation on the customer ID, but not all customers might have an 
invoice record..

Something like
SELECT *,sum(im.total) as total FROM customers AS c, invoice_master as i 
WHERE i.customer_id = c.customer_id GROUP BY c.customer_id;

Except that, of course, means that every customer has to have a record 
in the invoice table or they won't show in the list. I just want 0 to 
show for total for those customers that don't have a record in the 
invoice table.

Much appreciation up front as I know this is probably one of those "duh" 
kinds of questions..

-- Mitchell
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] SQLite::DB Perl Module Released

[Vitor]

Folks,

I an sharing, through CPAN, one perl module that provides an object oriented
wrapper to SQLite databases using DBI and DBD::SQLite modules.

http://search.cpan.org/~vxx/SQLite-DB-0.02/lib/SQLite/DB.pm

Please feel free to send me feedbacks of it.

Regards,

Vitor


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] palm pilot

[nathanvi]

Il giorno Wed, 2 Jun 2004 05:31:21 -0700 (PDT), tu oh prode Jalil Vaidya
<[EMAIL PROTECTED]> hai scritto una mail.
Il suo oggetto era"Re: [sqlite] palm pilot":

> There is a PalmOS port of SQLite available. Mr. Wayne
> on this list kindly sent me the code of his work on
> the Palm port. I have not tested it on Palm Vx but I
> do believe it works(Mr. Wayne can correct me if I am
> wrong). I am working on Palm OS 6 port of SQLite but
> haven't been able to get far as my dev machines either
> keep crashing (for some totally different reasons) or
> they get utilized for something else. When will I be
> able to complete the port is an eternal question ;-)
> Let me know if you need the code.



I think it is a good idea to put the code and put a link in wiki as
Puneet Kishor said.
I have Palm OS 3.5
Do you think sqlite may work fine?

Thanks




-- 
**
The UNIX Guru's view of sex:
unzip; strip; touch; finger; mount; fsck; more; yes; umount; sleep

**
L'unica accelerazione possibile per windows:  (9.81 m/s2)


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Database Locking

[Richard Boehme]

I'm using SQLite on a Windows XP system with 1GB of RAM. I'm writing a 
server which spawns multiple threads for it's connections. It is 
querying and writing to an SQLite database within each thread. Whenever 
a query or insert/update statement is issued, the SQLite database is 
opened, queried/written to, and closed again. When a bunch of queries 
come in (about 10 in a second, for instance), SQLite reports that the 
database is locked despite my setting the sqlite_busy_timeout to 150 or 
so. Certain database writes thus do not take place, which is a major 
problem. If I detect when my call returns SQLITE_BUSY and sleep for a 
while (about 100 ms) and re-try the call, it continuously says that the 
database is locked.

Any help would be appreciated.
Thank you.
Richard Boehme
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[Shawn Anderson]

Yes, but it you right the component around TdataSet you get to use all of
the great database functionality that Borland's VCL offers, as well as tons
of 3rd party components.

Shawn 

-Original Message-
From: Jay Macaulay [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 04, 2004 11:34 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] re: academic software licensing (delphi)

> hi-
>
> i dont think delphi 7 personal edition will work with sqlite (not 100% 
> sure though).
> i believe i need more than a tdataset that works with sqlite to get it 
> to work with delphi 7 personal edition.
> there is an alternative however. http://ibobjects.com seems to be very 
> generous with licensing of the products for a hobbyist as long as you 
> abide by NOT writing commercial software.
> It looks like exactly what i was
> searching for.  I will write the company and see if i can get the 
> special license.  Only thing is i will be using firebird if i go this 
> route instead. They have a nice brand new manual at amazon (800 pages) 
> on firebird databases.
>  

Just a quick note, you don't need a TDataSet to use sqlite.  In fact I avoid
TDataSet because I have no need for everything it offers.  I just wrote my
own code around the sqlite.dll and then wrote a component around that to
make it a bit more robust.  Basically the same way you'd do it in C.  Delphi
is a great language to learn if you want to write up some quick apps in
windows/linux.  If you're looking to distribute source code, then the most
universally known language would be C obviously.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] re: academic software licensing (delphi)

[Jay Macaulay]

> hi-
>
> i dont think delphi 7 personal edition will work with sqlite (not 100%
> sure though).
> i believe i need more than a tdataset that works with sqlite to get it
> to work with delphi 7 personal edition.
> there is an alternative however. http://ibobjects.com seems to be very
> generous with licensing of the products
> for a hobbyist as long as you abide by NOT writing commercial software.
> It looks like exactly what i was
> searching for.  I will write the company and see if i can get the
> special license.  Only thing is i will be using
> firebird if i go this route instead. They have a nice brand new manual
> at amazon (800 pages) on firebird databases.
>  

Just a quick note, you don't need a TDataSet to use sqlite.  In fact I avoid
TDataSet because I have no need for everything it offers.  I just wrote my
own code around the sqlite.dll and then wrote a component around that to
make it a bit more robust.  Basically the same way you'd do it in C.  Delphi
is a great language to learn if you want to write up some quick apps in
windows/linux.  If you're looking to distribute source code, then the most
universally known language would be C obviously.




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[Fred Williams]

Or do it with Klix and get platform portability :-)

> -Original Message-
> From: Shawn Anderson [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 04, 2004 9:22 AM
> To: [EMAIL PROTECTED]
> Subject: RE: [sqlite] re: academic software licensing (delphi)
> 
> 
> Question:  Why not use the totally free version of C++Builder and just
> create a VCL component for SQLite -- the VCL component can then 
> be used from
> either C++ Builder or Delphi.
> 
...


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[Shawn Anderson]

Question:  Why not use the totally free version of C++Builder and just
create a VCL component for SQLite -- the VCL component can then be used from
either C++ Builder or Delphi.

Shawn

-Original Message-
From: Fred Williams [mailto:[EMAIL PROTECTED] 
Sent: Friday, June 04, 2004 10:18 AM
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] re: academic software licensing (delphi)

With personal edition of Delphi, you will have to rely on third party
software to gain some of the functionality of the more expensive versions.
With personal edition you should have all you need to develop an API level
interface to SQLite, if you wish to remain totally "free."

If you have any past programming experience, you will be doing productive
work with Delphi long before two years.  I'd guess two to three months if
your not in a hurry.  API interface development may take a little longer.

Should you wish to go professional an upgrade to Delphi Professional will
only cost you 300 - 400 dollars.  When I quit professional development that
was about an afternoon's work revenue, if I took off a little early :-)

Fred

> -Original Message-
> From: jim mcnamara [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 04, 2004 5:26 AM
> To: [EMAIL PROTECTED]
> Subject: [sqlite] re: academic software licensing (delphi)
>
>
> hi-
>
> i dont think delphi 7 personal edition will work with sqlite (not 100% 
> sure though).
> i believe i need more than a tdataset that works with sqlite to get it 
> to work with delphi 7 personal edition.
> there is an alternative however. http://ibobjects.com seems to be very 
> generous with licensing of the products for a hobbyist as long as you 
> abide by NOT writing commercial software.
> It looks like exactly what i was
> searching for.  I will write the company and see if i can get the 
> special license.  Only thing is i will be using firebird if i go this 
> route instead. They have a nice brand new manual at amazon (800 pages) 
> on firebird databases.
>
> I will see if i can go this route.  I dont know if i can pull it off.
> Nothing beats sqlite and its tcl bindings for ease of use that i have 
> ever ran across.  I will have lots to learn and it wont be easy 
> (pascal language, code specific to delphi, ibo components, and 
> firebird).  It will take about 2 years of learning before I probably 
> get the hang of it (if ever).
>
> thanks for everyones advice.
>
> goodbye,
> jim
>


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] re: academic software licensing (delphi)

[Fred Williams]

With personal edition of Delphi, you will have to rely on third party
software to gain some of the functionality of the more expensive versions.
With personal edition you should have all you need to develop an API level
interface to SQLite, if you wish to remain totally "free."

If you have any past programming experience, you will be doing productive
work with Delphi long before two years.  I'd guess two to three months if
your not in a hurry.  API interface development may take a little longer.

Should you wish to go professional an upgrade to Delphi Professional will
only cost you 300 - 400 dollars.  When I quit professional development that
was about an afternoon's work revenue, if I took off a little early :-)

Fred

> -Original Message-
> From: jim mcnamara [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 04, 2004 5:26 AM
> To: [EMAIL PROTECTED]
> Subject: [sqlite] re: academic software licensing (delphi)
>
>
> hi-
>
> i dont think delphi 7 personal edition will work with sqlite (not 100%
> sure though).
> i believe i need more than a tdataset that works with sqlite to get it
> to work with delphi 7 personal edition.
> there is an alternative however. http://ibobjects.com seems to be very
> generous with licensing of the products
> for a hobbyist as long as you abide by NOT writing commercial software.
> It looks like exactly what i was
> searching for.  I will write the company and see if i can get the
> special license.  Only thing is i will be using
> firebird if i go this route instead. They have a nice brand new manual
> at amazon (800 pages) on firebird databases.
>
> I will see if i can go this route.  I dont know if i can pull it off.
> Nothing beats sqlite and its tcl bindings for ease
> of use that i have ever ran across.  I will have lots to learn and it
> wont be easy (pascal language, code specific to
> delphi, ibo components, and firebird).  It will take about 2 years of
> learning before I probably get the hang of it
> (if ever).
>
> thanks for everyones advice.
>
> goodbye,
> jim
>


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] re: academic software licensing (delphi)

[jim mcnamara]

hi-
 
i dont think delphi 7 personal edition will work with sqlite (not 100%
sure though).
i believe i need more than a tdataset that works with sqlite to get it
to work with delphi 7 personal edition.
there is an alternative however. http://ibobjects.com seems to be very
generous with licensing of the products
for a hobbyist as long as you abide by NOT writing commercial software.
It looks like exactly what i was
searching for.  I will write the company and see if i can get the
special license.  Only thing is i will be using
firebird if i go this route instead. They have a nice brand new manual
at amazon (800 pages) on firebird databases.
 
I will see if i can go this route.  I dont know if i can pull it off.
Nothing beats sqlite and its tcl bindings for ease
of use that i have ever ran across.  I will have lots to learn and it
wont be easy (pascal language, code specific to
delphi, ibo components, and firebird).  It will take about 2 years of
learning before I probably get the hang of it
(if ever).
 
thanks for everyones advice.
 
goodbye,
jim

RE: [sqlite] sorry for the confusion re: academic software

[jim mcnamara]

 http://www.polsoftware.com/

hi eric-

thank you for the ideas.  i will have fun picking out software used to
design more software.  i already am investigating sqlite for delphi on
sourceforge to see if it works with delphi personal 7 edition.  i have
two questions posted to a sourceforge forum inquiring about it.  it is
easy to just go plop down 1000 on the cadillac version of some software
and know it will work but i like sorting through the bins and coming up
with a decent tool and save money.  to be honest the expensive software
has way more features then i need and i'd never end up using all those
features anyways.

btw i think that your scorch product is a really neat idea.

i will check back in this forum after i select new design software and
get busy writing.

thanks- goodbye