SQLite 目前在規劃的 Strict Table，以及我從來不知道原來可以這樣惡搞… – Gea-Suan L...
source link: https://blog.gslin.org/archives/2021/08/24/10290/sqlite-%e7%9b%ae%e5%89%8d%e5%9c%a8%e8%a6%8f%e5%8a%83%e7%9a%84-strict-table%ef%bc%8c%e4%bb%a5%e5%8f%8a%e6%88%91%e5%be%9e%e4%be%86%e4%b8%8d%e7%9f%a5%e9%81%93%e5%8e%9f%e4%be%86%e5%8f%af%e4%bb%a5%e9%80%99/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
SQLite 目前在規劃的 Strict Table，以及我從來不知道原來可以這樣惡搞...
在 Hacker News Daily 上看到「STRICT Tables」這篇，在講 SQLite 目前在規劃 strict table，對應的討論可以參考「Strict Tables – Column type constraints in SQLite - Draft (sqlite.org)」這邊。
我在 draft 文件開頭看到這個驚人的事實：轉型失敗的時候會直接寫進去，不是錯誤或是 0 或是 NULL 之類的值 XDDD
For example, if a table column has a type of "INTEGER", then SQLite tries to convert anything inserted into that column into an integer. So an attempt to insert the string '123' results in an integer 123 being inserted. But if the content cannot be losslessly converted into an integer, for example if the input is 'xyz', then the original string is inserted instead. See the Datatypes In SQLite document for additional information.
實際上測試建了一個表格測試：
SQLite version 3.31.1 2020-01-27 19:55:54 Enter ".help" for usage hints. sqlite> CREATE TABLE a (id INTEGER PRIMARY KEY NOT NULL, col1 INTEGER); sqlite> INSERT INTO a (id, col1) VALUES (1, 'a'); sqlite> SELECT * FROM a; id col1 ---------- ---------- 1 a
我果然跟 SQLite 不熟...
Related
Canonical 推出的 Dqlite (High-Availability SQLite)
第一眼看到的時候直接有種不知道 Canonical 在幹什麼的感覺，翻完說明後大概知道可以用的地方，但還是覺得範圍有點小：「Dqlite - High-Availability SQLite」。 一種使用情境是，在 embedded system 上面同步資料的一種方案... 吧？例如網路連線的頻寬或是品質受限，無法順利傳到 Internet 端的伺服器上，所以希望在本地端就可以解決一些事情，但又不方便在本地端直接弄個 PostgreSQL 出來？ Dqlite is a fast, embedded, persistent SQL database with Raft consensus that is perfect for fault-tolerant IoT and Edge devices. 另外一個是用到了 C 實做的 Raft 協定： Dqlite (“distributed SQLite”) extends SQLite across a cluster of machines,…
September 3, 2019In "Computer"
Dolt，本機開發測試用的 MySQL server
看到「Dolt is Git for Data!」這個專案，是個在本機上跑的 MySQL server，另外可以在上面的資料進行版本控制，看起來很適合本機開發測試。 首先抓下來可以看到沒幾個檔案 (這是 linux-amd64 版)，也可以看到跟 Git 的關係： $ tree . ├── bin │ ├── dolt │ ├── git-dolt │ └── git-dolt-smudge └── LICENSES 然後用 bin/dolt sql-server -P 3307 -u root -p passw0rd 跑就可以把一個相容於 MySQL 的伺服器跑在 port 3307，然後用 mysql -h 127.0.0.1 --port 3307 -u root…
March 15, 2021In "Computer"
DuckDB
看到篇有趣的介紹，在講 DuckDB：「DuckDB」。 [I]t uses the PostgreSQL parser but models itself after SQLite in that databases are a single file and the code is designed for use as an embedded library, distributed in a single amalgamation C++ file (SQLite uses a C amalgamation). 看起來是個以 OLAP 為中心而設計出來的資料庫，然後在 Python 下可以直接透過 pip 裝起來。 看起來像是個用單機拼…
September 20, 2020In "Computer"
Author Gea-Suan LinPosted on August 24, 2021Categories Computer, Database, Murmuring, Programming, SoftwareTags constraint, data, database, datatype, db, draft, integer, rdbms, sqlite, strict, string, table, type Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
Comment
Name *
Email *
Website
Notify me of follow-up comments by email.
Notify me of new posts by email.
Post navigation
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK