recentpopularlog in

sql

« earlier   
Advanced SQL window functions quiz
Advanced SQL Tutorial for SQL Window Functions. Several quiz questions to test your knowledge of modern sql
sql  quiz 
6 hours ago by osamu.fujimoto
r-dbi/odbc: Connect to ODBC databases (using the DBI interface)
The goal of the odbc package is to provide a DBI-compliant interface to Open Database Connectivity (ODBC) drivers. This allows for an efficient, easy to setup connection to any database with ODBC drivers available, including SQL Server, Oracle, MySQL, PostgreSQL, SQLite and others. The implementation builds on the nanodbc C++ library.
R  sql 
7 hours ago by prcleary
PostgreSQL: Documentation: 9.5: Composite Types
The `(composite_value).*` expansion to columns was new to me. And useful in a recent query I had to write.
postgres  sql  postgresql  database  db 
14 hours ago by hellp
Twitter
Do you have a live example that I can look at re. and ? I think such comparisons would hav…
SQL  Cypher  from twitter_favs
yesterday by danbri
How to Organize Your Messy Albums on Photos.app on macOS with Some SQL and Image Processing
Conclusion
While the SQL is cool enough, it does not allow you to have write access to iCloud. The current PhotoKit on MacOS only allows read-only access. I hope there was an API, so I could do some of the stuff programatically, especially removing the bad quality Photos automatically. My long-term plan is to learn some iOS programming and do these kind of analysis in the app by requesting metadata and thumbnails and, maybe even work with some MLKit magic to cluster my photos.
MacOS  photos.app  sqlite  OpenCV  sql  sysadmin 
yesterday by euler
presto optimization advice
some random, but useful, presto optimization advice
presto  optimization  performance  sql 
yesterday by tswaterman

Copy this bookmark:





to read