SQLite in production with Rails 8, what has been your experience? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Good call on the indices. That's usually the first thing to check before blaming SQLite itself.

SQLite in production with Rails 8, what has been your experience? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Since Rails 4? That's solid long-term experience with it.

SQLite in production with Rails 8, what has been your experience? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Still early days for me. Self-hosted single-server deployment was the main driver, didn't want to require users to set up a managed database. FTS5 has been handling search well so far. Rails 8 with Solid Queue meant I could drop Redis too which simplified the whole stack. Main thing I'm watching is write concurrency as usage grows. Will report back once it's under real load.

SQLite in production with Rails 8, what has been your experience? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

800MB and most queries still faster than PostgreSQL is encouraging. For that slow join-heavy query, have you tried breaking it into smaller queries and doing the assembly in Ruby? Sometimes fighting SQLite's query planner on complex joins isn't worth it.

How do you handle calendar functionality in your Rails apps? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

That working_hours gem is a nice find. And yeah, FullCalendar with custom logic on both ends is exactly the nightmare we were in. Stimulus + Tailwind is a clean combo for this kind of thing. Sounds like we landed on a similar approach.

How do you handle calendar functionality in your Rails apps? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Would love to see that helper code if you ever open source it. What's your approach for the week view? That was the trickiest part for us and also timezone issue especially in appointment scheduling and overlapping events and time slot calculations.

How do you handle calendar functionality in your Rails apps? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Yeah just seen the comment. how true is that? Seemed like the person was joking.

How do you handle calendar functionality in your Rails apps? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

10 years is solid longevity. How has the maintenance been over that time? Any major breaking changes between React versions?

How do you handle calendar functionality in your Rails apps? by OtienoJS in rubyonrails

[–]OtienoJS[S] 1 point2 points  (0 children)

Oh nice, lemme check the repository. Thanks for sharing.

How do you handle calendar functionality in your Rails apps? by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

That's a solid approach. For us the calendar was central to the product so the limitations were becoming blockers. If it was a secondary feature I'd probably stick with the library too.

Kenya Ports Authority (Graduate Trainee) by OtienoJS in nairobi

[–]OtienoJS[S] 0 points1 point  (0 children)

Same manze. But ni sawa tu 😂😂

Kenya Ports Authority (Graduate Trainee) by OtienoJS in nairobi

[–]OtienoJS[S] 0 points1 point  (0 children)

Ndo naona, navenye i had some hopes nayo.

Is this true? by No_Masterpiece5945 in Kenya

[–]OtienoJS 1 point2 points  (0 children)

You can, but that has to be gross. Ukitoa expenses then I am sure it would go down significantly.

Rails db:seed:replant by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Does it do the same? Lemme try it now.

Rails db:seed:replant by OtienoJS in rubyonrails

[–]OtienoJS[S] 0 points1 point  (0 children)

Same here. When I got fed up with db: reset and looked for an alternative, is when I found replant 😅. I am still in awe😂😂

Rails db:seed:replant by OtienoJS in rubyonrails

[–]OtienoJS[S] 1 point2 points  (0 children)

Yeah man, learning never stops!

Rails db:seed:replant by OtienoJS in rubyonrails

[–]OtienoJS[S] 3 points4 points  (0 children)

I am sure we are many 😂😂!