|
|
Posted by Jerry Stuckle on 10/21/12 11:25
Volker Hetzer wrote:
> Mark wrote:
>
>>> apache/oracle/php.
>>
>>
>> Why not apache/mysql/php? My opinion is that using Oracle for web
>> purposes is like using a rifle to kill a fly.
>
> We do have oracle already running, standby database and all and it
> runs other applications too. Especially it holds data we want to access
> from the web interface.
>
>> Looking at my shelf, I just realized that most of my favorites are
>> published by O'Reilly.
>
> Ok.
>
> Any idea about a general intro to web stuff, like html/xml/css
> and such?
>
> Lots of Greetings!
> Volker
Volker,
Don't allow access to your Oracle server through the web, especially if you have
confidential data on it that's not needed by the web. If someone successfully
hacks your system, they not only could have full access to the data in your
Oracle databases, but they could damage them as well.
Rather, replicate only the data necessary to run your website to another
database accessible by the web server (if you're happy with Oracle, that's
fine). Then access that subset from the server.
And if your users update this data from the website (i.e. order entry has to
decrement inventory count), don't just automatically replicate the changes back
to your main database. Rather, have the web site code call a program running on
the Oracle server (or another server behind your firewall). This program should
(again) validate the information and then make the database changes.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|