Pinned Loading

1. tradfri-lights tradfri-lights Public

   'f.lux'-like app for Ikea Tradfri white spectrum smart bulbs and gateway.

   Jupyter Notebook

2. steam-wishlist-extractor steam-wishlist-extractor Public

   Scrape your steam wishlist to detect price changes.

   Python

3. Fastest way to generate a SQL schema... Fastest way to generate a SQL schema from raw data and/or insert data to the table

   1

   # Use Pandas & SQLAlchemy.

   2

   # https://stackoverflow.com/questions/23103962/how-to-write-dataframe-to-postgres-table

   3

   4

   # Note this will create a new table; see the 'faster option' at the above link for a method using 'copy' to an existing table.

   5

   # However, 'copy' cannot do an upsert; that requires inserting to a temp table, then upserting form temp table to destination table.