Re: [Rails] Old Rails app from Docker Container - trying to run natively again . .

[Philip Rhoades]

Hassan,


On 2020-03-15 11:31, Hassan Schroeder wrote:
On Sat, Mar 14, 2020 at 3:52 PM Philip Rhoades  
wrote:



Docker crashed and I lost the Rails container so I have to go back to
the original source.


I don't know what "lost the Rails container" means. Can't you just
rerun the Dockerfile?



No.



Could someone suggest how I could fix the problem seen below? - I
deleted the Gemfile.lock file first.


Why?



Because leaving the original lock file there caused "bundle install 
--path vendor/bundle" to fail with:


Installing json 1.8.3 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

current directory: 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/json-1.8.3/ext/json/ext/generator
/usr/bin/ruby -I /usr/share/rubygems -r 
./siteconf20200315-119213-1sg3qup.rb extconf.rb

creating Makefile

current directory: 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/json-1.8.3/ext/json/ext/generator

make "DESTDIR=" clean
rm -f
rm -f generator.so  *.o  *.bak mkmf.log .*.time

current directory: 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/json-1.8.3/ext/json/ext/generator

make "DESTDIR="
gcc -I. -I/usr/include -I/usr/include/ruby/backward -I/usr/include -I. 
-DJSON_GENERATOR-fPIC -O2 -g -pipe -Wall -Werror=format-security 
-Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions 
-fstack-protector-strong
-grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 
-specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -mtune=generic 
-fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection 
-fPIC -m64 -o generator.o -c

