SNOBOL4SQLITE3DBM(3)

💖 SNOBOL4SQLITE3DBM 💖

okay bestie, welcome to the SNOBOL4SQLITE3DBM(3) page, straight outta the CSNOBOL4 Manual ✨ this is the moment, this is the vibe, let's go 🫶

---

✨ NAME ✨

snobol4sqlite3dbm — a "dbm" style interface for SNOBOL4 using SQLite3 💅

---

🌸 SYNOPSIS 🌸

-INCLUDE 'sqlite3dbm.3'

        dbhandle = SQL3DBM_OPEN(file,flags,mode)

        SQL3DBM_CLOSE(dbhandle)

        SQL3DBM_STORE(dbhandle,key,datum,flags)

        datum = SQL3DBM_FETCH(dbhandle,key)

        SQL3DBM_DELETE(dbhandle,key)

        key = SQL3DBM_FIRSTKEY(dbhandle)

        key = SQL3DBM_NEXTKEY(dbhandle)

        SQL3DBM_ERRMSG(dbhandle)

---

🦋 DESCRIPTION 🦋

So like, it's a DBM compatible interface for snobol4(1) that runs on the sqlite3 embedded database engine, and — the way that this is genuinely iconic — it lets multiple processes access it at the same time 😭👑

🎀 SQL3DBM_OPEN

takes a filename (STRING), and ignores any additional arguments, and returns a database handle 💖 yes, it really just ignores the extra stuff. no cap.

🎀 SQL3DBM_CLOSE

takes a database handle and closes it. bye bestie 🫶

🎀 SQL3DBM_STORE

takes a database handle, a key, a value, and a flag, one of SQL3DBM_INSERT or SQL3DBM_REPLACE.

🎀 SQL3DBM_FETCH

takes a database handle and a key and returns a datum (if any) stored with that key. if there's nothing there, that's just the vibe 🙈

🎀 SQL3DBM_DELETE

takes a database handle and a key and deletes the stored datum (if any).

🎀 SQL3DBM_FIRSTKEY

takes a database handle and returns a database key 🔑

🎀 SQL3DBM_NEXTKEY

takes a database handle and returns a database key when called after SQL3DBM_FIRSTKEY. so like, first key first, then next, okay? order matters fr fr.

🎀 SQL3DBM_ERRMSG

takes a database handle and string for the last sqlite3 database error 💀 nothing like a lil error message to humble you.

---

🌈 COMPATIBILITY 🌈

database compatible with Python sqlite3dbm 🐍✨ slay, interoperability.

---

⭐ SEE ALSO ⭐

• snobol4(1)
• snobol4dbm(3)
• sqlite3(1)

---

👑 AUTHOR 👑

Philip L. Budne 💜

---

CSNOBOL4B 2.3.1 · March 31, 2022 — and that's the whole page, bestie, go forth and database 🦋💖✨ mwah!