44°F

Aaron Parecki

  • Articles
  • Notes
  • Photos

#sql

  • Aaron Parecki
    Any clever SQL people out there? Given the raw data on the left, (a table of test results) how do I write a SQL query to give me the results on the right, (the results grouped by date as well as grouped by result)?
    Portland, Oregon, USA • 57°F
    6 likes 3 reposts 12 replies 1 mention
    #sql
    Fri, Sep 16, 2022 8:51am -07:00
  • Hosting SQLite databases on Github Pages - (or any static file hoster) - phiresky's blog (phiresky.github.io)
    #sqlite #static #web #sql #database
    Sun, May 2, 2021 4:37pm -07:00
  • Run SQL on JSON files -- without any data loads (citusdata.com)
    #database #json #sql
    Sun, Aug 24, 2014 8:59am -07:00
  • Window Functions (www.postgresql.org)
    #database #documentation #postgres #sql #tutorial
    Sat, Aug 25, 2012 9:56am -07:00
  • (My)SQL mistakes. Do you use GROUP BY correctly? (www.dbasquare.com)
    #db #mysql #sql
    Wed, May 16, 2012 8:09am -07:00
  • WhySQL? (blog.evernote.com)
    #evernote #hardware #sql #technology
    Thu, Feb 23, 2012 8:36am -08:00
  • Sorting a query in MySQL ignoring the word "The"

    When you have a database of books or movies, some of the titles begin with "The." If you do a regular ORDER BY on the table, all the titles that start with "the" get clumped together. One option is running an unsorted query and sorting in PHP, but it would be better to sort at the database level. Here is a query I came up with to do that, using an IF function in MySQL!
    continue reading...
    #code #database #MySQL #sorting #SQL
    Sat, Apr 19, 2008 9:50pm -07:00
next

Hi, I'm Aaron Parecki, Senior Security Architect at Okta, and co-founder of IndieWebCamp. I maintain oauth.net, write and consult about OAuth, and participate in the OAuth Working Group at the IETF. I also help people learn about video production and livestreaming and dabble in product design.

I've been tracking my location since 2008 and I wrote 100 songs in 100 days. I've spoken at conferences around the world about owning your data, OAuth, quantified self, and explained why R is a vowel. Read more.

  • Security Architect at Okta
  • IndieWebCamp Founder
  • OAuth WG Member

  • 🎥 YouTube Tutorials and Reviews
  • 🏠 We're building a triplex!
  • ⭐️ Life Stack
  • ⚙️ Home Automation
  • All
  • Articles
  • Bookmarks
  • Notes
  • Photos
  • Replies
  • Reviews
  • Trips
  • Videos
  • Contact
© 1999-2023 by Aaron Parecki. Powered by p3k. This site supports Webmention.
Except where otherwise noted, text content on this site is licensed under a Creative Commons Attribution 3.0 License.
IndieWebCamp Microformats Webmention W3C HTML5 Creative Commons
WeChat ID
aaronpk_tv