Re: [sqlite] write invoices.... 2 which way??

[Klaus Alexander Seistrup]

On Wed, 9 Mar 2005 16:37:18 -0800 (PST), Clark Christensen
<[EMAIL PROTECTED]> wrote:

> I'll just add that REXX is a good scripting language, and
> coming from the IBM world, Jan may have some familiarity
> with it.  It's open-source, cross-platform,
> Windows-friendly, and a SQLite wrapper is available for it.
>  Check-out http://regina-rexx.sf.net

There's also IBM's ObjectRexx, although I'm not sure there are SQLite
bindings for it:  http://oorexx.sf.net/

Cheers,

-- 
Klaus Alexander Seistrup
SubZeroNet · Copenhagen · Denmark

Re: [sqlite] write invoices.... 2 which way??

[Clark Christensen]

--- Henry Miller <[EMAIL PROTECTED]> wrote:
> 
> 
> On 3/9/2005 at 20:39 Jan Ekström wrote:
> 
> >Clay!
> >Thank you for your answer.
> >Still. I have been programming IBM system 3- AS 400 
> thirty years ago
> or
> >so.
> >I didn't like the IBM prison. I'am struggeling for fresh
> air.
> >I like SQLite very much.
> >I want to put data - preferably validated data -  in my
> sqlite
> database.
> >Then work with the data and finaly get the result out on
> paper.
> >Later perhaps I want to try the same with MYSQL and php.
> >All in open source inviroment.
> >But for now. Where can I find C and C compiler - if C is
> right - or
> >another
> >suitable tole for my efforts.
> 
> There are far too many correct answers to this question
> for me to start
> listing them.   You need to evaluate the options and
> decide.
> 
> Nearly all open source OSes come with gcc installed,
> which is a plenty
> good C/C++ compiler.  If yours doesn't have it, or make
> it really easy
> to install then you are likely looking at the wrong
> distribution.   (I
> haven't used any that don't have it)   See the
> documentation to your
> package manager.
> 
> C is great for low level, performance at any price work. 
>  It is a pain
> for quick and dirty code, and leaves a lot of room to
> shoot yourself in
> the foot if you are not careful.  This is the price you
> pay for power,
> it might or not be worth it.   The way you ask the
> question I'm going
> to guess that you are not a C expert, so I would recomend
> you avoid C
> when you can.However remember that when the going
> gets tough you
> might need to drop into C where everything is hard, but
> at least if it
> can be done C can do it.
> 
> I recomend you use python (www.python.org) as your
> programing language.
>   However sqlite comes with good tcl binding, and tcl is
> nice enough.
> I can't stand perl, but this is a personal thing, you
> need to make your
> own decisions.   Ruby is sometimes mentioned as a good
> general purpose
> scripting language, but I know nothing about it.   Those
> 4 are the main
> open source scripting languages, take your pick.
> 
> I would strongly recomend postgressql over mysql where
> you have a
> choice.  Where you need a simple database sqlite is
> better than mysql,
> where you need a powerful database postgresssql is
> better.  In the
> little middle ground left you will find that mysql still
> isn't enough
> better to bother with.   There is one major exception
> though: mysql is
> used all over and is worth knowing because you might
> encounter it
> again.

I'll just add that REXX is a good scripting language, and
coming from the IBM world, Jan may have some familiarity
with it.  It's open-source, cross-platform,
Windows-friendly, and a SQLite wrapper is available for it.
 Check-out http://regina-rexx.sf.net

FWIW, not being a C programmer, I like perl.  Probably for
the same reasons Henry doesn't like perl :-)

 -Clark

Re: [sqlite] write invoices.... 2 which way??

[Henry Miller]

On 3/9/2005 at 20:39 Jan Ekström wrote:

