--- brodders@cwcom.net wrote:
Hi David!
----- Original Message ----- From: "David Freeman" david_freeman@rocketmail.com
--- brodders@cwcom.net wrote:
=== message truncated ===
First up I needed a model environment, so I put together a box networked to a PC. There's the server, here's the client <this included a big
diversion fighting various Linux distros; they didn't like the ancient embedded video
on
the server>. MySQL goes in, fight with that. Many minor mistakes; finally import
a
test database
- for the other project; but principles established. Install MyODBC
onto the PC; that is a success.
sounds like the usual linux development problems.>?
:)
You know its true :o)
Next up - how to actually do it? I want a RAD or sumfin'.
How about doing it the real way and telneting in and using SQL?
yep that works too; 's how I did the import & initial table setup
etc.
Good, nice to see it being done properly :o)
Access works well via the ODBC, but that's not PC. Hm. StarOffice 5.2! It sort of works and crashes but it's just about usable; snag it it
doesn't
quite fit MySQL nicely.
hmmm?
Subtle unhappynesses which seem to be connected with.. SO5.2 doesn't like base data types used by MySQL, strikes attitudes about keys, crashes when it feels like. Teeters on usable; often just pulls a trick. The MyODBC
drivers
seem fine with SO though. I can fix table layout shenanigans using SQL.. &
my hammer awaits if it needs it's mind changed.
Why not use a sensible system? Why not write the front end in Java and use the JDBC?
At this point I was going to make a start putting some default
forms
together. OK not for the final system; they'll have to be over the web. But these are 1st shot functional screens to get things going; SO5.2 has a GUI editor all drag'n'dropish with predefined stuff (fields, buttons, pull down lists etc) & that's nice esp. when it accesses the remote test MySQL db and I see real data in the fields on my PC. At that point I went on holiday & now it's now.
Have you defined the queries necessary to support the application?
broders wrote: In SQL, no, but have worked up notes giving the expectations (delivered
functionality) for these. Mostly they are obvious add/delete/edit for the main tables apart from reports & the tricky bits - most tricky being the transaction models for requesting & borrowing.
That's why I raise the issues re librarian/peer-peer; these are key process assumptions.
Also don't forget the need to stocktake and do a check on integrity. Stocktake can be done on the fly, ie when an item goes through the hands of a trusted party - the item can be "audited". Another table becons. I imagine the integrity check to er um prove transactions are ordered OK vs datestamp sequence,
run through transactions and prove the items / persons etc tie in and make sense. freemadi wrote:
be careful we could say those working notes are the beginning of a model.
Repeat after me: What is an assumption?
The stocktake will always be a problem when using the peer-to-peer system.
Thanks
D
Thanks! Steve
Be Warned - I'm not a coder (well not in the last 15 years).
Neither am I nor am I a Systems analyis, but I think as a group we
will
muddle through
Thanks
D
Bye Bye for now!
Steve
__________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/