101–110 of 140 posts
I found this video to be much more interesting https://youtu.be/zsF1vfHBMBI BTW I would like to send out a BIG THANK YOU to the guys that did the videos - this is such an important and great service for everybody who could not attend the conference, so: THANK YOU VERY MUCH!
I had a job interview at Zalando a while ago, and apart from the huge bunch of bananas at the entrance to the developer's den, the one thing I remember most about was the fact that apparently they're using stored procedures for basically any database transaction. Which is probably a more unorthodox use of databases these days, at least for Postgres (I've heard it was more common for SQL Server and I once had the ques…
Even during the talk it was even mentioned. "Stored procedures are the core our success" He also mentioned that Zelando does 100 data model (schema?) changes per week, and that senior dev make code changes without code review.
Earlier quoted context omitted.
In MySQL type \e and you can edit your query just the same. https://dev.mysql.com/doc/refman/5.6/en/mysql-commands.html
I love that earlier up in this same thread people are complaining about the magic \x sequences in postgres and this is how you do query edits in the mysql cli :) I've got my biases, but whenever something like this comes up, I just make some popcorn and enjoy the show.
Two years ago I switched from PHP and MySQL to Ruby and PostgreSQL. The only thing I'm missing is Sequel Pro. PG Admin is ok, does everything I need, but that interface is ugly and unintuitive. [1] http://www.sequelpro.com/
You might try Valentina Studio.
I love PostgreSQL. But for a personal project I went with MongoDB, because my data set was a perfect match for mongo's design. Now I love mongo too, I'm amazed with how easy it has been to maintain 100% uptime on comodity hardware (one server is literally in a room in my apartment) through all the random server downtimes, upgrades, migrations, etc. And now I have more ideas for some personal projects, and they would…
Earlier quoted context omitted.
I've recently made the switch to postgres, and then I found pgadmin3, and I'm really feeling some pain. For instance, the "explain query" visualization is great, and very helpful, but there's no way I can find to zoom out, at all . And that window doesn't support mouse scrolling. And there's no way to export the visualization somewhere else. So when I'm trying to figure out why a very, very large query is running slo…
It's not graphical, but pasting the explain analyze output into http://explain.depesz.com/ helps me see where postgres is spending most of its time.
Earlier quoted context omitted.
eclipse and intuitive shouldn't ever be used in the same sentence. emacs ditto, but calling one more intuitive from another is missing the point by about 1 AU.
Eclipse isn't great in that respect, but choosing something from a menu is definitely more intuitive than remembering the cryptic commands in emacs.
Hmm, looking a bit at their site[1]: Addidas jogging pants -- 59,95 € Volcom T-shirt print -- 17,45 € Under Armour T-shirt -- 39.95 € Like really now -- who needs this stuff? Especially when you can just go to Aldi or Tchibo (or any of a number of other discount retailers readily visible at nearly every shopping mall in Germany) and buy essentially same stuff (minus the logos, of course) for 1/10th of the price. So p…
PostgreSQL is great, but I've gone back to MySQL because of the ease of which I can setup replication (which I like to use when possible in addition to automated/periodic backups).
We have a setup where our WAL log is rotated every minute and backed up to S3. Replica databases can either load from S3 or connect to the master for streaming - so they will catch up using S3 and then connect, reducing load on the master.
Earlier quoted context omitted.
> Ctrl-c kills the whole shell. great, but not what I expect. That is actually exactly what you should expect. SIGINT cancels most things you run in the CLI. Interrupt a ping because you forgot a count parameter? Ctrl+C Honestly, the reason I don't use Postgres has nothing to do with the CLI and everything to do with the ecosystem for Multi-Master being inferior to Galera. But yeah, I'm happy with mysql-cli as well a…
Ping isn't a CLI, its a single command that expects no further input. A database shell is more like bash than ping. And Ctrl-C does not exit out of bash.