generator.c
generator.c: In function 'generate_json':
generator.c:861:25: error: 'rb_cFixnum' undeclared (first use in this 
function); did you mean 'mFixnum'?

  861 | } else if (klass == rb_cFixnum) {
  | ^~
  | mFixnum
generator.c:861:25: note: each undeclared identifier is reported only 
once for each function it appears in
generator.c:863:25: error: 'rb_cBignum' undeclared (first use in this 
function); did you mean 'mBignum'?

  863 | } else if (klass == rb_cBignum) {
  | ^~
  | mBignum
make: *** [Makefile:245: generator.o] Error 1

make failed, exit code 2

Gem files will remain installed in 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/json-1.8.3 
for inspection.
Results logged to 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/extensions/x86_64-linux/2.6.0/json-1.8.3/gem_make.out


An error occurred while installing json (1.8.3), and Bundler cannot 
continue.
Make sure that `gem install json -v '1.8.3' --source 
'https://rubygems.org/'` succeeds before bundling.


In Gemfile:
  rails was resolved to 4.1.5, which depends on
actionmailer was resolved to 4.1.5, which depends on
  actionpack was resolved to 4.1.5, which depends on
actionview was resolved to 4.1.5, which depends on
  activesupport was resolved to 4.1.5, which depends on
json



$ ./bin/rails s
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/object/duplicable.rb:82:
warning: BigDecimal.new is deprecated; use BigDecimal() method 
instead.

=> Booting Puma
=> Rails 4.1.5 application starting in development on


Did you originally develop this Rails 4.1.5 app using Ruby 2.6.0? Or
I guess more exactly have you been running it on that Ruby version
successfully?



I can't remember what version of Ruby it was - it was from earlier than 
2015 . . it was running on whatever version of Ruby that was in the 
container - which is gone because the whole docker setup was corrupted . 
. I may have backups on old hard disks but it would take too long to try 
and re-create old OS environment, Docker version etc so I thought the 
best thing to do was just the Rails app running directly on my current 
machine (Linux Fedora 31).


Thanks,

Phil.
--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

--
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/86d95cffebf21738357c0028368ec698%40lev.com.au.

Re: [Rails] Old Rails app from Docker Container - trying to run natively again . .

[Hassan Schroeder]

On Sat, Mar 14, 2020 at 3:52 PM Philip Rhoades  wrote:

> Docker crashed and I lost the Rails container so I have to go back to
> the original source.

I don't know what "lost the Rails container" means. Can't you just
rerun the Dockerfile?

> Could someone suggest how I could fix the problem seen below? - I
> deleted the Gemfile.lock file first.

Why?

> $ ./bin/rails s
> /home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/object/duplicable.rb:82:
> warning: BigDecimal.new is deprecated; use BigDecimal() method instead.
> => Booting Puma
> => Rails 4.1.5 application starting in development on

Did you originally develop this Rails 4.1.5 app using Ruby 2.6.0? Or
I guess more exactly have you been running it on that Ruby version
successfully?

-- 
Hassan Schroeder  hassan.schroe...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote

-- 
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/CACmC4yCiYMuRZY4xf2SuWLkQCt87eMetgHjsNXKGdX%2BWAGkfkg%40mail.gmail.com.

[Rails] Old Rails app from Docker Container - trying to run natively again . .

[Philip Rhoades]

People,

Docker crashed and I lost the Rails container so I have to go back to 
the original source.


Could someone suggest how I could fix the problem seen below? - I 
deleted the Gemfile.lock file first.


Thanks,

Phil.

$ bundle install --path vendor/bundle
.
.
Bundle complete! 15 Gemfile dependencies, 54 gems now installed.
Bundled gems are installed into `./vendor/bundle`

$ ./bin/rails s
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/object/duplicable.rb:82: 
warning: BigDecimal.new is deprecated; use BigDecimal() method instead.

=> Booting Puma
=> Rails 4.1.5 application starting in development on 
http://0.0.0.0:3000

=> Run `rails server -h` for more startup options
=> Notice: server is listening on all interfaces (0.0.0.0). Consider 
using 127.0.0.1 (--binding option)

=> Ctrl-C to shutdown server
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:121: 
warning: constant ::Fixnum is deprecated
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:121: 
warning: constant ::Bignum is deprecated

Exiting
Traceback (most recent call last):
6734: from ./bin/rails:5:in `'
6733: from ./bin/rails:5:in `require'
	6732: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/railties-4.1.5/lib/rails/commands.rb:17:in 
`'
	6731: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/railties-4.1.5/lib/rails/commands/commands_tasks.rb:40:in 
`run_command!'
	6730: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/railties-4.1.5/lib/rails/commands/commands_tasks.rb:76:in 
`server'
	6729: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/railties-4.1.5/lib/rails/commands/commands_tasks.rb:76:in 
`tap'
	6728: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/railties-4.1.5/lib/rails/commands/commands_tasks.rb:81:in 
`block in server'
	6727: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/railties-4.1.5/lib/rails/commands/server.rb:67:in 
`start'

 ... 6722 levels...
	   4: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:131:in 
`block (2 levels) in '
	   3: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:131:in 
`block (2 levels) in '
	   2: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:131:in 
`block (2 levels) in '
	   1: from 
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:131:in 
`block (2 levels) in '
/home/phr/src/ruby/rails/domain-sf/vendor/bundle/ruby/2.6.0/gems/activesupport-4.1.5/lib/active_support/core_ext/numeric/conversions.rb:131:in 
`block (2 levels) in ': stack level too deep 
(SystemStackError)


--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

--
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/f989a2fb7edae3a2c7fa6cd86675ec91%40pricom.com.au.

[Rails] Is it worth switching to Postgresql?

[San Ji]

No, it isn't.
If you notice only those 2 downside, you'd better stick with you current choice.
MySQL 8 has better encoding support, I am assuming you're mentioning about 
emoji encodings.
And you can also learn Docker for ease of development to address the other 
issue you have.

-- 
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/c2e76d0c-7fe5-43b3-98c0-57886a498c7c%40googlegroups.com.

Re: [Rails] Is it worth switching to Postgresql?

[Ariel Juodziukynas]

Sorry, using different db on different environment is not something I'm
recommending, it was just to point out that the transition should be really
easy. I do think it's faster to prototype using sqlite as long as it fits
the needs, but in a more mature projects I would use the same db everywhere
so I can use all the features I need.

I didn't have that many projects with postgres to talk about upgrading
versions and those things, but personally I never had issues with MySQL
either.

About encodings and collations, I guess it depends on the error but if you
have encoding or collation errors I guess the problem is the configuration
of your tables and the input and not the actual db, you may encounter
problems with any db if you try to handle incompatible encodings at the
same time.

I've used PgAdmin, but didn't try others to compare or recommend anything.

One more thing you can do if you don't want to struggle with updates,
version, etc, is to use docker maybe, you just run the image on any system
and you can replicate the actual production environment anywhere.

El sáb., 14 mar. 2020 a las 14:07, Walter Lee Davis ()
escribió:

>
>
> > On Mar 14, 2020, at 12:17 PM, Rob Jonson 
> 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  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 
> 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 ()
> 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 

Re: [Rails] Is it worth switching to Postgresql?

[Walter Lee Davis]

> On Mar 14, 2020, at 12:17 PM, Rob Jonson  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  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  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 () 
>> 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 

Re: [Rails] Is it worth switching to Postgresql?

[Rob Jonson]

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?)
do you have problems with string encoding incompatibilities in obscure
email addresses?
do you have a convenient gui for browsing (like SequelPro)
are there other similar annoyances, or does it 'just work'

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)

cheers,

Rob




On Sat, 14 Mar 2020 at 15:17, Phil Edelbrock  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 
> 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 ()
> 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.

Re: [Rails] Is it worth switching to Postgresql?

[Phil Edelbrock]

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  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 ( >) 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 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/BE54840B-0F95-4AB6-831B-90A3205AD2A6%40gmail.com.

Re: [Rails] Is it worth switching to Postgresql?

[Ariel Juodziukynas]

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 ()
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.

[Rails] Is it worth switching to Postgresql?

[Rob Jonson]

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.