Posts

Showing posts from May, 2022

SQLite Setup

Image
This is a simple post about how to add and use SQLite to your project.  We will be adding Sqlite to a console app to start with.   We will cover: Why SQLite Add Sqlite Adding the tools needed Create database Making schema changes Apply schema changes Why SQLite SQLite is a free lightweight single-file database that requires no engine.  For its size, it is a great choice for mobile, desktop, and small to medium web applications (SQLite) .  If you are running a large web application or need to support complex joins or queries, this is not the database you want to use. SQLite has an entity framework provider, so all data access is the same as any entity framework application.  Another strong point was using it. For the Blazor applications that I blog about, it is a perfect choice. Defined Project We will be building a simple app to showcase SQLite.  Our model will be a Blog Post:          public class Post      ...

Moving Past simple tutorials

Image
The Plan I have enjoyed the simple examples and solutions I was been building and blogging about.  I have a list of 10-15 full size projects that I want to build and use.  Some examples of these projects include Stock watching, note taker and book reviewer.  I know I can find free and open source applications I could use for these, but I want to build and customize them for my needs.   I decided it is time to treat these projects like a true professional projects.  In doing so, I want to share that experience.  A "professional" project means different things to different people.  My definition is to look at this as if I am the one paying for the creation of these projects.  That means, they need to be clean, maintainable, secure and customizable. The only thing missing from the "professional" part is a timeline.  I have always said you can have it fast, right or good, pick 2.  We are going with right and good. The Why I have started...