grass-sqlite(1grass)

💖 SQLite DATABASE DRIVER 💖

okay bestie, lemme put you on 💅 this is grass-sqlite, and it's literally the default DBMI backend. the main character, no cap. 👑

---

✨ Creating a SQLite database ✨

so here's the tea 🍓: GRASS will automatically create the SQLite database for you if it doesn't exist yet — this happens the moment the first table gets created in the SQLite database. like, you don't gotta do a thing. it's giving self-sufficient. 🦋

all you actually need to do is define the connection (that's literally the next step, keep scrolling babe 👇).

---

🌸 Connecting GRASS to SQLite 🌸

the database name — 'sqlite.db' — is your choice, queen. pick whatever. and the file storage location? also totally up to you, go off. 🎀

and if the database doesn't exist yet? don't stress, it gets automatically created when database content is created:

# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'
db.connect -p

⚠️ okay important: keep those single quotes in that db.connect line, fr fr. note also that the second command uses -p — yes that's the flag, exactly like that.

---

🔥 Supported SQL commands 🔥

all the SQL commands that SQLite supports. all of them. periodt. 💅

(for the limitations tho, go check the SQLite help page: SQL As Understood By SQLite and Unsupported SQL — iykyk)

---

⭐ Operators available in conditions ⭐

all the SQL operators that SQLite supports. every single one. slay. ✨

---

🦋 Browsing table data in DB 🦋

a convenient SQLite front-end is sqlitebrowser. icon behavior honestly. 💜

to open a DB file that lives inside the current mapset, here's the suggested way (and yes this corresponds to that database connection from up above ⬆️):

# fetch GRASS variables as shell environment variables:
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite/sqlite.db

🙈 bestie use double quotes in that sqlitebrowser line, and note that the eval \g.gisenv`` uses backticks — copy it exactly, don't freestyle it.

---

👀 SEE ALSO 👀

• db.connect
• db.execute
• db.select
• SQL support in GRASS
• SQLite web site
• SQLite manual
• sqlite - Management Tools

---

💀 SOURCE CODE 💀

available at: SQLite DATABASE DRIVER source code (history)

accessed: Tuesday Sep 08 11:54:02 2026

main index | topics index | keywords index | graphical index | full index

© 2003-2026 GRASS Development Team, GRASS 8.5.0 Reference Manual

---

and that's the whole vibe bestie 🌈 this manual page came to you from GRASS 8.5.0, grass-sqlite(1grass) — go create some tables, you got this 💖✨🎀