Menu
If I have a script that handles state information that's a bit more complex that can be stored in variables, what's the best option for a small in-memory database?
Sqlite is an option, though that would be an external dependency. XML might do, though it's non-relational.
Is there any consensus on a tool for this job?
585
In-memory databases are faster than traditional databases because they require fewer CPU instructions. They also eliminate the time it takes to access data from a disk. In-memory databases are more volatile than traditional databases because data is lost when there is a loss of power or the computer's RAM crashes.
In-memory databases can persist data on disks by storing each operation in a log or by taking snapshots. In-memory databases are ideal for applications that require microsecond response times or have large spikes in traffic such as gaming leaderboards, session stores, and real-time analytics.
In-memory OLTP is a database technology available in SQL Server and SQL Database for optimizing performance of transaction processing, data ingestion, data load, and transient data scenarios.
Considering PowerShell's great support for scripting .NET, how about using an ADO.NET DataSet.
138
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
