Hey Folks, I am looking for a way to use SQLite in RhinoPython. Since Rhino uses IronPython 2.7 and the sqlite3 module is part of the standard library since Python 2.5, I don’t quite understand why I can’t just call: import sqlite3 This will give me an error, since the module is not available fo…

Hey, sorry for getting back to you just now. I don’t quite understand, why editing the __init__.py is not working for you. I have tried it again just now with Rhino 5 & 6 and it was working fine for me. So unfortunately I can’t really reproduce your error. Anyway, the __init__.py inside the sqlit…

Wonderful - it does what it is supposed to now. I was a little tired and didn’t think of that. Thanks for the quick response (less than two hours) on a thread that was over two years old!

Thank you, finally managed to make it worked using SQL db by this db management system. Didn’t know much about compatibility so had to google it.

For information purposes: The SQLite module is included with Rhino 6 now, so it’s not necessary anymore to install it through this way :slight_smile:

Hi ! Python Newb here, and learning MySQL. Is there any help / reference / tutorials for SQLite in RhinoPython ?

Have you tried referring to the standard CPython documentation? I don’t know if they followed that approach or not, but it might be worth trying it. [image] sqlite3 — DB-API 2.0 interface for SQLite databases — Python 3.9.1 documentation I don’t have Rhino 6 wit…

Hi Andrew, thanks for the link. I want to store info about my blocks (attributes, Rhino ID, volume, area, length, etc…) and make queries through a human UI interface to display the filtered info and evntually select the corresponding objects in Rhino. It is also the basis for generation of BOM tab…

[image] efestwin: For information purposes: The SQLite module is included with Rhino 6 now, so it’s not necessary anymore to install it through this way :slight_smile: OK, this is for the folks like me who are trying to get on the saddle : [First step] Currently following this excellent vi…

If you were to use Rhino 7 you could serialize your geometry to JSON (that is a string) with ToJSON , and put that in your database. Then you’d deserialize with FromJSON .

SQLite in RhinoPython

Scripting

osuire January 19, 2021, 8:04am 19

Lil’ question here : is it at all possible to store Rhino geometry as goo in a SQLite database ?
My first attempt was a failure

Topic		Replies	Views
What is the difference btw. Rhino Developer Tools? Rhino Developer	18	5028	August 13, 2013
Rhino inside Python Rhino.Inside python	135	26255	July 19, 2025
Which DLLs do I need? Rhino Developer	30	3227	March 1, 2019
Which rhinoscriptsyntax functions do you need to have implemented next? Serengeti (Rhino BETA) rhinoscript , python	29	5333	November 30, 2020
Sqlite3 in Grasshopper Grasshopper Developer	2	1532	May 22, 2018

SQLite in RhinoPython

Related topics