ManicTime and SQL Server Compact Edition (SSCE) Databases

Original article: ManicTime and SQL Server Compact Edition (SSCE) Databases

 

ManicTime is a software used to record users' computer operation time. It records in detail what they do on their computers every day. It adopts the Net Framework 3.5 Framework and should be developed using Microsoft Visual Studio 2008.

ManicTime still has many functions. For example, I want to know how much time I spent reading Google Reader every day. Although I can Filter the time periods of reading Google Reader, there is no summary time, I cannot add up one item.

How does ManicTime save a large amount of data? Open the ManicTime installation directory. The default value is C: "Program Files" ManicTime. ManicTime.exe. config indicates that it uses the SQL Server 2005 Compact Edition (SSCE) database and the password is "ombolo ". What is SQL Server Compact Edition Database File?

SQL Server 2005 Compact Edition (SSCE) is a lightweight (<2 MB), free relational database engine, SSCE supports features such as tables, relationships, constraints, complex query processing, transactions, replication, and data security. SSCE runs as a group of databases referenced by applications in the process, it is an alternative database technology for applications that require lightweight relational data storage.

It was originally a database that is more powerful than Access. The database for ManicTime is located in C: "Documents and Settings" your username "Local Settings" Application Data "Finkit" ManicTime, and the file name is ManicTime. sdf. Add the above password so that we can export and display the data as needed.