aissam-en

Remove all empty lines in VSCode using regex

Steps

1. Ctrl + H (Windows/Linux)
2. click the .* icon ("Use Regular Expression")
3. in the Find field, use:

^(\s)*$\n

4. leave the Replace field empty

aissam-en

The benchmark :

$ time psql -h localhost -U laravel_user -d test_db -c "select 1;"
Password for user laravel_user:
 ?column?
----------
        1
(1 row)

real 0m0.962s

aissam-en

1. Install Python 3.10 using Deadsnakes PPA

Ubuntu 24.04 comes with a newer Python version. But Rasa 3.6 only works with Python 3.8 to 3.10 Rasa Docs.

So we’ll install Python 3.10 from a trusted source called Deadsnakes :

# Update the system
sudo apt update && sudo apt upgrade -y

# Install software that allows adding repositories

aissam-en

-- SQL query to list all PostgreSQL sequences, their current last_value, and whether they are behind the maximum id in their corresponding tables.
-- Useful for debugging duplicate key errors caused by manual inserts or broken auto-increment.

SELECT
    n.nspname AS schema,
    c.relname AS sequence_name,
    t.relname AS table_name,
    a.attname AS column_name,
    s.last_value,
    (SELECT MAX(x) FROM (

aissam-en

• install postgreSQL

sudo apt install postgresql

• set password :

     sudo -u postgres psql template1
     ALTER USER postgres with encrypted password 'my_passwordy';
     \q

aissam-en

Create service file :

sudo nano /etc/systemd/system/my_app.service

The content of my_app.service file:

[Unit]
Description=Springboot app for BLABLA (test-env)
After=syslog.target network.target