cweber Posted September 30, 2022 Share Posted September 30, 2022 (edited) 9 hours ago, Silas Marrs said: I do want to switch user notes to something simple and human readable and hard to corrupt @Silas Marrs I have been working data warehouse (Synapse) a bit and been ingesting many types of files, including 7ZIP of CSV from the latest Oracle enterprise ERP system; they do provision this to prevent direct access to their database with some rare exceptions I need API for (PS: I hate CSV files). I only mention this to identify Accordance is not alone in these type of issues JSON appears to be a popular format these days and is considered a replacement for XML, but I have no experience with storing large string values in these files. I do see Markdown often used in Git (version control) Readme files used all over the world, so it is popular and widely used. I do not have statistics about how susceptible any files formats are to corruption. However, I imagine the process to check and release a lock is similar. The JSON structure is fairly easy to work, is scalable and flexible with most programmers familiar with this format. I find Markdown is okay, but don't find it particularly scalable; probably more suitable for notation of raw text though. I have seen a third party company (for an end product as large and expensive as Bentley MicroStation - computer aided design) deliver individual component specifications via distinct Microsoft Access database files. I do not suggest this particular approach. I earn my living with databases, but they require overhead to correctly manage and can suffer corruption, more so than files if you don't do this. A single large database would make more sense, but still subject to the complexities of maintenance and system overhead. Edited September 30, 2022 by cweber 1 Link to comment Share on other sites More sharing options...
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now