Re: Ocurrence of Sequel::DatabaseDisconnectError at puma worker, even though the db is disconnected in puma's before_fork-hook

2021-03-02 Thread Armin Wurzinger
Am 03.03.2021 00:35, schrieb Jeremy Evans: On Tue, Mar 2, 2021 at 12:30 PM Armin Wurzinger wrote: Am 02.03.2021 20:35, schrieb Jeremy Evans: On Tue, Mar 2, 2021 at 10:24 AM armin wrote: Hello! I have a hanami 1.3 app, but the issue should be unrelated to hanami. I want to connect to a

Re: Add SQL comments in migrations

2021-03-02 Thread Mark Allen
Thanks Jeremy, I just opened up https://github.com/jeremyevans/sequel-annotate/pull/21 On Tue, Mar 2, 2021 at 2:39 PM Jeremy Evans wrote: > On Tue, Mar 2, 2021 at 10:44 AM Mark Allen wrote: > >> Jeremy, I noticed that column comments show up in the annotations from >> sequel-annotate gem which

Re: journal_mode PRAGMA on Sqlite

2021-03-02 Thread Jeremy Evans
On Tue, Mar 2, 2021 at 12:38 PM Immi wrote: > Hello all > > I'd like to change the journal mode on the Sqlite database that I'm > connecting to. > Looking at `connection_pragmas in the shared sqlite adapter, it doesn't > seem to be supported though. > > Can I access the underlying Sqlite3 db

Re: Ocurrence of Sequel::DatabaseDisconnectError at puma worker, even though the db is disconnected in puma's before_fork-hook

2021-03-02 Thread Jeremy Evans
On Tue, Mar 2, 2021 at 12:30 PM Armin Wurzinger wrote: > Am 02.03.2021 20:35, schrieb Jeremy Evans: > > On Tue, Mar 2, 2021 at 10:24 AM armin wrote: > > Hello! > > > I have a hanami 1.3 app, but the issue should be unrelated to hanami. I > want to connect to a second db with plain Sequel-gem.

journal_mode PRAGMA on Sqlite

2021-03-02 Thread Immi
Hello all I'd like to change the journal mode on the Sqlite database that I'm connecting to. Looking at `connection_pragmas in the shared sqlite adapter, it doesn't seem to be supported though. Can I access the underlying Sqlite3 db object somehow and do it there directly? Is there a reason

Re: Ocurrence of Sequel::DatabaseDisconnectError at puma worker, even though the db is disconnected in puma's before_fork-hook

2021-03-02 Thread Armin Wurzinger
Am 02.03.2021 20:35, schrieb Jeremy Evans: On Tue, Mar 2, 2021 at 10:24 AM armin wrote: Hello! I have a hanami 1.3 app, but the issue should be unrelated to hanami. I want to connect to a second db with plain Sequel-gem. Therefore I define the connection in hanami's

Re: Add SQL comments in migrations

2021-03-02 Thread Jeremy Evans
On Tue, Mar 2, 2021 at 10:44 AM Mark Allen wrote: > Jeremy, I noticed that column comments show up in the annotations from > sequel-annotate gem which is awesome! However, table-level SQL comments do > not seem to make it through to the model annotations, and I don't see any > specs that include

Re: Ocurrence of Sequel::DatabaseDisconnectError at puma worker, even though the db is disconnected in puma's before_fork-hook

2021-03-02 Thread Jeremy Evans
On Tue, Mar 2, 2021 at 10:24 AM armin wrote: > Hello! > > I have a hanami 1.3 app, but the issue should be unrelated to hanami. I > want to connect to a second db with plain Sequel-gem. Therefore I define > the connection in hanami's `config/environment.rb`, which is required in >

Re: Add SQL comments in migrations

2021-03-02 Thread Mark Allen
Jeremy, I noticed that column comments show up in the annotations from sequel-annotate gem which is awesome! However, table-level SQL comments do not seem to make it through to the model annotations, and I don't see any specs that include table comments either here:

Ocurrence of Sequel::DatabaseDisconnectError at puma worker, even though the db is disconnected in puma's before_fork-hook

2021-03-02 Thread armin
Hello! I have a hanami 1.3 app, but the issue should be unrelated to hanami. I want to connect to a second db with plain Sequel-gem. Therefore I define the connection in hanami's `config/environment.rb`, which is required in `config/puma.rb`: ```ruby # config/environment.rb # ... DWH =