I am looking for information and recommendations for a database engine.

We are setting up a relational database system that may reside on a 
database server in the future.

Linux based solution preferred

Something that is easy to set up and back up and restore.
   even a sql sump is ok

I will be using relationships (pk/fk) to keep data straight.

Triggers and stored procedures are a big plus.

The possibility of using GIS functionality int he future will be taken 
into consideration.


What are your thoughts on a good system to use?

Post a reply to this message

Le 14/03/2011 14:57, Tom Austin a écrit :
> I am looking for information and recommendations for a database engine.
> 
> We are setting up a relational database system that may reside on a
> database server in the future.
> 
> Linux based solution preferred

Two main candidates (at least for me)
 - mysql
 - postgresql

Please note that MySQL AB is now owned by Oracle.
Opensource derivative to mysql is mariaDB.

> 
> Something that is easy to set up and back up and restore.
>   even a sql sump is ok

Both can be administered via a web interface for the common usage
(phpmyadmin & phppgadmin)

> 
> I will be using relationships (pk/fk) to keep data straight.
> 
> Triggers and stored procedures are a big plus.

Both have triggers.
Both have stored procedures.

> 
> The possibility of using GIS functionality int he future will be taken
> into consideration.

Both have support for spatial/geometry pieces of information.
Nevertheless, support

> 
> 
> What are your thoughts on a good system to use?

Check for yourself:
> http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

(search for indexes & spatial)
Looks like you might want postgis

Unless you are ready for an oracle DB ?

-- 
Software is like dirt - it costs time and money to change it and move it
around.

Just because you can't see it, it doesn't weigh anything,
and you can't drill a hole in it and stick a rivet into it doesn't mean
it's free.

Post a reply to this message

Tom Austin <voi### [at] devnull> wrote:
> I am looking for information and recommendations for a database engine.
>
> We are setting up a relational database system that may reside on a
> database server in the future.
>
> Linux based solution preferred
>
> Something that is easy to set up and back up and restore.
>    even a sql sump is ok
>
> I will be using relationships (pk/fk) to keep data straight.
>
> Triggers and stored procedures are a big plus.
>
> The possibility of using GIS functionality int he future will be taken
> into consideration.
>
>
> What are your thoughts on a good system to use?

Hi Tom,

in my last project i've used MySQL and InnoDB engine.
I'm using multi column PKs and FKs and triggers.

Regards
Aydan

Post a reply to this message

Le_Forgeron wrote:
> Both can be administered via a web interface for the common usage
> (phpmyadmin & phppgadmin)

Be aware that you *will* get script kiddies every day or two trying to break 
in via phpmyadmin. Make sure it's behind a firewall, good password, etc. 
When I was running Linux servers, that and trying to break into drupal were 
the only frequent 404's I was issuing.

-- 
Darren New, San Diego CA, USA (PST)
  "How did he die?"   "He got shot in the hand."
     "That was fatal?"
          "He was holding a live grenade at the time."

Post a reply to this message

On 3/14/2011 1:11 PM, Darren New wrote:
> Le_Forgeron wrote:
>> Both can be administered via a web interface for the common usage
>> (phpmyadmin & phppgadmin)
>
> Be aware that you *will* get script kiddies every day or two trying to
> break in via phpmyadmin. Make sure it's behind a firewall, good
> password, etc. When I was running Linux servers, that and trying to
> break into drupal were the only frequent 404's I was issuing.
>

Completely off topic, but....

I am looking into implementing a drupal site - is there much to look out 
for as far as vulnerabilities?

Thanks

Post a reply to this message

Tom Austin <voi### [at] devnull> wrote:
> I am looking for information and recommendations for a database engine.
>
> We are setting up a relational database system that may reside on a
> database server in the future.
>
> Linux based solution preferred
>
> Something that is easy to set up and back up and restore.
>    even a sql sump is ok
>
> I will be using relationships (pk/fk) to keep data straight.
>
> Triggers and stored procedures are a big plus.
>
> The possibility of using GIS functionality int he future will be taken
> into consideration.
>
>
> What are your thoughts on a good system to use?

you are very obviously asking for Postgresql:

http://www.postgresql.org/

besides being the most robust open-source DBMS out there, one of the very first
features I noticed was this strange thing called GIS.  This was back then, today
I learned Postgresql comes with no GIS on its own, instead users are directed to
use it together with PostGIS:

http://www.postgis.org/

Post a reply to this message

On 3/14/2011 10:16, Tom Austin wrote:
> I am looking into implementing a drupal site - is there much to look out for
> as far as vulnerabilities?

I didn't do drupal. We just had people attacking our non-existant drupal 
install. :-)

-- 
Darren New, San Diego CA, USA (PST)
  "How did he die?"   "He got shot in the hand."
     "That was fatal?"
          "He was holding a live grenade at the time."

Post a reply to this message

On 3/14/2011 1:44 PM, Darren New wrote:
> On 3/14/2011 10:16, Tom Austin wrote:
>> I am looking into implementing a drupal site - is there much to look
>> out for
>> as far as vulnerabilities?
>
> I didn't do drupal. We just had people attacking our non-existant drupal
> install. :-)
>

Reminds me of seeing malformed URL requests to hack a windows based web 
server - but the server was on Linux ;-)

I'll have to check out drupal vulnerabilities as I move forward.


Thanks

Post a reply to this message

On 3/14/2011 11:23, Tom Austin wrote:
> I'll have to check out drupal vulnerabilities as I move forward.

The best thing to do is keep a log of 404's (or any 400/500 error really) 
that you *actually* look at relatively frequently. If you don't get many 
404's, mail a summary to your inbox each day and look at it.

-- 
Darren New, San Diego CA, USA (PST)
  "How did he die?"   "He got shot in the hand."
     "That was fatal?"
          "He was holding a live grenade at the time."

Post a reply to this message

> Reminds me of seeing malformed URL requests to hack a windows based web
> server - but the server was on Linux ;-)

Yeah, I had this also, back when I was running Apache on my laptop. Kind 
of amusing...

Post a reply to this message