I've been busy these last few months working part-time on this database, web api, and web front end to store, and report on architectural project data. The source code for the web api can be found on Github (https://github.com/rperez-rosario/XPM_Server). The source code for the front end will soonish follow.
#databases
13 posts7 participants1 post today
Why Migrations are needed in Entity Framework in C# Tip #107 #coding #dotnet #csharp #sql #linq #codingforbeginners #codingbasics #sqlserver #webdevelopment #softwareengineer #visualstudiocode #databases #softwaredeveloper #computerscience #codinglife #learncoding #datascience #learntocode #vscode #visualstudio
Leanpub book LAUNCH 
Build a Database Server: Learn how real databases work by following this practical guide to building your own by Chris Zetter
Watch here:
youtu.be- YouTubeEnjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Demo of EnsureCreated with Entity Framework C# Tip #106 #codingbasics #codingforbeginners #linq #sqlserver #coding #dotnet #sql #csharp #visualstudio #webdevelopment #softwareengineer #visualstudiocode #vscode #databases #softwaredeveloper #computerscience #learntocode #codinglife #datascience #learncoding
EnsureCreated with Entity Framework C# Tip #105 #codingforbeginners #codinglife #computerscience #databases #linq #sqlserver #coding #vscode #sql #dotnet #softwaredeveloper #visualstudiocode #softwareengineer #learntocode #datascience #webdevelopment #codingbasics #visualstudio #learncoding #csharp
Create table with Entity Framework C# Tip #104 #codingbasics #codingforbeginners #codinglife #computerscience #databases #linq #sqlserver #coding #vscode #dotnet #softwaredeveloper #visualstudiocode #softwareengineer #learntocode #datascience #webdevelopment #sql #visualstudio #learncoding #csharp
Database Migrations and Entity Framework in C# Tip #101 #datascience #dotnet #learncoding #computerscience #codinglife #softwaredeveloper #codingforbeginners #visualstudiocode #softwareengineer #vscode #codingbasics #coding #sql #visualstudio #sqlserver #csharp #databases #learntocode #linq
Remove a column from table manually Entity Framework in C# Tip #100 #visualstudiocode #softwareengineer #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife #softwaredeveloper #vscode #linq #codingbasics #coding #sql #visualstudio #sqlserver #csharp #databases
Using Keyword Explained and Entity Framework in C# Tip #97 #linq #softwaredeveloper #vscode #codingbasics #sqlserver #visualstudio #learntocode #databases #csharp #visualstudiocode #softwareengineer #coding #sql #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife
Database Connections in Entity Framework Core Application in C# Tip #96 #vscode #codingbasics #visualstudio #databases #computerscience #codingforbeginners #learncoding #codinglife #softwareengineer #coding #visualstudiocode #dotnet #softwaredeveloper #sql #datascience #sqlserver #learntocode #csharp #linq
Simple Entity Framework Core Application in C# and VS Code Tip #95 #visualstudiocode #softwareengineer #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife #softwaredeveloper #vscode #linq #codingbasics #coding #sql #visualstudio #sqlserver #csharp #databases
Install Entity Framework in VSCode Project for C# Tip #94 #linq #softwaredeveloper #vscode #codingbasics #sqlserver #visualstudio #learntocode #databases #csharp #visualstudiocode #softwareengineer #coding #sql #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife
Install Entity Framework in VSCode Project for C# Tip #94 #linq #softwaredeveloper #vscode #codingbasics #sqlserver #visualstudio #learntocode #databases #csharp #visualstudiocode #softwareengineer #coding #sql #codingforbeginners #datascience #dotnet #learncoding #computerscience #codinglife
New blog post: I take a close look at DBeaver, the open-source DB client that quietly became my daily driver.
Remote access, SSH tunnels, tabbed UI, export tools – it’s packed with features and free to use.
But beware: new versions can be buggy. I keep backups of older ones. Still worth it.
Read it here: https://itsmoreofacomment.com/2025/07/11/not-just-another-beaver/
From the Leanpub Blog: Welcome to the Leanpub Launch video for Build a Database Server: Learn how real databases work by following this practical guide to building your own by Chris Zetter!
https://leanpub.com/blog/leanpub-book-launch-build-a-database-server-by-chris-zetter
The Leanpub Blog · Leanpub book LAUNCH 🚀 Build a Database Server by Chris ZetterWelcome to the Leanpub Launch video for Build a Database Server: Learn how real databases work by following this practical guide to building your own by Chris Zetter!
Leanpub book LAUNCH Build a Database Server: Learn how real databases work by following this practical guide to building your own by Chris Zetter
Watch here:
youtu.be- YouTubeEnjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
'This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts.'
eric.ed.govERIC - EJ1468081 - Using LEGO® Brick Data to Teach SQL and Relational Database Concepts, Information Systems Education Journal, 2025This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with 633,250 rows of data on 11,673 LEGO® sets sold between 1950 and 2017. As a guiding example, I introduce an example group project assignment designed to provide students hands-on experience with database management and SQL queries. I also discuss tips, suggestions, and lessons learned from using the data for group projects over the past five years. While LEGO® bricks have been widely used in educational settings, including college and computer classrooms, this is the first work to discuss the use of LEGO® data in a college database course.
Select Many Flatten Multiple Lists in LINQ C# Tip #84 #coding #databases #codingbasics #learncoding #linq #visualstudiocode #sqlserver #codingforbeginners #softwaredeveloper #datascience #dotnet #csharp #learntocode #vscode #softwareengineer #visualstudio #computerscience #codinglife
Oho! Here is a new in-depth p2panda blog post!
https://p2panda.org/2025/07/09/streams-transactions-crash-resilience.html
This one is about the strategies and design ideas we’re exploring to make p2p applications resilient to critical failures, for both system- and application layers.
Oh we do manga—like The Manga Guide to Databases.
This one teaches relational databases through the story of a princess, a magical fairy, and a chaotic fruit empire.
Not only is it cute, but it’s a genuinely solid intro to ER models, SQL, and proper data design. Visual, practical, and fun to learn from.