They might already have features similar to this and I have not found them. I think that that's one of the few areas that Postgres does not handle as well as MySQL does or did." "PostgreSQL’s performance could be improved." "PostgreSQL could improve by providing a geographical solution for tracking trucks and people in the field. "As PostgreSQL is an open-source product, you do have to do a bit more configuration and management yourself." "I'd like to see better memory management. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools." For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. So if MySQL becomes smoother and more adaptable, it'll be easier." "Improvements to MySQL depend on the specific use case. The 5G framework means an unstructured framework. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution." "When I run into issues, I really have to research how to fix them." "Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. ![]() "Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance." "This solution needs to be improved when it comes to working with desktop applications on the developer side." "I would like to see more integrations of the solution with other platforms and improve the support on different data types." "The solution is expensive." "They should come up with a better solution than the NDB cluster for better scaling. These developers write cool queries which perform badly on the database end.Īs DBAs, we constantly urge the developers not to write bad queries, help them learn more, and write placebo commands." "We managed to reduce the storage space needed to 10% of the original size, without affecting data integrity, and we significantly improved the performance." They find it difficult to write even a SQL statement. In today’s age, most developers do not have strong SQL knowledge or language command. The solution helps to get the job done in the best possible way. My partner is experienced in DDA and he writes sophisticated SQL queries. For example, here in Mexico, a company and a person can be sold to us as a physical entity or a physical person." "The solution is open-source and free to use." "This is an open-source solution, operates at a high speed, and supports more than one SQL language." "PostgreSQL has complete SQL dialects and is useful for writing sophisticated and complex queries. Instead of having several tables or several relations for one entity, I can adapt this entity. So, there is a big push to go to Postgres." "Initial setup is simple." "PostgreSQL makes it very adaptable to several descriptions of a record. ![]() Oracle costs us $6 million a year right now, which is killing us, and Postgres costs nothing. Our organization has the initiative to go to open source to cut down on cost. When it's installed correctly, PostgreSQL is an enterprise-grade solution." "The main value is that it is open source, which means it is free. "Postgres is rock solid when deployed according to best practices as documented by the PostgreSQL community.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |