{"id":15257,"date":"2016-07-19T10:52:01","date_gmt":"2016-07-19T14:52:01","guid":{"rendered":"http:\/\/mjtsai.com\/blog\/?p=15257"},"modified":"2016-07-19T10:52:01","modified_gmt":"2016-07-19T14:52:01","slug":"sqlite_enable_sqllog","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2016\/07\/19\/sqlite_enable_sqllog\/","title":{"rendered":"SQLITE_ENABLE_SQLLOG"},"content":{"rendered":"<p><a href=\"https:\/\/twitter.com\/numist\/status\/754093312357703680\">Scott Perry<\/a>:<\/p>\n<blockquote cite=\"https:\/\/twitter.com\/numist\/status\/754093312357703680\">\n<p>PSA: SQLite on Sierra\/iOS 10 is built with SQLITE_ENABLE_SQLLOG, which makes it easy to create replayable SQL logs<\/p>\n<\/blockquote>\n<p><a href=\"http:\/\/www.sqlite.org\/src\/doc\/trunk\/src\/test_sqllog.c\">SQLite<\/a>:<\/p>\n<blockquote cite=\"http:\/\/www.sqlite.org\/src\/doc\/trunk\/src\/test_sqllog.c\"><p>This file contains experimental code used to record data from live\nSQLite applications that may be useful for offline analysis. \nSpecifically, this module can be used to capture the following\ninformation:<\/p>\n<ol><li>The initial contents of all database files opened by the \n     application, and<\/li>\n<li>All SQL statements executed by the application.<\/li><\/ol>\n<p>The captured information can then be used to run (for example)\nperformance analysis looking for slow queries or to look for\noptimization opportunities in either the application or in SQLite\nitself.<\/p>\n<p>[&#8230;]<\/p>\n<p>At runtime, logging is enabled by setting environment variable\nSQLITE_SQLLOG_DIR to the name of a directory in which to store logged \ndata.<\/p><\/blockquote>","protected":false},"excerpt":{"rendered":"<p>Scott Perry: PSA: SQLite on Sierra\/iOS 10 is built with SQLITE_ENABLE_SQLLOG, which makes it easy to create replayable SQL logs SQLite: This file contains experimental code used to record data from live SQLite applications that may be useful for offline analysis. Specifically, this module can be used to capture the following information: The initial contents [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"","apple_news_api_id":"","apple_news_api_modified_at":"","apple_news_api_revision":"","apple_news_api_share_url":"","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[4],"tags":[109,1380,1381,71,425],"class_list":["post-15257","post","type-post","status-publish","format-standard","hentry","category-programming-category","tag-coredata","tag-ios-10","tag-macos-10-12","tag-programming","tag-sqlite"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/15257","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=15257"}],"version-history":[{"count":1,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/15257\/revisions"}],"predecessor-version":[{"id":15258,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/15257\/revisions\/15258"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=15257"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=15257"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=15257"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}