>Clay!
>Thank you for your answer.
>Still. I have been programming IBM system 3- AS 400  thirty years ago
or
>so.
>I didn't like the IBM prison. I'am struggeling for fresh air.
>I like SQLite very much.
>I want to put data - preferably validated data -  in my sqlite
database.
>Then work with the data and finaly get the result out on paper.
>Later perhaps I want to try the same with MYSQL and php.
>All in open source inviroment.
>But for now. Where can I find C and C compiler - if C is right - or
>another
>suitable tole for my efforts.

There are far too many correct answers to this question for me to start
listing them.   You need to evaluate the options and decide.

Nearly all open source OSes come with gcc installed, which is a plenty
good C/C++ compiler.  If yours doesn't have it, or make it really easy
to install then you are likely looking at the wrong distribution.   (I
haven't used any that don't have it)   See the documentation to your
package manager.

C is great for low level, performance at any price work.   It is a pain
for quick and dirty code, and leaves a lot of room to shoot yourself in
the foot if you are not careful.  This is the price you pay for power,
it might or not be worth it.   The way you ask the question I'm going
to guess that you are not a C expert, so I would recomend you avoid C
when you can.However remember that when the going gets tough you
might need to drop into C where everything is hard, but at least if it
can be done C can do it.

I recomend you use python (www.python.org) as your programing language.
  However sqlite comes with good tcl binding, and tcl is nice enough.
I can't stand perl, but this is a personal thing, you need to make your
own decisions.   Ruby is sometimes mentioned as a good general purpose
scripting language, but I know nothing about it.   Those 4 are the main
open source scripting languages, take your pick.

I would strongly recomend postgressql over mysql where you have a
choice.  Where you need a simple database sqlite is better than mysql,
where you need a powerful database postgresssql is better.  In the
little middle ground left you will find that mysql still isn't enough
better to bother with.   There is one major exception though: mysql is
used all over and is worth knowing because you might encounter it
again.

Re: [sqlite] write invoices.... 2 which way??

[Jan Ekström]

Clay!
Thank you for your answer.
Still. I have been programming IBM system 3- AS 400  thirty years ago or so.
I didn't like the IBM prison. I'am struggeling for fresh air.
I like SQLite very much.
I want to put data - preferably validated data -  in my sqlite database. 
Then work with the data and finaly get the result out on paper.
Later perhaps I want to try the same with MYSQL and php.
All in open source inviroment.
But for now. Where can I find C and C compiler - if C is right - or another 
suitable tole for my efforts.
Sincerely
Jan

- Original Message - 
From: "Clay Dowling" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, March 08, 2005 9:59 PM
Subject: Re: [sqlite] write invoices


Jan Ekström said:
I have created a small sqlite3-database with three tables. When I have
done
my qeuries I want to write invoices based upon my data. In what direction
do
I turn. Where can I find open source free programs for this purpose.
Windows
Home Edition.
Where you turn depends largely on what language you want to use.  If
you're using C, I strongly recommend checking out PDFLib from Thomas
Mertz.  It's a very easy to use little library that lets you generate high
quality PDF files.  PDF files have the advantage of being useful for
printing as well as emailing.  Many businesses like the cost savings of
emailed invoices.
If you're wanting HTML output, my own libtemplate is a good choice for
generating your output (http://www.lazarusid.com/libtemplate.shtml).
Plain text files are also nice for their portability, and printf or your
language's built in facilities for generating formatted text are strongly
to be preferred.
Clay Dowling
--
Lazarus Notes from Lazarus Internet Development
http://www.lazarusid.com/notes/
Articles, Reviews and Commentary on web development

Re: [sqlite] thoughts on a web-based front end to sqlite3 db?

[Dennis Cote]

Richard Heyes wrote:
Since noone has mentioned it yet, I'd suggest Brainfuck 
(http://www.muppetlabs.com/~breadbox/bf/). Very easy to learn (only 
eight instructions) so you should have something up and running pretty 
quickly. Notably, it has some of the most elegant code structure I've 
ever seen.
I know this is a little off topic, but anyone who finds BF interesting 
might also want to consider one of my personal favorites, Whitespace. 
You can get additional information at http://compsoc.dur.ac.uk/whitespace/.

Have fun.