Re: Mysql vs Postgress

[loai.abdallatif]

Thanks Andy 


Sent from my Samsung Galaxy smartphone.
 Original message From: Andy Susanto <ibsolut...@gmail.com> 
Date: 1/25/18  12:33 AM  (GMT+02:00) To: Tomcat Users List 
<users@tomcat.apache.org> Subject: Re: Mysql vs Postgress 
Hi Loai,

here  a link article that do comparison DB, it will help to make a choose.

https://medium.com/@yangforbig/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems-afd5afd6566


Regards,

Andy Susanto

On Thu, Jan 25, 2018 at 4:54 AM, Enrico Olivelli <eolive...@gmail.com>
wrote:

> Hi,
> If you are looking for replication maybe you can out my project, it is
> HerdDB, you can find it on github or check the website http://herddb.org
> It has a jdbc driver and natively supports replication, using Apache
> BookKeeper and Apache Zookeeper.
> It is 100% free and opensource, ASL v2 licensed.
>
> I am an happy user of postgres and mysql and Hbase but HerdDB talks
> natively SQL like Mysql and PG and it is natively distributed like Hbase.
> It can run in Embedded mode, so that you do not need an external set of
> machines.
>
> Hope that helps
> Ping me of you need help or use github issue tracker or subscribe to the
> mailing list
>
> Pg vs mysqlfor complex applications with heavy usage of complex queries
> PG is surely better from my experience
>
>
> Cheers
> Enrico
>
> Il mer 24 gen 2018, 22:38 Loai Abdallatif <loai.abdalla...@gmail.com> ha
> scritto:
>
> > Dear  all
> >
> > I have project that is based on Tomcat/apache Servers , any one can help
> > regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> > I'm interested in DB clustering/Replication feature ?
> >
> > Kind Regards,
> >
> --
>
>
> -- Enrico Olivelli
>

Re: Mysql vs Postgress

[loai.abdallatif]

Thanks Igal


Sent from my Samsung Galaxy smartphone.
 Original message From: "Igal @ Lucee.org" <i...@lucee.org> 
Date: 1/24/18  11:44 PM  (GMT+02:00) To: users@tomcat.apache.org Subject: Re: 
Mysql vs Postgress 
On 1/24/2018 1:37 PM, Loai Abdallatif wrote:
> Dear  all
>
> I have project that is based on Tomcat/apache Servers , any one can help
> regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> I'm interested in DB clustering/Replication feature ?
>
> Kind Regards,
>
Very opinionated question, but in my opinion Postgres is better than any 
DBMS out there including MySQL and the commercial options.  In modern 
versions of Postgres replication and clustering are baked in to a large 
extent.

You should really check with the Postgres mailing list though.

Best,

Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>

Re: Mysql vs Postgress

[loai.abdallatif]

Thanks Enrico 


Sent from my Samsung Galaxy smartphone.
 Original message From: Enrico Olivelli <eolive...@gmail.com> 
Date: 1/24/18  11:54 PM  (GMT+02:00) To: Tomcat Users List 
<users@tomcat.apache.org> Subject: Re: Mysql vs Postgress 
Hi,
If you are looking for replication maybe you can out my project, it is
HerdDB, you can find it on github or check the website http://herddb.org
It has a jdbc driver and natively supports replication, using Apache
BookKeeper and Apache Zookeeper.
It is 100% free and opensource, ASL v2 licensed.

I am an happy user of postgres and mysql and Hbase but HerdDB talks
natively SQL like Mysql and PG and it is natively distributed like Hbase.
It can run in Embedded mode, so that you do not need an external set of
machines.

Hope that helps
Ping me of you need help or use github issue tracker or subscribe to the
mailing list

Pg vs mysqlfor complex applications with heavy usage of complex queries
PG is surely better from my experience


Cheers
Enrico

Il mer 24 gen 2018, 22:38 Loai Abdallatif <loai.abdalla...@gmail.com> ha
scritto:

> Dear  all
>
> I have project that is based on Tomcat/apache Servers , any one can help
> regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> I'm interested in DB clustering/Replication feature ?
>
> Kind Regards,
>
-- 


-- Enrico Olivelli

Re: Mysql vs Postgress

[loai.abdallatif]

 thanks Hassan 


Sent from my Samsung Galaxy smartphone.
 Original message From: Hassan Schroeder 
<hassan.schroe...@gmail.com> Date: 1/25/18  1:33 AM  (GMT+02:00) To: Tomcat 
Users List <users@tomcat.apache.org> Subject: Re: Mysql vs Postgress 
On Wed, Jan 24, 2018 at 1:37 PM, Loai Abdallatif
<loai.abdalla...@gmail.com> wrote:

> I have project that is based on Tomcat/apache Servers , any one can help
> regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> I'm interested in DB clustering/Replication feature ?

