Toots for adamghill@indieweb.social account

Written by adamghill on 2025-01-21 at 23:57

Curious to compare https://grantjenks.com/docs/diskcache/tutorial.html#djangocache vs the #SQLite setup I have. It might be less of a hassle to setup at least.

[#]Django

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-21 at 14:39

Time for a mental health day… errr… decade.

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-20 at 19:35

Oooh, replicated iTerm’s next/previous tab switching functionality with these keybindings in Ghostty.

keybind = cmd+opt+right=next_tab
keybind = cmd+opt+left=previous_tab

https://ghostty.org/docs/config/keybind

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-20 at 18:27

Released 0.38.7 of Coltrane, a mini content and app framework built on #Django. 🎶

Coltrane allows you to throw #markdown (and templates) in a folder and serve up #HTML. JSON data, sitemap, RSS, redirects, and includes optional static site generation.

better support for custom sites, including a fix for a gnarly collectstatic bug

support CSRF_TRUSTED_ORIGINS environment variable

📚 https://coltrane.adamghill.com

⚙️ https://github.com/adamghill/coltrane

📦 https://pypi.org/project/coltrane/

https://indieweb.social/@adamghill/113739778975349665

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-20 at 18:09

One thing I'm still investigating: how to make #SQLite as similar to #PostgreSQL as possible via pragmas (https://www.sqlite.org/pragma.html).

I'm ok sacrificing some speed for referential integrity. I'm currently looking into:

PRAGMA strict = ON;

PRAGMA case_sensitive_like = ON;

PRAGMA recursive_triggers = ON;

PRAGMA automatic_index = ON;

PRAGMA encoding = 'UTF-8';

Anyone have experience with these? I'm thinking about modifying @anze3db benchmark in https://blog.pecar.me/django-sqlite-benchmark to see what the impacts are.

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-20 at 15:20

I wrote up how I’m currently using #SQLite in production with #Django because I couldn’t find one place with everything. Hopefully it’s helpful!

https://alldjango.com/articles/definitive-guide-to-using-django-sqlite-in-production

I’d appreciate hearing feedback about anything I might be missing. 💚

=> View attached media

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-19 at 21:13

I work on a lot of side projects, but the UIs all tend to look like a backend developer designed them because… it me. I’m looking to partner up with a designer/UX who can sling HTML/CSS to work with.

I have a lot of ideas (see https://adamghill.com for a few I've already started working on), but maybe you have ideas too?

DM me if you are interested. I'd love to chat.

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-18 at 13:57

I’m using Coolify with uses Caddy under the hood (I think) so maybe I can exclude some paths in a config or something. 🤔 #Django

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-18 at 13:54

Any suggestions for a simple way in #Django to blackhole all these requests for Wordpress things which will never work?

=> View attached media

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-14 at 13:46

https://gkeenan.co/avgb/rss-readers-make-me-want-to-jump-into-a-vat-of-acid/

=> View attached media

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-14 at 04:08

Time for some more reading: https://fractaledmind.github.io/2023/09/07/enhancing-rails-sqlite-fine-tuning/

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-14 at 01:16

Based on https://blog.pecar.me/django-sqlite-benchmark (and https://blog.pecar.me/django-sqlite-dblock) by @anze3db this is my current settings for #Sqlite in #Django. It seems more stable than the default, although I've only done limited testing.

I'm still unsure about the foreign_keys pragma, but coming from PostgreSQL, it at least sounds like something I want.

Feedback appreciated!

=> View attached media

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-12 at 16:58

Feeling pretty happy with this new setup so far:

https://www.djangoproject.com/

https://htmx.org/

https://django-tailwind-cli.readthedocs.io

https://daisyui.com/

https://docs.allauth.org/

https://github.com/danihodovic/django-allauth-ui

[#]Django #Tailwind #CSS #HTMX #HTML

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-12 at 01:06

The HTMX ethos is delightful, but right now I literally only need/want the simplest hx-post (and hx-swap should default to "outerHTML" imo omg). Loading ~50kb for such a minimal use case is making my heart hurt.

do not create a minimal HTMX knockoff, do not create a minimal HTMX knockoff,...

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-05 at 22:15

I realize this is very subjective, but what is the “Postico for SQLIte”? I've looked at most of commonly cited tools and none are really fitting the bill imo. Willing to pay if it's reasonable.

=> More informations about this toot | View the thread

Written by adamghill on 2025-01-04 at 18:31

I get to play my least favorite game “based on my understanding, this code should work, but it obviously does not so I’m missing something what could it be maybe there is a bug in this package oh no I messed up”

=> More informations about this toot | View the thread