Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
Mysql for personal use, postgre for professional. The reason is time and availability
-
vannrith1297y@RazorSh4rk so let say i build a project for client, which one is better? How is compatibility for cheap shared hosting?
-
vannrith1297y@Letmecode yeah, mysql is mariadb now, but i just want to know what is better for real life
-
hjk10157517yUse sqlite if you can get away with it. (Used far too little while often being the simplest and fastest solution). Use MonoDB when when you mostly have fieldable entities. Mariadb and Postgre are usually dictated by the ecosystem. Most php web applications use mysql(or Maria) so probably easier for other developers. Postgre is nicer as it is a bit more standards compliant.
@Kaji PDO is php specific and does no abstraction to speak of. So queries with mysql functions won't work on Postgre or sqlite. Probably best to use an ORM if you want to be able to stay DB agnostic, else you have to be very careful. -
Postgres. Automatic setups are easier. Better performance. Sticks to standard SQL. More features.
-
@Letmecode i worked with a guy who was a long time database sme and he said his favorite was postgres as well. He was massively smart and I trust his opinion but he never really elaborated why. What is it about postgres that draws you? Is it faster or more stable. Is the SQL in postgres more standardised?
Related Rants
PostgreSQL or MySQL ?
And why?
undefined
database
web development
sql