Frectonz
3.47K subscribers
1.92K photos
85 videos
32 files
1.65K links
A place for me to talk about my projects, stuff i find on the internet and what I am currently thinking about.

By @frectonz
Download Telegram
Forwarded from Nahom
Screenshot from 2024-04-27 14-02-41.png
26.2 KB
πŸ‘2
Frectonz
Which one?
I like PostgreSQL better.

- Column types not enforced: SQLite doesn't enforce column types, allowing you to insert an integer into a TEXT column or a string into a REAL column.

- No native boolean support: SQLite doesn't support boolean values. Instead, you use an INTEGER column with 1 as true and 0 as false.

- Nullable primary keys: SQLite allows primary keys to be null unless you specify that the primary key is NOT NULL.

- Limited ALTER TABLE support: SQLite has limited support for altering tables. You can only rename a table or add a new column.

- Case-insensitive identifiers: SQLite is case-insensitive when it comes to table and column names.

- Automatic type conversion: SQLite automatically converts values to appropriate types when necessary.

- No RIGHT OUTER JOIN or FULL OUTER JOIN support: SQLite only supports LEFT OUTER JOINs.

- Single writer at a time: SQLite allows only one writer at a time.

- No stored procedures or triggers: SQLite doesn't support stored procedures or triggers.

- No DROP COLUMN support: SQLite doesn't provide a direct way to drop a column from a table.

- No native date/time data type: SQLite does not have native date and time data types.

- Vacuuming: SQLite doesn't automatically reclaim storage space after deleting data.

- SQLite's locking mechanism: SQLite uses a file-level locking mechanism, which means that the entire database file is locked during a write operation.
πŸ‘3
Frectonz
e/eth
Honestly though, i can see e/acc happening for the world but i am cynical about it being applicable here.

Moving to America is the first step in being e/acc.
When the painter half of of PG's brain collides with the programmer half.
πŸ‘1
e/acc
πŸ‘5
Forwarded from Fraol Lemecha
Specialize on your ability to Generalize.
πŸ‘1
Hack me once, ok ..
Hack me twice, you can't I am on Signal 😁
They are going all in on Rust.
πŸ‘3
Frectonz
Photo
They made them train their replacements πŸ’€πŸ˜‚

[mastodon]
born to write rust
forced to make "site analysis" maps
πŸ‘8
Cognitive Defense
πŸ‘2
If I won the lottery I wouldn't tell anyone but there will be signs.
if i had one wish 😭