trying to figure out why my friend's boundary upsets me. Also, missing my dad, who died almost 4 years ago in c/[email protected]

[–] [email protected] 2 points 1 month ago (3 children)

My aunt violates my boundaries a lot but I can't stand to be away from her. I feel kind of "stuck" with being hurt. It's an awful feeling. I hope your friend doesn't get stuck like this

BBC staffers reveal editor's 'entire job' to whitewash Israeli war crimes in c/[email protected]

[–] [email protected] 18 points 1 month ago (4 children)

why was the cross post deleted

Layaway in c/[email protected]

[–] [email protected] 5 points 1 month ago

the only chain I want is

.

actually this joke is getting tired just kill ceos

@lemmy.ml in c/[email protected]

[–] [email protected] 0 points 1 month ago

In your mix.exs file, ensure you have the SQLite adapter:

defp deps do [ {:ecto_sql, "~> 3.9"}, {:ecto_sqlite3, "~> 0.10"}, # ...other Pleroma dependencies ] end

In your config/prod.exs (or dev.exs/test.exs as appropriate):

config :pleroma, Pleroma.Repo, adapter: Ecto.Adapters.SQLite3, database: "/var/lib/pleroma/pleroma.sqlite3", pool_size: 5

Then, in the terminal, run migrations:

mix ecto.create mix ecto.migrate

Start the server:

mix phx.server Hello! There’s no official Pleroma documentation for a full SQLite install, but it is feasible by swapping out the Postgres adapter for Ecto.Adapters.SQLite3. The main points to watch for:

Dependencies: Add the ecto_sqlite3 dependency. Configuration: Update the :pleroma, Pleroma.Repo settings to point to Ecto.Adapters.SQLite3 and specify a path for the SQLite file. Migrations: Run your migrations with mix ecto.create and mix ecto.migrate. Minimizing DB storage

Use VACUUM periodically to reclaim unused space: elixir Copy code Pleroma.Repo.query!("VACUUM;") Prune old posts and media attachments. Pleroma’s configuration allows for limiting media retention, so consider adjusting instance.remote_post_retention_days (and similar) to reduce stored data. Keep an eye on logs or ephemeral data that might accumulate in the database. Tuning relevant config entries (for example, disabling certain analytics features or adjusting retention settings) can help keep your SQLite file size low. Hope this helps!