CEO at SuPragma·
Needs advice
on
MySQLMySQL
and
PostgreSQLPostgreSQL

I asked my last question incorrectly. Rephrasing it here.

I am looking for the most secure open source database for my project I'm starting: https://github.com/SuPragma/SuPragma/wiki

Which database is more secure? MySQL or PostgreSQL? Are there others I should be considering? Is it possible to change the encryption keys dynamically?

Thanks,

Raj

READ LESS
8 upvotes·376.3K views
Replies (2)
Engineering Manager at Akeneo·
Recommends
on
PostgreSQL

PostgreSQL provides more tools and builtin features around security, eg: row level security and the support of SELinux (through SE-PostgreSQL). Overall, whatever you choose, the important is to keep it updated and have the skills to apply security best practices and update them regurarly, without this, it's like putting your money in Fort knox but leaving the vault key in a public place.

READ MORE
4 upvotes·1 comment·368.5K views
Navraj Chohan
Navraj Chohan
·
April 24th 2020 at 1:34PM

Thanks Pierrick! Great feedback.

·
Reply
Technical Architect at ERP Studio·
Recommends
on
PostgreSQL

It is open-source and more tools than mySQL. PostgreSQL is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. It is also good for small companies due to tools for free availability. PostgreSQL includes built-in support for regular B-tree and hash indexes. Indexes in PostgreSQL also support Expression & Partial Indices ( index only a part of a table). Expression Index can be created with an index of the result of an expression or function, instead of simply the value of a column.

READ MORE
4 upvotes·368.5K views
Avatar of Pierrick Martos

Pierrick Martos

Engineering Manager at Akeneo