![]() Specifically, in many of the cases where we previously used Postgres, we now use Schemaless, a novel database sharding layer built on top of MySQL ( ). Since that time, the architecture of Uber has changed significantly, to a model of microservices and new data platforms. The early architecture of Uber consisted of a monolithic backend application written in Python that used Postgres for data persistence. Fun fact - earlier in Uber's history we'd actually moved from MySQL to Postgres before switching back for good, & though we published the article in Summer 2016 we haven't looked back since: In essence, it was due to a variety of limitations of Postgres at the time. Our most popular (& controversial!) article to date on the Uber Engineering blog in 3+ yrs. ![]() We use its excellent built-in full-text search, which has helped us avoid needing to bring in a tool like Elasticsearch, and we've really enjoyed features like its partial indexes, which saved us a lot of work adding unnecessary extra tables to get good performance for things like our "unread messages" and "starred messages" indexes. MAMP provides them with all the tools they need. As a result, we were able to delete a bunch of custom queries escaping the ORM that we'd written to make the MySQL query planner happy (because postgres just did the right thing automatically).Īnd then after that, we've just gotten a ton of value out of postgres. MAMP is a free, local server environment that can be installed under macOS and Windows with just a few clicks. ![]() We didn't have to do any real customization (just some tuning settings for how big a server we had), and all of our most important queries were faster out of the box. We ended up getting so frustrated that we tried out PostgresQL, and the results were fantastic. Issues ranged from bad collation defaults, to bad query plans which required a lot of manual query tweaks. However, we found that even though we were using the Django ORM for most of our database access, we spent a lot of time fighting with MySQL. Zulip started out as a MySQL project back in 2012, because we'd heard it was a good choice for a startup with a wide community. I imagine most of us just want something quick, light, and up-to-date.We've been using PostgreSQL since the very early days of Zulip, but we actually didn't use it from the beginning. So which do you use, and why do you consider it the best? Did you just stick with the first one you tried? ![]() But it comes with less features than XAMPP (no FTP server, for example).ĮasyPHP is one that I have no experience of, so I can't say, but it's apparently pretty popular, too.Īlternatives? There a ton of other stacks listed on Wikipedia. WampServer apparently is easier to switch versions of PHP or Apache, if you need to. Yes, there are problems with getting something like this running on Vista with UAC enabled, but disabling UAC should never be offered as a solution, especially for newbs (who need UAC more than anyone). I also spotted something else which makes me concerned: The developers recommend that Vista users disable UAC in order to use their software!įor me that's a big red flag. This isn't terrible for a development situation, obviously, but you may end up relying on something like register_globals. For example, I've heard that their default PHP configuration is very insecure (and apparently their admin app can't function without these holes being left open). XAMPP seems to be the most popular, but I've read several bad things about it that make me wonder if it's as good as its popularity suggests. There was a similar question asked here three years ago, but I want to open it up further to include all possible Windows/Apache/MySQL/PHP stacks. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |