Join the community and use our helpful tools to stay focused and take your product to the next level. Take charge of your product development today with Makerlog!
Managed to make raw sqlite db query in Strapi! Added a new streak route and a controller method using `strapi.connections.default.raw("SELECT author, strftime('%d-%m-%Y %H:%M:%f', published_at/1000.0, 'unixepoch') FROM posts ORDER BY author DESC");` Had to wrangle with epoch time (wut is this!?) vs unix timestamp! 🤪 Not completely there yet but at least now I can query the `author` and `published_at` dates and see the output on my api client. Next steps - install date-streaks package and integrate it to calculate streaks, figure out how to query in production db since its Postgres 😩
