{"id":1080,"date":"2016-04-04T17:08:09","date_gmt":"2016-04-04T17:08:09","guid":{"rendered":"http:\/\/www.mtin.net\/blog\/?p=1080"},"modified":"2016-04-04T17:08:09","modified_gmt":"2016-04-04T17:08:09","slug":"sql-lite-all-you-wanna-know","status":"publish","type":"post","link":"http:\/\/www.mtin.net\/blog\/sql-lite-all-you-wanna-know\/","title":{"rendered":"SQL Lite: All you wanna know"},"content":{"rendered":"<p>Awhile back i did an article on <a href=\"http:\/\/www.mtin.net\/blog\/?p=229\">cleaning the Dude database<\/a>. \u00a0Alex Nordeen has a very in-depth article on SQL Lite and it&#8217;s many features. \u00a0<a href=\"http:\/\/www.guru99.com\/download-install-sqlite.html\" target=\"_blank\">Check out the article<\/a> and <a href=\"http:\/\/www.guru99.com\" target=\"_blank\">Guru99.com<\/a> for more stuff.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Awhile back i did an article on cleaning the Dude database. \u00a0Alex Nordeen has a very in-depth article on SQL Lite and it&#8217;s many features. \u00a0Check out the article and Guru99.com for more stuff.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[240,235,238],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6VLMf-hq","jetpack-related-posts":[{"id":229,"url":"http:\/\/www.mtin.net\/blog\/cleaning-the-dude-database\/","url_meta":{"origin":1080,"position":0},"title":"Cleaning the Dude Database","author":"j2sw","date":"November 13, 2015","format":false,"excerpt":"So as installs of the Dude v4beta are aging they are experiencing some database issues. This is due to a 2gig limit of the SQL version embedded with the Dude. So, if your dude database is crashing, complaining about being full, or just plain running slow it may be time\u2026","rel":"","context":"In \"cleaning\"","block_context":{"text":"cleaning","link":"http:\/\/www.mtin.net\/blog\/tag\/cleaning\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":475,"url":"http:\/\/www.mtin.net\/blog\/why-every-isp-should-be-deploying-hap-lite-to-customers\/","url_meta":{"origin":1080,"position":1},"title":"Why every ISP should be deploying hAP Lite to customers","author":"j2sw","date":"December 24, 2015","format":false,"excerpt":"So Mikrotik has a very cheap hAP Lite coming out. \u00a0 This is a 4 port, 2.4 b\/g\/n router\/access point which retails for $21.95. Baltic networks has pre-orders for $18.95. Why should you deploy this little gem and how? We have found over the years routers account for more than\u2026","rel":"","context":"In &quot;Networking&quot;","block_context":{"text":"Networking","link":"http:\/\/www.mtin.net\/blog\/category\/networking\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1197,"url":"http:\/\/www.mtin.net\/blog\/temp-reading-from-a-powered-map-lite\/","url_meta":{"origin":1080,"position":2},"title":"Temp reading from a powered mAP lite","author":"j2sw","date":"May 19, 2016","format":false,"excerpt":"This is just sitting idle.","rel":"","context":"In &quot;Mikrotik&quot;","block_context":{"text":"Mikrotik","link":"http:\/\/www.mtin.net\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.mtin.net\/blog\/wp-content\/uploads\/2016\/05\/IMG_2999-279x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":261,"url":"http:\/\/www.mtin.net\/blog\/mum2015-janis-opening-remarks\/","url_meta":{"origin":1080,"position":3},"title":"MUM2015: Janis opening Remarks","author":"j2sw","date":"April 23, 2015","format":false,"excerpt":"Recently Introduced hAP Lite (Home Access Point Lite) 2.4GHZ Dual Chain 5volt USB powered CCR1009 PC 9 Core Tilera Passive cooling * Gigabit, 1SFP, 1SFP+ PowerBox Outdoor Ethernet router POE Out S+2332LC10D 10KM Bidirectional SFP+ New Products: hAP 951 replacement regular power input POE-IN PoE-out on port 5 hAP ac\u2026","rel":"","context":"In &quot;Mikrotik&quot;","block_context":{"text":"Mikrotik","link":"http:\/\/www.mtin.net\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":239,"url":"http:\/\/www.mtin.net\/blog\/wispamerica-hot-wireless-products-wrapup\/","url_meta":{"origin":1080,"position":4},"title":"WISPAmerica hot wireless products wrapup","author":"j2sw","date":"February 27, 2015","format":false,"excerpt":"Mimosa B5 Lite http:\/\/mimosa.co\/home\/Products\/Backhaul\/B5-Lite.html Telrad 3.65 LTE http:\/\/www.telrad.com\/","rel":"","context":"In &quot;News&quot;","block_context":{"text":"News","link":"http:\/\/www.mtin.net\/blog\/category\/news-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":305,"url":"http:\/\/www.mtin.net\/blog\/mirkotik-router-os-6-29-released\/","url_meta":{"origin":1080,"position":5},"title":"Mikrotik Router OS 6.29 released","author":"j2sw","date":"May 28, 2015","format":false,"excerpt":"The fastTrack improvements are a big improvement for those of you doing such things. What's new in 6.29 (2015-May-27 11:19): *) ssh server - use custom generated DH primes when possible; *) ipsec - allow to specify custom IP address for my_id parameter; *) ovpn server - use subnet topology\u2026","rel":"","context":"In \"crs\"","block_context":{"text":"crs","link":"http:\/\/www.mtin.net\/blog\/tag\/crs\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts\/1080"}],"collection":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/comments?post=1080"}],"version-history":[{"count":1,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts\/1080\/revisions"}],"predecessor-version":[{"id":1081,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts\/1080\/revisions\/1081"}],"wp:attachment":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/media?parent=1080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/categories?post=1080"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/tags?post=1080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}