'%20xmlns:inkscape='http://www.inkscape.org/namespaces/inkscape'%20xmlns:sodipodi='http://sodipodi.sourceforge.net/DTD/sodipodi-0.dtd'%20xmlns='http://www.w3.org/2000/svg'%20xmlns:svg='http://www.w3.org/2000/svg'%3e%3cdefs%20id='defs848'%20/%3e%3csodipodi:namedview%20id='namedview846'%20pagecolor='%23505050'%20bordercolor='%23eeeeee'%20borderopacity='1'%20inkscape:pageshadow='0'%20inkscape:pageopacity='0'%20inkscape:pagecheckerboard='0'%20showgrid='false'%20inkscape:zoom='6.3203125'%20inkscape:cx='64'%20inkscape:cy='64'%20inkscape:window-width='1920'%20inkscape:window-height='1017'%20inkscape:window-x='1912'%20inkscape:window-y='-8'%20inkscape:window-maximized='1'%20inkscape:current-layer='Layer_3'%20/%3e%3ctitle%20id='title837'%3eArtboard%20111%3c/title%3e%3cpath%20d='M97.092,36.078H30.908a2.111,2.111,0,0,0,0,4.222H97.092a2.111,2.111,0,0,0,0-4.222Z'%20id='path839'%20style='fill:%23ffffff'%20/%3e%3cpath%20d='M97.092,61.889H30.908a2.111,2.111,0,0,0,0,4.222H97.092a2.111,2.111,0,0,0,0-4.222Z'%20id='path841'%20style='fill:%23ffffff'%20/%3e%3cpath%20d='M97.092,87.7H30.908a2.111,2.111,0,0,0,0,4.222H97.092a2.111,2.111,0,0,0,0-4.222Z'%20id='path843'%20style='fill:%23ffffff'%20/%3e%3c/svg%3e)
Rewriting My Website with Deno, Fresh, Drizzle, and Turso
I recently undertook the exciting task of rewriting my website to leverage the latest tools and technologies to make development and content management more efficient and enjoyable. Here's a concise summary of the major changes and tools I used in this overhaul.
Database Operations with Drizzle and Turso
Drizzle
For database operations, I opted for Drizzle, which provides a typesafe and declarative approach to SQL. It integrates seamlessly with TypeScript, ensuring that my schema and queries remain type-safe.
Turso
Turso acts as the database layer. It’s optimized for edge deployment, ensuring fast query performance no matter where the end-user is located. This is particularly beneficial in a global context, minimizing latency and improving user experience.
Uploadthing for Asset Management
For handling asset uploads, particularly for blog post images and downloadable content, I integrated Uploadthing. This tool made it easy to facilitate file uploads without constructing a complex backend. The Uploadthing API streamlined the upload process, saving development time while also providing a robust solution for asset management.
Dynamic Content Management
One of the primary goals was to eliminate the need to modify the source code for content updates. To achieve this, I implemented features that allow for creating and editing:
- Blog Posts
- Downloadable Content
- Project Entries
These functionalities were built into the admin panel of the website, allowing me to manage content dynamically. Using Fresh for frontend components and Drizzle for database interactions, I could build a user-friendly interface ensuring that adding or editing content does not require direct code changes.
Conclusion
Rewriting my website using modern tools like Deno, Fresh 2.0 Alpha, Drizzle, and Turso has been a refreshing experience. These changes not only improved the performance and scalability of the site but also enhanced the developer experience. With the inclusion of Uploadthing for asset management and dynamic content management features, I am now able to focus more on creating content rather than grappling with technological overheads.
Showcase
