Posts

Featured Post

Setup and Use SQLite with .NET MAUI - Tutorial and Code Examples

Image
 I was recently working on a .NET MAUI mobile app and needed some data to persist between launches. I know from experience that SQLite is a very common approach to storing data locally on mobile devices so I began implementing it. As usual, the road to success was bumpy and I hit an error immediately and wrote about fixing it fairly quickly in  Using SQLite as a Local Database With .NET MAU  (resolving missing SQLitePCLRaw.provider.dynamic_cdecl). This issue is a problem one would encounter when setting up the NuGet packages. This post was pretty small, so I decided to write this post on the entire process of setting up and using SQLite with .NET MAUI. 1) Install the SQLite NuGet packages In order to use SQLite, you will need "sqlite-net-pcl" and "SQLitePCLRaw.provider.dynamic_cdecl." I attempted to follow Microsoft's instructions and use "SQLitePCLRaw.bundle_green" in place of SQLitePCLRaw.provider.dynamic_cdecl" but I continued to get FileNotFou...

Using SQLite as a Local Database With .NET MAUI

Image
 .NET MAUI can be a bit challenging to use due to its current state of development. It is still really new and often (in my experience) is missing documentation, or sometimes the documentation or related forums posts are outdated. Often when developing mobile apps, the developer needs persistent storage and turns to SQLite to meet those needs. I have attempted using SQLite in one of my first MAUI apps and remember struggling to jump through the right hoops to get my local database set up. I am once again creating a mobile app with MAUI and have stumbled across the same issues.  I began adding my local database by following the  .NET MAUI local databases  tutorial and pretty much immediately ran into the exception: " could not load file or assembly 'sqlitepclraw.provider.dynamic_cdecl" System.TypeInitializationException: The type initializer for 'SQLite.SQLiteConnection' threw an exception. ... System.IO.FileNotFoundException: Could not load file or assembly  '...

Forest Hills Apartments, Wilmington NC Roach Infestation Story Continued

Image
This is a continuation of the beginning story of how I moved into a roach-infested apartment at Forest Hills . I would like to dedicate this post to what it was like to spend a month living in a roach-infested apartment. In summary, if you missed the first post, we had been lied to several times about the state of this apartment and lived 200 miles away, so we fell into a classic bait-and-switch and signed this lease without looking at the apartment since we loved the demo apartment and liked the property manager -- this all changed of course. Let me paint a mental picture for you. You just moved to Wilmington, NC with your wife and two cats, one of which has a compromised immune system. You've paid about $3,000 in rent, deposits, a moving truck rental, and now endless cleaning supplies because you've moved into a slum house full of filth and cockroaches. I should note you also have a work-from-home job, so you'll be spending all your time working in your new home. Guess wh...

How to Prepare and What to Expect During an Entry-Level Software Engineering Interview Phone Screening in 2023

Image
Software engineering interviews will vary just like any other type of interview, but there will always be similarities in common. I have been a software engineer since graduating with my bachelor's degree in Computer Science in May 2019. I have had two jobs programming in my professional career, but I have had many more interviews and have turned down just as many offers. I would like to give a bit of my experience so your time can be well spent and you will know what to expect. When you hear back from a software engineering application the first objective the recruiter will likely want to accomplish is scheduling a fairly quick phone interview or phone screening. This is often considered the first round of a series of rounds of interviews. In fact, every single interview I have had in the last 3 years has begun this way, so I would say it is pretty much guaranteed. If you have never had a phone screening before, you will probably want to know what to expect and what the desired ou...

Moving into a Roach-Infested Apartment - Forest Hills Apartment Homes, Wilmington NC Review

Image
Prepare yourself for a completely disgusting review of Forest Hills Apartment Homes located in Wilmington, North Carolina.  Giant cockroach living under where our oven once was Prelude - Discovering Forest Hills Apartment Homes My wife and I are in our twenties. We have lived in a couple other apartments before. One townhouse and two others in the typical apartment building style (3-story stacked design). In early 2022, we decided we wanted to move and picked Wilmington, NC as our destination because it was in-state, at the beach, and we had been there previously and loved it. What a perfect idea? We decided to plan our move much in advance so the 200-mile move would be simpler. Our current lease was set to expire on 11/30/2022, so we began searching for a place to call home in September. We had five or six apartments selected to tour on September 30th. Our first incidence of bad luck was that this weekend was also the landfall of Hurricane Ian hitting the Carolina coast, but...

Coding, software, me?

Image
     Time for a first post to see how things will look.       Who am I? I am me.       This post will also probably be removed. I wanted to take the time in this blog to talk about my personal life as a programmer and some of the obstacles I have faced. Maybe sort of act like an older brother (not quite a mentor) to people looking to pivot into my position. Hopefully, some good stuff comes out of this blog. For now, I will only be trying to fill in some space.      I went to college at App State for computer science. It was great, but terrible because I worked at Walmart the entire time. Imagine working until 10PM stocking vegetables then going home to study computer science. It's probably not hard because a lot of people do it lol It's tough, though. Trust me.      Anyway, I graduated and got a job in programming yay. Then got another one, and that's where I am now. Let's go! Programmer named Austin wh...