English tag hub: same canonical tag strings as the Spanish site (Tags in front matter); this page’s chrome and blurbs are in English.
Posts tagged: Systems
Remaining tables for the time-tracking database
SQL for roles, projects, tasks, worked hours, and permission grants across DBA, admin, web, and anonymous roles.
Read more →Database setup for the time-tracking app
Create DBA/admin/web/anon roles, a control_tiempo schema, the users table, and grants aligned with PostgREST access patterns.
Read more →Designing the database for a time-tracking app
Conceptual tables for users, roles, projects, tasks, and worked hours—the backbone of the decoupled series.
Read more →Debian 11 (Bullseye) installation walkthrough
Prepare boot media, walk the text/graphical installer for language, disk partitioning, user creation, desktop metapackages, and GRUB—aimed at a clean stable workstation or server.
Read more →Decoupled Architectures: Building a Time-Tracking App
Overview of a decoupled stack (Debian, PostgREST, Nginx, React, PostgreSQL) for a small-company time-tracking product.
Read more →Electrum: what it is and why running your own server helps
How Electrum’s client–server model works, what data leaves your device, why public servers can hurt privacy, and which open-source server projects people self-host.
Read more →Etherpad guide: real-time collaboration and group editing
What Etherpad offers, how to install it on Debian, and tips to get more from this open-source editor.
Read more →Focalboard: an all-in-one open source board for tasks and projects
What Focalboard is, how it compares to Trello-style tools, and how to run it with Docker Compose on your own server.
Read more →Future tech trends on the innovation horizon
AI/ML, IoT, 5G, AR/VR, quantum computing, synthetic biology, and blockchain—what each wave optimizes for and why ethical, sustainable deployment needs cross-society dialogue.
Read more →How to choose a laptop: a practical decision guide
Match CPU, RAM, storage, screen size, battery, OS, ports, extras, and budget to your real workload—creative suites, development, gaming, or everyday browsing.
Read more →Free-software productivity tools for Linux and VMs
Office suites, Etherpad, Taskwarrior, Org-mode, Redmine, Nextcloud Deck, Focalboard, chat platforms, CI, and more—mapped to self-hosted workflows on Linux guests.
Read more →Nextcloud with Deck: private cloud and groupware
Nextcloud ecosystem basics, community vs paid tiers, secure install sketch with Nginx, and how Deck fits your task workflow.
Read more →Hardening PostgREST with Nginx and HTTPS
Put Nginx in front of PostgREST, add TLS with Certbot, and outline anonymous login flows that return JWTs.
Read more →JWT Authentication with PostgREST
Why JSON Web Tokens help secure a PostgREST API, and how roles, headers, and PostgreSQL functions fit together.
Read more →PostgREST in Practice: Building a Strong REST API
What a REST API is, why it helps, and how PostgREST exposes PostgreSQL as HTTP resources—with install and first SQL steps.
Read more →Redmine guide: simplified project and task management
Install Redmine on Debian at a high level, understand core modules, and pick plugins that boost delivery hygiene.
Read more →Calling the REST API of the time-tracking app
REST shapes for users, roles, projects, tasks, and hours; OpenAPI documentation; curl examples.
Read more →Taskwarrior guide: efficient task management (and Taskserver sync)
Use Taskwarrior on one machine, then sync tasks across devices with Taskserver—installation and basics.
Read more →Tuqan Phase 0 — Strategic foundation, audit, and initial roadmap
Kicking off the agentic modernization of Tuqan with living documentation, an audit plan, and a prioritized roadmap. First post in the Tuqan series.
Read more →Ubuntu vs Debian: similarities and differences
Shared APT roots and open-source values, then how Ubuntu optimizes for desktop onboarding while Debian prioritizes stability branches and stricter free-software defaults.
Read more →