Post AcmJDUiQICApdj25Ls by judell@social.coop
 (DIR) More posts by judell@social.coop
 (DIR) Post #Acm4C49I5BDhduSc9w by judell@social.coop
       2023-12-12T22:37:16Z
       
       0 likes, 0 repeats
       
       All the Steampipe plugins are now also:- standalone Postgres foreign data wrapper (FDW) extensions that translate APIs to foreign tables- SQLite extensions that transate APIs to virtual tables- standalone binaries that export data from APIsIt's kind of a big deal! I'm especially curious to know what @simon thinks about all the new SQLite extensions that just appeared in the world.https://steampipe.io/blog/2023-12-sqlite-extensions#steampipe #postgres #sqlite
       
 (DIR) Post #Acm4C57uRni2fup1e4 by simon@fedi.simonwillison.net
       2023-12-13T17:53:44Z
       
       0 likes, 0 repeats
       
       @judell Oh these are SO cool!Possible bug report: I just tried out the Hacker News .so SQLite extension and it seems to output a bit of debug information before returning results - the first three lines in this screenshot
       
 (DIR) Post #AcmE2L1lTMHcdWwN1M by judell@social.coop
       2023-12-13T19:43:42Z
       
       0 likes, 0 repeats
       
       @simon Hmm. I'm not seeing that if I load this way:sqlite> .load /home/jon/steampipe-sqlite/steampipe_sqlite_hackernews.sosqlite> select id, title from hackernews_new limit 3;38633133|US police agencies took intelligence directly from IDF, leaked files show38631586|Something Was Wrong38632944|Norway will allow seabed mineral exploration in the Arctic regionIs there something we could/should do differently to cooperate better with sqlite-utils?
       
 (DIR) Post #AcmIUTrobIK5ycxg0G by simon@fedi.simonwillison.net
       2023-12-13T20:33:16Z
       
       0 likes, 0 repeats
       
       @judell That's weird - I got it for both sqlite-utils --load-extension and for datasette --load-extension - both on macOS ARM - in both cases they printed extra stuff out to standard outDidn't see that with the other plugins I tried, just the Hacker News one
       
 (DIR) Post #AcmIiVe4mkGvXxDzNI by simon@fedi.simonwillison.net
       2023-12-13T20:34:07Z
       
       0 likes, 0 repeats
       
       @judell Looks like it was this debugging code: https://github.com/turbot/steampipe-plugin-hackernews/blob/d2a427c141c9fc6bc42dfbd2d0c790671b3b39ef/hackernews/item.go#L67-L71
       
 (DIR) Post #AcmJDUiQICApdj25Ls by judell@social.coop
       2023-12-13T20:38:47Z
       
       0 likes, 0 repeats
       
       @simon Huh. Ok, we'll take a look. Thanks!