JSON / XML
-
JSON Data Type on MySQL and PostgreSQL
Unlike SQL Server, both MySQL and PostgreSQL supports JSON data type, where as in SQL Server, we need to add the JSON content to NVARCHAR. The below is how we define a table with a column of JSON data type: The below is how we use UPDATE statement to update a JSON value column, in… Continue reading
-
OData Responses in Camel-Case for Non-EDMs in ASP.NET Core
This could be a pretty specific issue and I don’t even guess that the 0.01% of the ASP.NET Core developer would come-across. However the title of the post is self-explanatory. The below is what needs to be added and this is for non-Newtonsoft.JSON cases as this uses System.Text.Json. This needs to be added/modified as below… Continue reading
-
JWT Validation Middleware in ASP.NET Core
HTTP 440 ( Login Time-out) is a good and meaningful HTTP response code. Despite of that being unofficial and used only by a few Microsoft services – I found it very handy and meaningful to indicate if the JWT token is expired, rather than showing a 401 (Unauthorised) which is broad. In my opinion, HTTP… Continue reading
-
Low-Code / No-Code API – Part 11 – Azure API Management
Link to Part 10: https://programmium.wordpress.com/2020/09/27/low-code-no-code-api-part-10-azure-logic-apps/ Link to webinar: https://tiny.cc/nocode-azure ENCAPSULATION Even though “Encapsulation” is a term, which is mostly used in Object Oriented Programming, which means to restrict the direct access of some object’s components – it can be applied in other areas of software engineering too. In the case of low-code/no-code API development, we use… Continue reading
-
Low-Code / No-Code API – Part 10 – Azure Logic Apps
Link to Part 1: https://programmium.wordpress.com/2020/08/10/low-code-no-code-api-part-1-azure-sql-serverless/ Link to webinar: https://tiny.cc/nocode-azure HOSTING THE BUSINESS LOGIC In part 1, I have explained about the serverless persistent storage for the B2B API. In this part lets see how we’re going to use Azure Logic Apps as the platform to host the business logic in serverless manner using low-code/no-code approach,… Continue reading
-
Low-code / No-code API – Part 1: Azure SQL Serverless
Link to Part 0: https://programmium.wordpress.com/2020/07/21/developing-low-code-no-code-api-part-0/ Link to webinar: https://tiny.cc/nocode-azure Persistent Store – B2B API In the previous post, the high level architecture diagram showed that we’re going to use Azure SQL Serverless as the persistent storage (aka: the database) for the API. Azure SQL Serverless is relatively new offering form Azure SQL related products. This… Continue reading
-
SharePoint : Getting Started with SharePoint Online REST
I was advised to learn SharePoint back in 2012 by my mentor due to the increasing job opportunities in SharePoint, but I didn’t really go for it, as I know that there were no much to code in SharePoint + hosting SharePoint was something I could not imagine. I gave up that idea and by… Continue reading
-
BSON : Introduction
BSON – Binary JSON gets my attentions lately when I was working on a messaging system implementation, where the main requirement was “optimal performance”. What is BSON BSON is designed to be efficient in space, but in some cases is not much more efficient than JSON. In some cases BSON uses even more space than… Continue reading
Recent Posts
- Comments on Service Locator (Anti Pattern)
- RESP – Redis Client Server Protocol
- Reflections on Clean Architecture Implementations with ORM
- Startup Process Internals of Python Apps on Azure App Service for Linux
- Power of Services: Decoupling Secrets for a More Flexible System Architecture
- Decoding the Clash: Navigating the Conflict Between Django LocMemCache and Uvicorn Workers
- Replace Conditionals with Polymorphism Requires At least One Conditional
- Django Logging Raw SQL Statements
- Learnings From Game of Life
- Django: From Response Content to InMemoryUploadedFile
- JSON Data Type on MySQL and PostgreSQL
- On Web Servers Handling Multiple Requests
- On Callable Units of a Program (aka “methods”)
- TDD and Type-safety
- DIP: Understanding the Levels
- LSP: Definition, Rules, Violations, and Implementation
- OData Responses in Camel-Case for Non-EDMs in ASP.NET Core
- JS Inspired C# Generator
- JWT Validation Middleware in ASP.NET Core
- Convenience Methods, Golden Hammer and Boat Anchor
programmium 