dejanr

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

dejanr

Ollama + Open WebUI = Local LLM Server

Motivation

This guide helps you deploy a local Large Language Model (LLM) server on your Apple MacBook (Intel CPU or Apple Silicon (M-series)) with a user-friendly chat interface. By running LLMs locally, you ensure data privacy, improve reliability with offline capabilities, and leverage cutting-edge tools for efficient AI workflows

Prerequisites

• macOS 11.0 or later (Intel, Apple Silicon (M-series))
• At least 8 GB of RAM (16 GB recommended for optimal performance)

dejanr

TODOMVC

04.11. MON

• Work on second brain
• Prepare GPT's for AC Germany
• Test 1
• Test 2

dejanr

create table if not exists migrations (
  key text CONSTRAINT pkey PRIMARY KEY
);

create or replace function idempotent(migration_name text,code text) returns void as $$
begin
if exists (select key from migrations where key=migration_name) then
  raise notice 'Migration already applied: %', migration_name;
else
  raise notice 'Running migration: %', migration_name;

dejanr

Effective Date: 17.04.2024

We are committed to protecting your privacy. This Privacy Policy explains our practices regarding the handling of information on our website.

1. No Collection of Personal Information

We do not collect any personal information about you when you visit the Site. As such, we do not store, use, share, or disclose any personal data about our visitors.

2. No Tracking or Cookies

dejanr

{
    "ok": true,
    "messages": [
        {
            "type": "message",
            "user": "U1001",
            "text": "I need help with a server error on project X. Anyone available?",
            "ts": 1713137879.14209,
            "username": "Anastasia Tolmatsch"
        },

dejanr

Using Gmail SMTP with Cloudflare Email Routing: Step-by-Step Guide

Learn how to send emails through Gmail SMTP with Cloudflare Email Routing in this comprehensive guide.

Step 1: Enable 2-Factor Authentication

To proceed with this method, ensure that you have enabled two-factor authentication for your Google account. If you haven't done so already, you can follow the link to set it up → Enable 2FA in your Google account.

Step 2: Create an App Password for Mail

dejanr

//================================================================
// SAMPLE SCRIPT FOR THREE WOW'S ON ONE PC 
//
// Instructions: Copy this entire script (all the blue writing
// on gray background including comments). Save it in a file. 
// Load it into HotkeyNet.
//
// Toggle the scroll lock key to turn hotkeys off and on. (You 
// can change this if you want, just like you can change 
// everything else with HotkeyNet.) 

dejanr

{
  "spacing": {
    "xs": 4,
    "sm": 8,
    "md": 16,
    "lg": 32,
    "xl": 96
  },
  "sizing": {
    "xs": 4,

dejanr

# I used this shell.nix to build LineageOS 13.0 for my maguro (Samsung Galaxy Nexus GSM) phone
# The build instructions for normal Linuxes are here: https://wiki.lineageos.org/devices/maguro/build
# For NixOS, follow those instructions but skip anything related to installing packages
# Detailed instructions:
#   cd into an empty directory of your choice
#   copy this file there
#   in nix-shell:
#    $ repo init -u https://github.com/LineageOS/android.git -b cm-13.0
#    $ repo sync
#    $ source build/envsetup.sh