I built a small CLI tool in Python to help me catalog homeware items for a personal interior design project. It uses SQLite to store product details and generates simple reports. Here's the core function for adding items:
python
import sqlite3
def add_item(name, category, price, material):
conn = sqlite3.connect('homeware.db')
c = conn.cursor()
c.execute('''CREATE TABLE IF NOT EXISTS items
(name TEXT, category TEXT, price REAL, material TEXT)''')
c.execute("INSERT INTO items VALUES (?, ?, ?, ?)", (name, category, price, material))
conn.commit()
conn.close()
print(f"Added {name} to the catalog.")
Example usage
add_item('Ceramic Vase', 'Vases', 29.99, 'Ceramic')
add_item('Wall Mirror', 'Mirrors', 89.99, 'Glass')
https://infinitydecor.co.uk/collections/homeware
This makes it easy to track stylish accents like planters and candle holders across rooms. I love how it keeps everything organized. Have you used SQLite for any home-related projects?
Top comments (3)
Really cool project! I've used SQLite to track my wine cellar inventory before—it's amazing how handy a simple DB can be for home organization. Have you thought about adding photos via BLOBs or linking to external images?
That's a neat way to keep track of things! I've used SQLite for a small recipe manager, and it's surprisingly handy for personal projects like this. Do you have any plans to add a search or filter function to your tool?
Nice and clean! SQLite is perfect for small projects like this. I’ve used it to track my tool inventory in the garage way easier than digging through drawers to find what I need.