Home
Projects
Gear
Privacy
Contact Us
GitHub
Code
Our Github Repository
BBAI Backup Cam
Ghost Catcher Cam
Social Distance Desk Ornament
Ultrasonic Security Alarm
R2D2
Coke Drum IoT
Spider Man Web Slinger
Modbus Mega Logger
Ultimate Trike
Clock Crane
Jumbo Laser Etcher
Marshmallow-Rotisserie
Contact Us
ID:
Title:
Lead:
Signature:
<p>I've seen Blog sites over the years like Word Press. They are pretty cool. What interested me about them is that they are database driven versus static content driven. That is, a person doesn't make a single web page and store it on the web server. Rather, they are typing in an editor that then stores the various text fields into a database.</p> <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://www.raisingawesome.site/images/blogimages/blog6-302022.png" alt="" width="500" height="263"></p> <p>So, I thought, how could I do that. I had used<a title="tinyMCE" href="https://www.tiny.cloud/" target="_blank" rel="noopener"> tinyMCE</a> for a work project. It is a WYSIWYG rich text editor that actually is generating HTML markups around your text. Since I first applied it at work, it has got a lot of added features. So, I quickly realized it is my editor of choice. (I'm using it right now!)</p> <p>With the editor side taken care of, I needed a place to store the meta data and body of my blogs produced by tinyMCE. I went with <a href="https://www.sqlite.org/index.html" target="_blank" rel="noopener">SQLite3</a>. It is a database that is stored into a single file! Awesome! It actually only has a handful of datatypes. The reality is, though, numbers and text are pretty much all you need. It's smart with date fields in that if you give it a date, it will stuff it as text, but already formatted for chronological sorting.</p> <p>The benefit of a single file-based approach is that you can mirror your site to a private GitHub repository. In turn, you can backup and restore your entire web application and its database. There is no installation of a giant database like Microsoft SQL or Oracle. However, Microsofts SQL Express has gotten pretty easy to install these days - but nothing as easy as SQL Lite. You can learn how to use it with my prior blog: <a title="SQL" href="LinuxSQLite">https://www.raisingawesome.site/blogs/LinuxSQLite</a></p> <p>To handle the talking to the database, I'm using a Razor Page. There is a C# package available that provides the class to make short work of any transaction.</p> <p>Now, I can brain dump to my heart's content and have very little overhead involved to organize and store the information to our web page. In turn, I have a project diary like I could keep in OneNote, but shared to other enthusiasts.</p>
View in New Tab
Copied! Use Ctrl-V to paste it back at your terminal.
Close