I am a long-term #KDEPIM user and recently read that due to progress in #SQLite’s performance #Akonadi is now defaulting to that DB on a fresh install.
A few days ago I took the chance and ran `akonadi-db-migrator --newengine sqlite` and it was both painless and I definitely see both lower resource consumption and the PIM suite seems much snappier too!
Base
Today I finally caved and purchased the full version of Base, a SQLite database editor for Mac. It's by no means cheap, but after just having used ChatGPT to update a table schema manually via the sqlite3 CLI, I was fed up when I realized I had to to it all again once more, on another table. Bought the In-App Purchase and did it in the GUI app in 1 minute. Can't say it felt great forking over almost €35, but I hope it'll be of use in the future. After all, I convert almost all of my […]Продуктовые метрики: пример расчета на SQL
У нас есть продукт и нам нужно рассчитать ключевые метрики, которые показывают здоровье продукта: - DAU/MAU – вовлеченность - Conversion Rate – конверсия в целевое действие (у нас это создание объявления) - Retention – удержание пользователей - LTV – жизненная ценность клиента - ARPPU – средний доход с платящего пользователя В статье разберем последовательный расчет с примером синтетических данных и готового кода на SQL.
https://habr.com/ru/articles/1010980/
#sql #sql_server #sqlite #разбор_задач #анализ_данных #метрики #метрики_продукта #карьера_аналитика #карьера_аналитика_данных #карьера_аналитиков
Bobby 49.0.4 is out!
mostly code cleanup. but also added a keyboard shortcut to reload a file (Ctrl+R) until I implement automatic change detection.
LiteBI Studio 1.8.0 has been released.
New in this version:
- guided onboarding from import to dashboard
- improved factory reset coverage
- expanded wiki with screenshots
- new Circuit theme for sharper presentations
- end-to-end example incl. demo backup
Browser-based. Local-first. No telemetry.
#OpenSource #SQLite #BusinessIntelligence #WebApp #Privacy #reflectIT
Rebuild of the site is live!
(now using #Svelte #SvelteKit #TypeScript #SQLite #GitLab)
Soft launch of a fun new feature: find all setlists where one or more specific songs were played (or not played):
➔ https://almost-dead.net/find/
Matija Šuklje
oelna
benzogaga33 
Oliver Andrich
Habr
Hylke Bons 🥜
Christoph Hermanns
Andrey [0xdc, 0x09];
The Old Geek Diary
Almost-Dead.net