{"id":5791,"date":"2011-02-09T12:26:19","date_gmt":"2011-02-09T11:26:19","guid":{"rendered":"http:\/\/www.devapp.it\/wordpress\/?p=5791"},"modified":"2011-02-09T12:26:19","modified_gmt":"2011-02-09T11:26:19","slug":"sqlitemanager-e-sqliteconverter-gestisci-e-converti-i-tuoi-database-per-iphone-e-ipad","status":"publish","type":"post","link":"https:\/\/www.devapp.it\/wordpress\/sqlitemanager-e-sqliteconverter-gestisci-e-converti-i-tuoi-database-per-iphone-e-ipad\/","title":{"rendered":"SQLiteManager e SQLiteConverter: Gestisci e converti i tuoi database per iPhone e iPad"},"content":{"rendered":"<p><a href=\"http:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/logo-SQLite.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/logo-SQLite.jpg\" alt=\"logo-SQLite-iphone-devAPP\" title=\"logo-SQLite-iphone-devAPP\" width=\"200\" height=\"95\" class=\"alignleft size-full wp-image-5810\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/logo-SQLite.jpg 200w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/logo-SQLite-150x71.jpg 150w\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" \/><\/a> Ciao a tutti, oggi voglio segnalarvi due ottimi strumenti, disponibili da pochi giorni nel Mac AppStore di Apple, utili per gestire i <strong>database SQLite<\/strong> delle nostre applicazioni iPhone, iPad e non solo. Come saprete, infatti, se voleste implementare un database all&#8217;interno delle vostre applicazioni iPhone o iPad in via di sviluppo, l&#8217;unica soluzione disponibile \u00e8 proprio SQLite (ovviamente tolte altre forme di gestione dei dati come XML, JSON, CoreData e via dicendo). Abbiamo gi\u00e0 parlato di SQLite e iPhone in un nostro <a href=\"http:\/\/www.devapp.it\/wordpress\/t044-come-implementare-un-database-sqlite-nelle-nostre-applicazioni.html\" target=\"_blank\">precedente articolo<\/a> e abbiamo visto come si possa creare facilmente un db di questo tipo direttamente da terminale o tramite un&#8217;ottimo plugin gratuito per firefox (<a href=\"https:\/\/addons.mozilla.org\/en-US\/firefox\/addon\/5817\/\" target=\"_blank\">SQLite Manager<\/a>). Se per\u00f2 quello di cui avete bisogno \u00e8 uno strumento un po&#8217; pi\u00f9 professionale, allora questi due strumenti potrebbero fare al caso vostro, sto parlando di <strong>SQLiteManager<\/strong> e <strong>SQLiteConverter<\/strong>.<!--more--><\/p>\n<h4>SQLiteManager: crea e gestisci i tuoi database SQLite<\/h4>\n<p><a href=\"http:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP.jpg\" alt=\"SQLite-Manager-iPhone-Mac-devAPP\" title=\"SQLite-Manager-iPhone-Mac-devAPP\" width=\"150\" height=\"150\" class=\"alignleft size-full wp-image-5799\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP.jpg 175w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a> SQLiteManager, come il nome suggerisce, \u00e8 lo strumento, tra i due, che ci permetter\u00e0 di gestire completamente i nostri database SQLite.<\/p>\n<p>Grazie ad un&#8217;interfaccia semplice ed intuitiva e soprattutto ad alcune funzionalit\u00e0 avanzate, potremo facilmente creare e navigare tra tabelle, viste, ecc. o ancora gestire i dati all&#8217;interno delle stesse.<br \/>\nPotremo sfruttare il linguaggio SQL e all&#8217;occorrenza importare, esportare o stampare qualsiasi cosa (supportato anche il formato PDF).<\/p>\n<p>Potete acquistare SQLiteManager direttamente nel Mac AppStore tramite il <a href=\"http:\/\/clk.tradedoubler.com\/click?p=24373&#038;a=1735897&#038;g=0&#038;url=http:\/\/itunes.apple.com\/it\/app\/sqlitemanager\/id412443832?mt=12&#038;partnerId=2003\" target=\"_blank\">seguente indirizzo<\/a> al costo di 31,99 \u20ac (in offerta promozionale per un periodo limitato di tempo).<\/p>\n<p>Ricordo, che il software \u00e8 disponibile anche in versione compatibile con Microsoft Windows, ed \u00e8 acquistabile direttamente sul <a href=\"http:\/\/www.sqlabs.com\/index.php\" target=\"_blank\">sito ufficiale<\/a> degli sviluppatori SQLabs, dove entrambe le versioni sono disponibili per la vendita sia in singola che in multi licenza.<\/p>\n<h4>SQLiteConverter: converti i tuoi database mySQL, Oracle, Access, .. in SQLite<\/h4>\n<p><a href=\"http:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP.jpg\" alt=\"SQLite-Converter-iPhone-Mac-devAPP\" title=\"SQLite-Converter-iPhone-Mac-devAPP\" width=\"150\" height=\"150\" class=\"alignleft size-full wp-image-5793\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP.jpg 175w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a> Con SQLiteConverter, invece, potrete convertire il vostro DB mySQL, PostgreSQL, Oracle e molti altri database compatibili con ODBC (come FileMaker, Microsoft SQL Server, Access, FoxPro e molti altri) in un db SQLite.<\/p>\n<p>Anche qui avrete a disposizione un&#8217;interfaccia semplice e al tempo stesso potente che vi permetter\u00e0 di convertire in pochissimo tempo qualsiasi database, anche via remoto.<\/p>\n<p>Potete acquistare SQLiteConverter direttamente nel Mac AppStore tramite il <a href=\"http:\/\/clk.tradedoubler.com\/click?p=24373&#038;a=1735897&#038;g=0&#038;url=http:\/\/itunes.apple.com\/it\/app\/sqliteconverter\/id414445209?mt=12&#038;partnerId=2003\" target=\"_blank\">seguente indirizzo<\/a> al costo anch&#8217;esso di 31,99 \u20ac (sempre in offerta promozionale per un periodo limitato di tempo).<\/p>\n<p>Anche SQLiteConverter \u00e8 disponibile in versione Windows, ed \u00e8 acquistabile sempre tramite il <a href=\"http:\/\/www.sqlabs.com\/index.php\" target=\"_blank\">sito ufficiale<\/a> degli sviluppatori SQLabs, disponibile anche qui per Mac o Windows in singola o in multi licenza.<\/p>\n<style type=\"text\/css\">\n\t\t\t#gallery-1 {\n\t\t\t\tmargin: auto;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-item {\n\t\t\t\tfloat: left;\n\t\t\t\tmargin-top: 10px;\n\t\t\t\ttext-align: center;\n\t\t\t\twidth: 33%;\n\t\t\t}\n\t\t\t#gallery-1 img {\n\t\t\t\tborder: 2px solid #cfcfcf;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-caption {\n\t\t\t\tmargin-left: 0;\n\t\t\t}\n\t\t\t\/* see gallery_shortcode() in wp-includes\/media.php *\/\n\t\t<\/style>\n<div id='gallery-1' class='gallery galleryid-5791 gallery-columns-3 gallery-size-thumbnail'>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"SQLite-Converter-iPhone-Mac-devAPP\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-64x64.jpg 64w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP.jpg 175w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-mySQL-to-SQLite.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-mySQL-to-SQLite-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-mySQL-to-SQLite-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-mySQL-to-SQLite-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Converter-iPhone-Mac-devAPP-mySQL-to-SQLite-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-01.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-01-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"SQLite-Manager-iPhone-Mac-devAPP-01\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-01-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-01-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-01-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<p><br style=\"clear: both\" \/><\/p>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-02.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-02-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-02-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-02-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-02-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-03.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-03-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-03-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-03-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-03-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-04.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-04-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"SQLite-Converter-iPhone-Mac-devAPP-01\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-04-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-04-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-04-64x64.jpg 64w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<p><br style=\"clear: both\" \/><\/p>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"SQLite-Manager-iPhone-Mac-devAPP\" srcset=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-150x150.jpg 150w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-92x92.jpg 92w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP-64x64.jpg 64w, https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/SQLite-Manager-iPhone-Mac-devAPP.jpg 175w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<dl class='gallery-item'>\n<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/logo-SQLite.jpg'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"95\" src=\"https:\/\/www.devapp.it\/wordpress\/wp-content\/uploads\/2011\/02\/logo-SQLite-150x95.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"logo-SQLite-iphone-devAPP\" \/><\/a>\n\t\t\t<\/dt>\n<\/dl>\n<p>\t\t\t<br style='clear: both' \/>\n\t\t<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Ciao a tutti, oggi voglio segnalarvi due ottimi strumenti, disponibili da pochi giorni nel Mac AppStore di&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[7],"tags":[559,558,232,102,557,556],"class_list":["post-5791","post","type-post","status-publish","format-standard","hentry","category-strumenti-di-sviluppo","tag-convertire-database-sqlite","tag-database-ipad","tag-database-iphone","tag-sqlite","tag-sqliteconverter","tag-sqlitemanager"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/posts\/5791","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/comments?post=5791"}],"version-history":[{"count":14,"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/posts\/5791\/revisions"}],"predecessor-version":[{"id":5813,"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/posts\/5791\/revisions\/5813"}],"wp:attachment":[{"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/media?parent=5791"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/categories?post=5791"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devapp.it\/wordpress\/wp-json\/wp\/v2\/tags?post=5791"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}