Ruby on Rails

> On Mar 14, 2020, at 12:17 PM, Rob Jonson <rob@hobbyistsoftware.com> wrote:
>
> thanks folks,
>
> I guess I'm asking more about the practical pain points. - As you say, I trust rails to deal with most of the day-to-day.
>
> do you end up battling to get your postgres install working after upgrading mac (or postgres?)

You can install Postgres as a user-space application (with an icon and everything), so this can be a non-issue.

> do you have problems with string encoding incompatibilities in obscure email addresses?

If it doesn't fit into UTF-8, then you may have a problem. Do you have a problem now, in MySQL? What encoding and charset are you using now?

> do you have a convenient gui for browsing (like SequelPro)

TablePlus is pretty nice.

> are there other similar annoyances, or does it 'just work'

Like another commenter posted, I have used it on Heroku with SQLite on the dev side, and no issues.

>
> whatever I use, I like to stick with the same db in dev & production, ( using mysql or sqlite for my tests and postgres on the server seems like it is asking for trouble)

It could be a problem, or it could be a sign that you are depending on a database feature to hide a bug. At work, we use SQLite for testing (including the CI stuff on GitLab) and Oracle on the production server. We try for 100% test coverage.

Walter

>
> cheers,
>
> Rob
>
>
>
>
> On Sat, 14 Mar 2020 at 15:17, Phil Edelbrock <edelbrp@gmail.com> wrote:
>
> I think Ariel's reply is spot-on. Rails is basically DB agnostic, however I think the trend is that PostgreSQL is the more favored backend (except for stuff like Wordpress). We're doing a lot more SQL procedural stuff these days with our rails apps (e.g. kicking out JSON from a single query can be literally 1,000x times faster in cases vs. asking Rails to query a model and format the same thing). I find PostgreSQL a lot easier to admin as well, but to each their own.
>
> Good luck!
>
>
> Phil
>
>
>> On Mar 14, 2020, at 7:37 AM, Ariel Juodziukynas <arieljuod@gmail.com> wrote:
>>
>> Usually ActiveRecord takes care of most of the differences, and postresql has a lot of similarities with mysql. I guess it would be a different call if you ask about learning a completely different db engine like mongo or graphql, but learning postgresql shouldn't take too much time knowing MySQL, at least to be proficient. I even have a project that I used sqlite to prototype and postresql when deploying it to heroku for tests and I had to do nothing to make it work on both databases thanks to AR.
>>
>> Also, heroku prefers postrgres for example and heroku is really popular for rails hosting.
>>
>> El sáb., 14 mar. 2020 a las 10:58, Rob Jonson (<rob.jonson@gmail.com>) escribió:
>> Hi Folks,
>>
>> I have been using Mysql for forever, and broadly it works fine for me, with two complaints
>> 1) occasional issues with mismatches in encoding/collation on strings
>> 2) hours lost on every mac upgrade trying to get mysql working properly again
>>
>> I know that people are generally favouring postgresql these days, I'm wondering if anyone can comment on whether it's worth putting in the effort to learn a new db?
>>
>> all the best
>>
>> Rob
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/495925de-561d-4561-bb70-dfe9549219a8%40googlegroups.com.
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAPS3bcBqX0Y3R_63yfarpdV%2B0qesh3VGzeTzP2bV0inbGMxoOQ%40mail.gmail.com.
>
>
> --
> You received this message because you are subscribed to a topic in the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/topic/rubyonrails-talk/HjmTuU1QoNM/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/BE54840B-0F95-4AB6-831B-90A3205AD2A6%40gmail.com.
>
>
> --
>
>
>
>
>
> Hobbyist Software is a trading name of Hobbyist Software Limited. Registered office 12 Fraley Rd, Bristol, BS93BS. Registered in England. Company no:7876492
>
> --
> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CACTOy%2BrggoJWMrmsUZiFFst5wNpKvEM7eRtzjfBxKwXtJEqvOA%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/61EC1866-A39A-4331-A215-B98AF43716BF%40wdstudio.com.