{"id":19492,"date":"2016-04-05T22:56:51","date_gmt":"2016-04-06T02:56:51","guid":{"rendered":"https:\/\/reactivemusic.net\/?p=19492"},"modified":"2016-04-27T03:34:47","modified_gmt":"2016-04-27T07:34:47","slug":"sqlite-database-for-remote-radio-in-max","status":"publish","type":"post","link":"https:\/\/reactivemusic.net\/?p=19492","title":{"rendered":"SQLite database for remote radio in Max"},"content":{"rendered":"<p><cite>under construction&#8230;<\/cite><\/p>\n<p>Max\/MSP features a full implementation of SQLite using the js (javascript) object. Here we describe a database to track radio frequencies. Frequencies are stored by time, type, and mode. The frequencies can be retrieved in various ways, like with a scanner radio.<\/p>\n<p>Tables can be created and maintained outside of Max using the command line (sqlite3) or database apps like SQLiteStudio.<\/p>\n<h4>Max patches:<\/h4>\n<p>(not yet available on github:<\/p>\n<ul>\n<li>freqdb4.maxpat (database UI)<\/li>\n<li>swBase3.js (SQLite code)<\/li>\n<li>lp_radio2.maxpate (Launchpad)<\/li>\n<\/ul>\n<h3>DB structure:<\/h3>\n<p>The database is called newtestDB1<\/p>\n<h4>tables:<\/h4>\n<p>You can see the table schema in the screenshots. The tables were created using command line sqlite3 and SQLiteStudio.<\/p>\n<h5>freq table:<\/h5>\n<p>One record for each stored frequency. This table retains its state from each previous use, but new records can be added using the Max patch, or the Launchpad.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19495\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png\" alt=\"Screen Shot 2016-04-05 at 11.00.31 PM\" width=\"300\" height=\"162\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-1024x554.png 1024w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM.png 1064w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>xtime: Timestamp in UTC.<\/p>\n<p>frequency:\u00a0Hz.<br \/>\nmode:<\/p>\n<ul>\n<li>usb: 0<\/li>\n<li>lsb 1<\/li>\n<li>cw 2<\/li>\n<li>am 3<\/li>\n<li>fm 4<\/li>\n<\/ul>\n<p>filter: bandpass filter setting in Hz. (default is 6000)<\/p>\n<p>typecodes:<\/p>\n<p>0 : unknown<br \/>\n1 : AM\/SW broadcast<br \/>\n2 : clock<br \/>\n3 : digital mode<br \/>\n4 : local broadcast<br \/>\n5 : mostly noise<\/p>\n<p>zone: cq zone number<\/p>\n<p>rating: 0-5 (0 = unrated)<\/p>\n<p>confidence: 0-5 (0 = unknown)<\/p>\n<p>tags: (general text notes)<\/p>\n<h5>preset table:<\/h5>\n<p>The preset table contains one record for each 8&#215;8 launchpad button, for each of 3 screens.<\/p>\n<ul>\n<li>screen 0: fixed presets (red) (static and persistent)<\/li>\n<li>screen 1: time presets (green) (rebuilt with each time query)<\/li>\n<li>screen 2: user presets (yellow) (persistent but can be modified using the Launchpad)<\/li>\n<\/ul>\n<p>Data from each of theses screens is also displayed in jit.cellblock objects in the Max patch. All of the fields correspond to the fields in the freq table &#8211; except for screen, row, and col which are locators for the launchpad.<\/p>\n<p><a href=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.11.08-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19497\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.11.08-PM-300x208.png\" alt=\"Screen Shot 2016-04-05 at 11.11.08 PM\" width=\"300\" height=\"208\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.11.08-PM-300x208.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.11.08-PM-1024x711.png 1024w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.11.08-PM.png 1048w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h3>Using the database<\/h3>\n<h4>Launchpad presets<\/h4>\n<p>There are three screens of presets color coded using the Launchpad mixer button (upper right). Press it to cycle through the 3 screens.<\/p>\n<h5>0 fixed presets (red)<\/h5>\n<p>The fixed presets are static. But can be changed using SQLiteStudio. They contain commonly used radio frequencies, like the SW, Ham, and CB bands. And clock stations.<\/p>\n<p>To select a preset, press its button on the Launchpad.<\/p>\n<p>Currently assigned presets:<\/p>\n<p><a href=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.12-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19505\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.12-PM-300x115.png\" alt=\"Screen Shot 2016-04-05 at 11.39.12 PM\" width=\"300\" height=\"115\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.12-PM-300x115.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.12-PM-1024x393.png 1024w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.12-PM.png 1150w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h5>1 Time Presets (green)<\/h5>\n<p>Time presets are frequencies with Timestamps that match a selected range. For example, every frequency within one hour of the current time. These can be selected with a query in the Max patch, or using default values from the Launchpad. The query will randomly match up to 64 records. If the query returns less than 64 records, you will get all matching records, but in random order.<\/p>\n<p>From the Max patch:<\/p>\n<p>Match hours plus\/minus current time (0-12).<\/p>\n<p>Type the number of hours in the number box and press the button under the delay object. This reloads the presets.<\/p>\n<p><a href=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.36.35-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19504\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.36.35-PM-300x119.png\" alt=\"Screen Shot 2016-04-05 at 11.36.35 PM\" width=\"300\" height=\"119\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.36.35-PM-300x119.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.36.35-PM-1024x407.png 1024w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.36.35-PM.png 1142w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>You can view the results in the jit.cellblock:<\/p>\n<p><a href=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.07-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19506\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.07-PM-300x128.png\" alt=\"Screen Shot 2016-04-05 at 11.39.07 PM\" width=\"300\" height=\"128\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.07-PM-300x128.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.39.07-PM.png 718w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Match a specific time range:<\/p>\n<p>Enter the start\/end times and press the button.<\/p>\n<p><a href=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.40.51-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19507\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.40.51-PM-300x190.png\" alt=\"Screen Shot 2016-04-05 at 11.40.51 PM\" width=\"300\" height=\"190\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.40.51-PM-300x190.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.40.51-PM.png 712w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Selecting from launchpad<\/p>\n<p>trk button: re-runs query using last set number of hours plus\/minus current time. Default is one.<\/p>\n<p>solo button: select one random preset using current hour range, and play it?<\/p>\n<p>&nbsp;<\/p>\n<h5>User Presets (yellow)<\/h5>\n<p>The user presets work like the pushbuttons on a car radio. Press to select. Hold to save the currently tuned radio frequency.<\/p>\n<p>The learn button (upper left) gives feedback. If you press a pad for which no frequency has been assigned, the learn button will flash red. When you save a new preset, the learn button flashes green to indicated that the saving is done. If you press a pad for a preset that has already been saved, there will be no flash, but the radio frequency will change.<\/p>\n<h4>Adding new frequency records<\/h4>\n<p>You can add records using the Max patch or the Launchpad, or from SQLiteStudio.<\/p>\n<h5>Adding records from Max:<\/h5>\n<p>Tunning the radio fills in all of the fields except for typecode. Tune the radio. Then press one of the typecode buttons. Then press the big green button. You have added a new record.<\/p>\n<p><a href=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.55.57-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-19508\" src=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.55.57-PM-300x108.png\" alt=\"Screen Shot 2016-04-05 at 11.55.57 PM\" width=\"300\" height=\"108\" srcset=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.55.57-PM-300x108.png 300w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.55.57-PM-1024x369.png 1024w, https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.55.57-PM.png 1524w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h5>Adding records with Launchpad:<\/h5>\n<p>Press the Arm button (lower right) to add a record for the currently tuned frequency, using an &#8216;unknown typecode&#8217;<\/p>\n<h5>Adding records from SQLiteStudio<\/h5>\n<p>Just do it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>under construction&#8230; Max\/MSP features a full implementation of SQLite using the js (javascript) object. Here we describe a database to track radio frequencies. Frequencies are stored by time, type, and mode. The frequencies can be retrieved in various ways, like with a scanner radio. Tables can be created and maintained outside of Max using the &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/reactivemusic.net\/?p=19492\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;SQLite database for remote radio in Max&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[28,332],"tags":[150,345,190,57],"class_list":["post-19492","post","type-post","status-publish","format-standard","hentry","category-maxmsp","category-radio-2","tag-data","tag-maxmsp","tag-portfolio","tag-radio"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQLite database for remote radio in Max - reactive music<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/reactivemusic.net\/?p=19492\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLite database for remote radio in Max - reactive music\" \/>\n<meta property=\"og:description\" content=\"under construction&#8230; Max\/MSP features a full implementation of SQLite using the js (javascript) object. Here we describe a database to track radio frequencies. Frequencies are stored by time, type, and mode. The frequencies can be retrieved in various ways, like with a scanner radio. Tables can be created and maintained outside of Max using the &hellip; Continue reading &quot;SQLite database for remote radio in Max&quot;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/reactivemusic.net\/?p=19492\" \/>\n<meta property=\"og:site_name\" content=\"reactive music\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-06T02:56:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-04-27T07:34:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/#\\\/schema\\\/person\\\/b1e4349f476bb0f42552ff4f61a575d5\"},\"headline\":\"SQLite database for remote radio in Max\",\"datePublished\":\"2016-04-06T02:56:51+00:00\",\"dateModified\":\"2016-04-27T07:34:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492\"},\"wordCount\":688,\"image\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/reactivemusic.net\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png\",\"keywords\":[\"data\",\"Max\\\/MSP\",\"portfolio\",\"radio\"],\"articleSection\":[\"Max\\\/MSP\",\"Radio\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492\",\"url\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492\",\"name\":\"SQLite database for remote radio in Max - reactive music\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/reactivemusic.net\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png\",\"datePublished\":\"2016-04-06T02:56:51+00:00\",\"dateModified\":\"2016-04-27T07:34:47+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/#\\\/schema\\\/person\\\/b1e4349f476bb0f42552ff4f61a575d5\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/reactivemusic.net\\\/?p=19492\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#primaryimage\",\"url\":\"https:\\\/\\\/reactivemusic.net\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/Screen-Shot-2016-04-05-at-11.00.31-PM.png\",\"contentUrl\":\"https:\\\/\\\/reactivemusic.net\\\/wp-content\\\/uploads\\\/2016\\\/04\\\/Screen-Shot-2016-04-05-at-11.00.31-PM.png\",\"width\":1064,\"height\":576},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/?p=19492#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/reactivemusic.net\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLite database for remote radio in Max\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/#website\",\"url\":\"https:\\\/\\\/reactivemusic.net\\\/\",\"name\":\"reactive music\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/reactivemusic.net\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/reactivemusic.net\\\/#\\\/schema\\\/person\\\/b1e4349f476bb0f42552ff4f61a575d5\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2fdaf5f4af2a11b30054b546d0f5f24f4718bb82189f397b3a028aba400f16bb?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2fdaf5f4af2a11b30054b546d0f5f24f4718bb82189f397b3a028aba400f16bb?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/2fdaf5f4af2a11b30054b546d0f5f24f4718bb82189f397b3a028aba400f16bb?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\\\/\\\/reactivemusic.net\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLite database for remote radio in Max - reactive music","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/reactivemusic.net\/?p=19492","og_locale":"en_US","og_type":"article","og_title":"SQLite database for remote radio in Max - reactive music","og_description":"under construction&#8230; Max\/MSP features a full implementation of SQLite using the js (javascript) object. Here we describe a database to track radio frequencies. Frequencies are stored by time, type, and mode. The frequencies can be retrieved in various ways, like with a scanner radio. Tables can be created and maintained outside of Max using the &hellip; Continue reading \"SQLite database for remote radio in Max\"","og_url":"https:\/\/reactivemusic.net\/?p=19492","og_site_name":"reactive music","article_published_time":"2016-04-06T02:56:51+00:00","article_modified_time":"2016-04-27T07:34:47+00:00","og_image":[{"url":"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/reactivemusic.net\/?p=19492#article","isPartOf":{"@id":"https:\/\/reactivemusic.net\/?p=19492"},"author":{"name":"admin","@id":"https:\/\/reactivemusic.net\/#\/schema\/person\/b1e4349f476bb0f42552ff4f61a575d5"},"headline":"SQLite database for remote radio in Max","datePublished":"2016-04-06T02:56:51+00:00","dateModified":"2016-04-27T07:34:47+00:00","mainEntityOfPage":{"@id":"https:\/\/reactivemusic.net\/?p=19492"},"wordCount":688,"image":{"@id":"https:\/\/reactivemusic.net\/?p=19492#primaryimage"},"thumbnailUrl":"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png","keywords":["data","Max\/MSP","portfolio","radio"],"articleSection":["Max\/MSP","Radio"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/reactivemusic.net\/?p=19492","url":"https:\/\/reactivemusic.net\/?p=19492","name":"SQLite database for remote radio in Max - reactive music","isPartOf":{"@id":"https:\/\/reactivemusic.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/reactivemusic.net\/?p=19492#primaryimage"},"image":{"@id":"https:\/\/reactivemusic.net\/?p=19492#primaryimage"},"thumbnailUrl":"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM-300x162.png","datePublished":"2016-04-06T02:56:51+00:00","dateModified":"2016-04-27T07:34:47+00:00","author":{"@id":"https:\/\/reactivemusic.net\/#\/schema\/person\/b1e4349f476bb0f42552ff4f61a575d5"},"breadcrumb":{"@id":"https:\/\/reactivemusic.net\/?p=19492#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/reactivemusic.net\/?p=19492"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/reactivemusic.net\/?p=19492#primaryimage","url":"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM.png","contentUrl":"https:\/\/reactivemusic.net\/wp-content\/uploads\/2016\/04\/Screen-Shot-2016-04-05-at-11.00.31-PM.png","width":1064,"height":576},{"@type":"BreadcrumbList","@id":"https:\/\/reactivemusic.net\/?p=19492#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/reactivemusic.net\/"},{"@type":"ListItem","position":2,"name":"SQLite database for remote radio in Max"}]},{"@type":"WebSite","@id":"https:\/\/reactivemusic.net\/#website","url":"https:\/\/reactivemusic.net\/","name":"reactive music","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/reactivemusic.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/reactivemusic.net\/#\/schema\/person\/b1e4349f476bb0f42552ff4f61a575d5","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/2fdaf5f4af2a11b30054b546d0f5f24f4718bb82189f397b3a028aba400f16bb?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/2fdaf5f4af2a11b30054b546d0f5f24f4718bb82189f397b3a028aba400f16bb?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdaf5f4af2a11b30054b546d0f5f24f4718bb82189f397b3a028aba400f16bb?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/reactivemusic.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/reactivemusic.net\/index.php?rest_route=\/wp\/v2\/posts\/19492","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reactivemusic.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/reactivemusic.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/reactivemusic.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/reactivemusic.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19492"}],"version-history":[{"count":8,"href":"https:\/\/reactivemusic.net\/index.php?rest_route=\/wp\/v2\/posts\/19492\/revisions"}],"predecessor-version":[{"id":19511,"href":"https:\/\/reactivemusic.net\/index.php?rest_route=\/wp\/v2\/posts\/19492\/revisions\/19511"}],"wp:attachment":[{"href":"https:\/\/reactivemusic.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19492"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/reactivemusic.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19492"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/reactivemusic.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19492"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}