Oqtane
2023-W13
"Agilify" nice to get back to some raw coding
It is funny but ever since DynamicForm module I haven't had a need to build much. Create a form, capture data and present it. DF is so versatile.
So "Agilify" is getting close to the GitHub repo going public. There are a lot of little coding gems and definitely a different way of working. One big point is:
Data Storage
The Data will reside in one SQL server table with the main Item data stored as JSON. Storing object data in JSON format in a database has several benefits:
- Flexibility: JSON is a flexible format that can store complex data structures, which makes it a great choice for storing object data. It can handle nested data structures and arrays and allows for easy manipulation of data.
- Interoperability: JSON is widely used and supported across different programming languages, which makes it easy to exchange data between different systems and applications.
- Human-readable: JSON is easy for humans to read and understand, which makes it easier to debug and troubleshoot issues with the data.
- Compactness: JSON is a lightweight format, which means it takes up less space in the database compared to other formats like XML.
- Ease of use: Serializing and deserializing JSON is a straightforward process that can be done on the fly, which makes it easy to work with data in an application.