Aside from personal preferences -- I am not a Postgres fanboy --
why not try them both out and see which you prefer?

As long as you write DB-agnostic SQL you can spin up AWS RDS
instances, one of each, and test-drive for a couple of dollars.

And if you stick with AWS you get replication, hot standby, etc. built in.
(Note: all that might be true of other cloud providers.)

FWIW!
-- 
Hassan Schroeder  hassan.schroe...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote

-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Re: Mysql vs Postgress

[Hassan Schroeder]

On Wed, Jan 24, 2018 at 1:37 PM, Loai Abdallatif
 wrote:

> I have project that is based on Tomcat/apache Servers , any one can help
> regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> I'm interested in DB clustering/Replication feature ?

Aside from personal preferences -- I am not a Postgres fanboy --
why not try them both out and see which you prefer?

As long as you write DB-agnostic SQL you can spin up AWS RDS
instances, one of each, and test-drive for a couple of dollars.

And if you stick with AWS you get replication, hot standby, etc. built in.
(Note: all that might be true of other cloud providers.)

FWIW!
-- 
Hassan Schroeder  hassan.schroe...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote

-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Re: Mysql vs Postgress

[Andy Susanto]

Hi Loai,

here  a link article that do comparison DB, it will help to make a choose.

https://medium.com/@yangforbig/sqlite-vs-mysql-vs-postgresql-a-comparison-of-relational-database-management-systems-afd5afd6566


Regards,

Andy Susanto

On Thu, Jan 25, 2018 at 4:54 AM, Enrico Olivelli 
wrote:

> Hi,
> If you are looking for replication maybe you can out my project, it is
> HerdDB, you can find it on github or check the website http://herddb.org
> It has a jdbc driver and natively supports replication, using Apache
> BookKeeper and Apache Zookeeper.
> It is 100% free and opensource, ASL v2 licensed.
>
> I am an happy user of postgres and mysql and Hbase but HerdDB talks
> natively SQL like Mysql and PG and it is natively distributed like Hbase.
> It can run in Embedded mode, so that you do not need an external set of
> machines.
>
> Hope that helps
> Ping me of you need help or use github issue tracker or subscribe to the
> mailing list
>
> Pg vs mysqlfor complex applications with heavy usage of complex queries
> PG is surely better from my experience
>
>
> Cheers
> Enrico
>
> Il mer 24 gen 2018, 22:38 Loai Abdallatif  ha
> scritto:
>
> > Dear  all
> >
> > I have project that is based on Tomcat/apache Servers , any one can help
> > regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> > I'm interested in DB clustering/Replication feature ?
> >
> > Kind Regards,
> >
> --
>
>
> -- Enrico Olivelli
>

Re: Mysql vs Postgress

[Enrico Olivelli]

Hi,
If you are looking for replication maybe you can out my project, it is
HerdDB, you can find it on github or check the website http://herddb.org
It has a jdbc driver and natively supports replication, using Apache
BookKeeper and Apache Zookeeper.
It is 100% free and opensource, ASL v2 licensed.

I am an happy user of postgres and mysql and Hbase but HerdDB talks
natively SQL like Mysql and PG and it is natively distributed like Hbase.
It can run in Embedded mode, so that you do not need an external set of
machines.

Hope that helps
Ping me of you need help or use github issue tracker or subscribe to the
mailing list

Pg vs mysqlfor complex applications with heavy usage of complex queries
PG is surely better from my experience


Cheers
Enrico

Il mer 24 gen 2018, 22:38 Loai Abdallatif  ha
scritto:

> Dear  all
>
> I have project that is based on Tomcat/apache Servers , any one can help
> regarding the best DB engine  * mysql or Postgress ) keeping in mind that
> I'm interested in DB clustering/Replication feature ?
>
> Kind Regards,
>
-- 


-- Enrico Olivelli

Re: Mysql vs Postgress

[Igal @ Lucee.org]

On 1/24/2018 1:37 PM, Loai Abdallatif wrote:

Dear  all

I have project that is based on Tomcat/apache Servers , any one can help
regarding the best DB engine  * mysql or Postgress ) keeping in mind that
I'm interested in DB clustering/Replication feature ?

Kind Regards,

Very opinionated question, but in my opinion Postgres is better than any 
DBMS out there including MySQL and the commercial options.  In modern 
versions of Postgres replication and clustering are baked in to a large 
extent.


You should really check with the Postgres mailing list though.

Best,

Igal Sapir
Lucee Core Developer
Lucee.org 

Mysql vs Postgress

[Loai Abdallatif]

Dear  all

I have project that is based on Tomcat/apache Servers , any one can help
regarding the best DB engine  * mysql or Postgress ) keeping in mind that
I'm interested in DB clustering/Replication feature ?

Kind Regards,