Invoices

Hallo!

Maybe this is a bit off-topic, as this problem is more a "design"-one, but
I wanted to write a web-application write invoices more easy. I wonder if
it was a good idea to try this using Postgres or if it was better to write
the data of each invoice in a separate file in a separate directory.

I doubt it was a good idea to put all the data into one database like

create table invoices(
  invoice integer primary key,
  datum date,
  customer integer references customers,
  clerk integer references clerks
);
create table invoicedata(
  invoice integer references invoices,
  item integer references services,
);


as this would mean all the information of all invoices is stored in one
table, meaning the table will grow to a HUGE size making queries very
slow.


On the other side I doubt following solution will be a good idea, too!

create table invoices
(
  invoice integer primary key,
  datum date,
  customer integer references customers,
  clerk integer references clerk
);
create table INVOICENUMBER
(
  item integer references services,
  amount integer,
);

as this will create a HUGE number of tables and I think it was not a good
idea to give users permission to create new tables.


Maybe someone can help?


Saluti!

Ludwig