[ubuntu-za] Database Problems

[Johan Mynhardt]

On 24/01/2010 19:57, Ian Whitfield wrote:
> Thanks to all for the replies.
>
> In reply........
>
> I was sent a link by Hannes Coetzee for the book "How to do everything
> in PHP and MySQL". I have spent today reading it and it seems very good.
> My reservation is using MySQL, now Orical owns it, but it will also work
> with PostgrSQL. Then again Raoul recommends I stay away from PHP!!??
>
PHP is easy yet it enable you to have the power of a king and what you 
say will be done. So sometimes you might do something without knowing 
that it might damage your data.

> Ewald's (and others) suggestion of a Web based solution "rattles" me.
> I'm old school - started with CP/M and DOS!! And putting everything on
> the Web does not "fit" with me and don't get me started on Cloud
> Computing and Web Applications!! This is the worst idea ever to come up
> in the Computer World IMHO.
>
In the current context we/most of us discussed, the "web based" solution 
does not mean something physically on the Internet, but rather that you 
will use a web browser to view and modify your data locally. With any 
web interface you must rely on a client/server model for the server will 
manage your data. "Generally" PHP will have the ability to act as a 
client that connects to your database.

> I seem to think there has to be an answer for this that runs in it's own
> environment. I fully understand the Server/Client structure as explained
> but would be interested in your opinion on which will be better for me,
> Client/Server or just local machine.
>
> I also follow the details of the individual parts needed to put together
> a Linux system and this seems where I'm coming un-stuck. One reply
> mentioned I look for an already built system. I tried this but came up
> with nothing I liked, in fact the only ones that came close were all Web
> based (see my feelings on this above) AND not free! However maybe I'm
> misunderstanding what is being suggested. Is it meant to develop a "Web
> based" front-end BUT only use it as a local application?
>
If you can give this non-free application a name maybe we can suggest 
alternatives :)

> I need a front-end for adding, editing and generally working with my
> data. I'm happy to run queries and reports from outside the front-end.
> In fact the OOBase front-end is perfect - it's the rest of the program
> that is the problem.
>
> Thanks again for all the great input. I will go over the installation
> again and report on the errors I get. As well as working through the
> suggestions given on this list.
>
>
> Ian
>
>
>

Kind Regards

-- 
http://wiki.ubuntu-za.org