;; this works great for a single insert
(dbi:do-sql *sql-connection*
   			(sql-insert* "company" `(:Ticker "lssasdfasdfdfkdjf"
                                     :Company "lskjdf"
                                     :CIK "234")))
                                     
;; however if i setup a loop to read in 1000s of entries from a hash table
;; this creates a new connection each insert and is very slow:
(loop ...over-a-hash-table
  (dbi:do-sql *sql-connection*
              (sql-insert* "company" `(:Ticker "lssasdfasdfdfkdjf"
                                       :Company "lskjdf"
                                       :CIK "234"))))
                                      
;; this doesn't work because dbi:do-sql expects specific arguments i think
(dbi:do-sql *sql-connection*
			(loop ...over-a-hash-table
   			  (sql-insert* "company" `(:Ticker "lssasdfasdfdfkdjf"
                                       :Company "lskjdf"
                                       :CIK "234"))))