> On Mar 14, 2020, at 12:17 PM, Rob Jonson <r...@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 <edel...@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 <arielj...@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.jon...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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+unsubscr...@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.
