Upcoming presentations
No upcoming presentations...
Past presentations
Developers love working with JSON. Document stores like MongoDB have proved to be very popular. Both MongoDB and PostgreSQL have built-in support for the 'JSON' data type. Understand the pros and cons of working with JSON in both of these databases - when should you use MongoDB vs. PostgreSQL? If you are already comfortable with PostgresSQL, should you continue to use it for your JSON data? In ...
There is no protection against bad queries. If a query is poorly written, it's execution can't be improved with any indexes, fast access path or other database advancements. What is the most common source of poorly written queries? Most of the time they do not come from humans; they are generated by applications that use ORMs to communicate with databases. What can we do to prevent it from happ...
Developers love working with JSON. Document stores like MongoDB have proved to be very popular. Both MongoDB and PostgreSQL have built-in support for the 'JSON' data type. Understand the pros and cons of working with JSON in both of these databases - when should you use MongoDB vs. PostgreSQL? If you are already comfortable with PostgresSQL, should you continue to use it for your JSON data? In ...
Managing a PostgreSQL production deployment is hard. There are hundreds of operational tasks involved, and missing one could critically impact on your deployment. 90% of tasks can be automated, 100% can be optimized. Learn how you can automate your time-consuming PostgreSQL operational tasks so you can get your time back for database development and performance optimizations with ScaleGrid:
...