rostislav-dugin.hashnode.devMongoDB vs PostgreSQL — 6 factors to consider when choosing your databaseChoosing between MongoDB and PostgreSQL is one of the most important decisions you'll make for your project. Both databases are mature, reliable and widely used. But they're fundamentally different in how they store, query and scale data. This choice...Feb 13·8 min read
rostislav-dugin.hashnode.dev8 MySQL security mistakes that expose your database to attackersMySQL is one of the most deployed databases in the world, which also makes it one of the most targeted. A lot of MySQL installations in the wild are running with default settings, overly permissive user accounts and no encryption. Some of these are d...Feb 11·10 min read
rostislav-dugin.hashnode.devPostgreSQL slow queries — 7 ways to find and fix performance bottlenecksEvery PostgreSQL database eventually develops slow queries. It might start small: a dashboard that takes a bit longer to load, an API endpoint that times out during peak traffic, a report that used to run in seconds and now takes minutes. The tricky ...Feb 10·11 min read
rostislav-dugin.hashnode.devPostgreSQL indexing explained — 5 index types and when to use eachIndexes are one of those things that everybody knows they should use, but few people actually understand beyond the basics. You create an index, the query gets faster, done. Except when it doesn't. Or when the wrong index makes things slower. Or when...Feb 9·11 min read
rostislav-dugin.hashnode.devMongoDB schema design — 6 patterns every developer should masterMongoDB gives you flexibility that relational databases don't. No rigid tables, no mandatory schemas, no upfront column definitions. You just throw documents into a collection and go. That freedom is exactly what makes schema design in MongoDB so imp...Feb 8·10 min read
