Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
det.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon Server des Unterhaltungsfernsehen Ehrenfeld zum dezentralen Diskurs.

Administered by:

Server stats:

1.8K
active users

det.social: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.8

#sqlite

2 posts2 participants1 post today
Replied in thread
Public
Crazy-to-Bike

@alexantemachina@mastodon.social

Warum meinst du?
Datenbanken nehmen ja durch eine volle Platte nicht Schaden, im Sinne bereits gespeichertes ist auf einmal weg, sondern, dass neue Daten nicht oder nur korrupt gespeichert werden.

Grundsätzlich verstehe ich auch nicht, warum bei #HomeAssistant als Standard auf #SQlite gesetzt wird. Egal welches System mit Datenbank ich bisher installiert habe, wurde entweder direkt auf #mySQL, #MariaDB oder #Postgres gesetzt, oder zumindest empfohlen, nicht SQlite zu nehmen.

Public *
Yanick Witschi

Here's a challenge for you if you speak C and #PHP fluently. Somehow #SQLite seems to keep materialized CTEs for as long as the process runs which seems like it could break #frankenphp and Co. I'm not sure if my conclusions are correct - I'm pretty confused and would appreciate some insights :) github.com/loupe-php/loupe/pul #help #BoostsAreAppreciated

This took me almost 4 full work days of debugging, running all sorts of debugging tools from blackfire on to valgrind, memprof etc. The background is this: I have a worker process where Loupe is us...
GitHubPrevent SQLite from materializing the CTEs by Toflar · Pull Request #209 · loupe-php/loupeBy Toflar
Public
Habr

Как я прокачал английский до B2 в США, разработав своё языковое приложение

После переезда в США мой английский был на уровне A1. Вместо курсов и приложений я решил создать собственный языковой тренажёр и заодно прокачать себя как fullstack-разработчика. В статье рассказываю как я парсил словари, получил бан, внедрил геймификацию и достиг уровня B2 за год.

habr.com/ru/articles/923680/

ХабрКак я прокачал английский до B2 в США, разработав своё языковое приложениеПредыстория: От A1 к B1+ без очевидных методов После переезда в США в июне 2024 года, я, как и многие, столкнулся с распространенной проблемой – языковым барьером. Мой английский стабильно находился...
#английский_язык#изучение_языка#иммиграция_в_сша
Public
T_X

Does anyone have any recommendations to extract a broken #sqlite database used by @signalapp on #Android on an HTC U11? (note: because the database is broken Signal will crash)
I was thinking about rooting the phone, but unlocking with flashboot would erase the data, right?
Also adb works fine for me, but can't access /data/ due to missing permissions. That's where the database is likely stored though, right?
And this is the issue I'm having: github.com/signalapp/Signal-An.

Guidelines I have searched searched open and closed issues for duplicates I am submitting a bug report for existing functionality that does not work as intended This isn't a feature request or a di...
GitHubSignal keeps crashing a second after opening · Issue #13814 · signalapp/Signal-AndroidBy wpank
Public *
Zash

Looked at #sqlite full text search today, stuffing it full of markdown. Would like to have a minimalist search engine as companion to a static site generator. My search for one resulted in such relevant hits as "you can use google".
Edit: Please, no JavaScript

Public
KungFuDiscoMonkey

Virtual Tables and Django Foreignkeys paultraylor.net/blog/2025/virt

PaulTraylor.net · Virtual Tables and Django ForeignkeysI have been continuing with my virtual table implementation, though taking a short break to do some more integration on the Django side. I have an ideas site that I use as a kind of wiki to keep track of various ideas. # the default model I'm using from my virtual table integration class FrontmatterModel(models.Model): inode = models.PositiveIntegerField(primary_key=True, editable=False) path = models.FilePathField(unique=True, editable=False) slug = models.SlugField() content = models.TextField() excerpt = models.TextField(blank=True) metadata = models.JSONField() class Meta: abstract = True # Custom model for my idea object itself # These also exist in the `metadata` json frontmatter, but putting them here # makes them nicer to deal with from Django class Idea(FrontmatterModel): title = models.CharField(max_length=128) status = models.ForeignKey(Status, on_delete=models.SET_NULL, null=True, db_column="dir") homepage = models.URLField(blank=True) repository = models.URLField(blank=True) focus = models.BooleanField(default=False) date = models.DateTimeField(default=timezone.now) class Meta: required_db_vendor = "markdowndb" managed = False The model ultimately gets sent to the virtual table backend with a statement that looks like this
#django#sqlite
Public
obrhoff

They mentioned in the WWDC that the new LLM Framework can support semantic search. So what is now the best approach to locally search through a SQLite database?

AFAIK SwiftData is not supporting Vector embeddings and compiling a SQLite version with extensions is not so straightforward.
#wwdc25 #iosdev #sqlite

Public
Chris Trott

New blog post: Caveats Using Read-only SQLite Databases from the App Bundle

twocentstudios.com/2025/06/07/

A quick debugging story where I learnan some new things about SQLite's journal mode while building an database export/import feature for Eki Live.

TLDR:

- Journal mode is embedded in the sqlite database file itself.
- The `backup` command changes the journal mode of the target database to match the source database.
- Check the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode;"`.
- Change the journal mode of a database with `sqlite3 db.sqlite "PRAGMA journal_mode=DELETE;"`.

twocentstudios.comCaveats Using Read-only SQLite Databases from the App Bundle
#sqlite#grdb
ExploreLive feeds
About