Ravi S. Iyer: Software Development

Last updated on 3 Nov. 2024 My post: Tutorial links for Bootstrap, Next.js, TypeScript and React Native,  https://raviswdev.blogspot.com/2024/04/tutorial-links-for-bootstrap-react.html has some initial info. on this topic.  Additional post of mine having some info. on Bootstrap in section with 'Bootstrap' title: Learning Full Stack (MERN) Web App Development through Free Online Tutorials – Organized Notes and Log,  https://raviswdev.blogspot.com/2024/03/learning-web-app-development-through.html . This post mainly covers a deeper dive I am making into Bootstrap but it also has some other miscellaneous stuff. Git Clone Branch: A Step-by-Step Tutorial, https://www.datacamp.com/tutorial/git-clone-branch-tutorial git clone --single-branch --branch <branch_name> <repository_url> Yarn related: 'corepack enable' command needs Administrative login. nodejs will not enable corepack: operation not permitted, https://stackoverflow.com/questions/70577085/nodejs-will-not-

Last updated on 18th Oct. 2024 Oct. 15th and 16th: As I have done a quick refresh and slightly improved my SQL database design knowledge over past few days, I felt that I should also get some exposure to MongoDB database design. So far, I have used fairly simple MongoDB schemas in the tutorial projects I have gone through and perhaps some simple project variations that I did. I need to get more exposure. This post has related notes. MongoDB Schema Design Best Practices, https://www.youtube.com/watch?v=QAqK-R9HUhc by MongoDB, around 10 mins, April 2021 community.mongodb.com https://www.mongodb.com/resources/solutions/use-cases/mongodb-application-modernization-guide - Downloaded file: MongoDB_Modernization_Guide-ans0zbdf0i.zip has RDBMS to MongoDB Migration White Paper.pdf and other files including sample DB. RDBMS to MongoDB Migration White Paper.pdf - 20 pages: Has examples of simple to medium complexity RDBMS design along with MongoDB schemas ('converted'); "The $looku

Last updated on 15th Oct. 2024 In my past software industry career (1984 to 2002), I had done some amount of SQL database related work but not much. So I was not a database design expert. But I could understand simple to medium complexity database designs and use SQL on command line or through programs to do CRUD operations on the database. Given the above background and given that some web dev projects use SQL databases instead of NoSQL databases, I would like to refresh and improve my knowledge on SQL database design. This post has notes related to this activity. ================== Around 13th to 14th Oct.: About yellow and red key icons, and blue, red and white diamond icons before columns in entities in ER diagrams: What do the mysql workbench column icons mean, https://stackoverflow.com/questions/10778561/what-do-the-mysql-workbench-column-icons-mean explains what these icons stand for. Excellent article on ERD: What is Entity Relationship Diagram (ERD)?, https://www.visual-parad

A web dev. project that I am starting to study, uses ".Net Core" for the back-end and ReactJS for the front-end. I want to get a quick overview of .Net Core and am doing some reading/viewing on it in short bursts. Notes about it are given below. ASP.NET Core,  https://dotnet.microsoft.com/en-us/apps/aspnet seems to be the main official docs page. Some key points from it: Free. Cross-platform. Open source. A framework for building web apps and services with .NET and C#. Supported on Windows, Linux, and macOS Hmm. That's quite interesting. My last industry project, IIRC, was on ASP.NET and C# in 2002. I don't think it was free then, nor cross-platform (I think it was only Windows platform then) and not open source. Quite fascinating that 22 years later, the name of the web dev. platform has not changed much - from ASP.NET to ASP.NET Core and the language is still C#. Of course, the features of ASP.NET Core as well as C# today will be far more than what it was 22 years

Last updated on 14 Oct. 2024 My post: Bhagavad Gita and some other Hindu scripture websites/web apps with source code (Next.js, React, React Native, REST API, JSON, AI-ChatGPT), https://raviswdev.blogspot.com/2024/05/bhagavad-gita-and-hindu-scripture.html  lists some public Gita repositories including REST API and JSON repos. At the time I put up the post, I did not spend much time on details of the REST API and JSON repos. Now I am taking a closer look at them. About the two REST APIs listed in my above post: https://github.com/gita/bhagavad-gita-api is in Python. I don't want to get into Python stuff now. https://github.com/vedicscriptures/bhagavad-gita-api is in Express JS and uses mongoose. I think I should be able to go through this source code. More details covered later on in this post. About the three Gita JSON data sources listed in my above post: https://github.com/bhavykhatri/DharmicData/tree/main/SrimadBhagvadGita has 18 JSON files with translations for each chapter

Last updated on 9 Oct. 2024 2 & 3 Oct. 2024: Continuing from after Tasks project in John Smilga Express tutorial...Node.js Projects, https://youtu.be/rltfdjcXjmk?t=11235  (from around 3 hrs, 7 mins in the video). The next project taken up is the Store project. express-async-errors, https://www.npmjs.com/package/express-async-errors Most of the source code of the Store project is straight-forward and somewhat similar to Tasks project. However, controllers\products.js has fair deal of complexity as it uses the various query features of Mongoose find() with Query String params being the mechanism for specifying the query to the get route ('routed' to getAllProducts() method in controllers\products.js file). The code for string data query is simple. Numeric data query code is complex which is covered below in some detail. Chaining the find method conditionally with sort and select methods, and unconditionally with skip and limit methods is new in the tutorial. The await keyword