DEV Community: RONY DIAZ The latest articles on DEV Community by RONY DIAZ (@diazrony). https://dev.to/diazrony https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F301597%2Ffa86f197-59c6-4e99-858f-0ca74c2ce9d4.jpeg DEV Community: RONY DIAZ https://dev.to/diazrony en Ionic SQLite Capacitor RONY DIAZ Thu, 03 Mar 2022 03:37:18 +0000 https://dev.to/diazrony/ionic-sqlite-capacitor-4d45 https://dev.to/diazrony/ionic-sqlite-capacitor-4d45 <p>Hola, aprenderemos como implementar SQLite en ionic capacitor, para este ejemplo iniciaremos un nuevo proyecto.<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ ionic start "sqlite-capacitor" blank — capacitor </code></pre> </div> <p>Instalar las siguientes librerías<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ npm install @ionic/storage $ npm install @ionic/storage-angular $ npm install cordova-sqlite-storage $ npm install localforage-cordovasqlitedriver </code></pre> </div> <p>Esta implementación nos funcionara tanto para web como móvil, en la versión web utilizara IndexedDB y en la versión móvil SQLite.</p> <p>Creamos los siguientes directorios y archivos.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--97P_R4Uo--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4y0mlhmfdv96n8bov4hf.PNG" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--97P_R4Uo--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/4y0mlhmfdv96n8bov4hf.PNG" alt="directorios" width="526" height="432"></a><br> <strong>platform.strategy.service.ts</strong></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--SBK1ciU8--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jvyq62p9kyw532yoy445.PNG" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--SBK1ciU8--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jvyq62p9kyw532yoy445.PNG" alt="platform.strategy.service.ts" width="880" height="489"></a></p> <p><strong>StorageService.ts</strong></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--bvODfBPL--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8if0w5b1des9t1zvft1h.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--bvODfBPL--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8if0w5b1des9t1zvft1h.png" alt="StorageService" width="880" height="767"></a></p> <p><strong>StorageSQLiteService.ts</strong></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--FzlbXJkL--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dqdtq7lg447exdk07htg.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--FzlbXJkL--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/dqdtq7lg447exdk07htg.png" alt="StorageSQLiteService" width="880" height="401"></a></p> <p><strong>StorageProvider.ts</strong></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--PDiT1Wec--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zapy4maqeebd3p7fg3wp.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--PDiT1Wec--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/zapy4maqeebd3p7fg3wp.png" alt="StorageProvider.ts" width="880" height="429"></a></p> <p><strong>app.module.ts</strong></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--TH-IWVvA--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pmmbhm457icdaxsml3re.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--TH-IWVvA--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/pmmbhm457icdaxsml3re.png" alt="app.module.ts" width="880" height="564"></a></p> <p><strong>app.component.ts</strong></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--yjKP92iH--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6d50pbzigvtoizfux8qh.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--yjKP92iH--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6d50pbzigvtoizfux8qh.png" alt="app.component.ts" width="880" height="401"></a></p> <p>Procedemos a levantar el proyecto en web o a construir la aplicación con capacitor.</p> <p><strong>Web</strong><br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ ionic serve </code></pre> </div> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--Chdmvbqg--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ftn0vz0yay9xk9w13oiy.PNG" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--Chdmvbqg--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ftn0vz0yay9xk9w13oiy.PNG" alt="Image description" width="880" height="702"></a></p> <p><strong>Android</strong><br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ ionic cap copy android $ ionic cap sync android </code></pre> </div> <p>Colocamos estas 2 instrucciones en el <strong>AndroidManifest.xml</strong><br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>&lt;uses-permission android:name=”android.permission.READ_EXTERNAL_STORAGE” /&gt; &lt;uses-permission android:name=”android.permission.WRITE_EXTERNAL_STORAGE” /&gt; </code></pre> </div> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--dnOf9JIS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6shxhyisz45gdyncqqil.PNG" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--dnOf9JIS--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/6shxhyisz45gdyncqqil.PNG" alt="Image description" width="519" height="267"></a></p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--MR12OZiU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/josix2f6hpcvfbrk3knf.png" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--MR12OZiU--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/josix2f6hpcvfbrk3knf.png" alt="Image description" width="880" height="713"></a></p> <p>Construimos la aplicación.<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight plaintext"><code>$ ionic cap build android </code></pre> </div> <p>Abrimos android studio y damos clic en run ‘app’.</p> <p><a href="https://res.cloudinary.com/practicaldev/image/fetch/s--KqYWfsQu--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/axxsgmayhb5ma51izl28.PNG" class="article-body-image-wrapper"><img src="https://res.cloudinary.com/practicaldev/image/fetch/s--KqYWfsQu--/c_limit%2Cf_auto%2Cfl_progressive%2Cq_auto%2Cw_880/https://dev-to-uploads.s3.amazonaws.com/uploads/articles/axxsgmayhb5ma51izl28.PNG" alt="Image description" width="880" height="495"></a></p> <p>Todo el código de referencia <a href="https://github.com/diazrony/IonicSQLiteCapacitor.git">aquí</a></p> <p>No olvides dejarle tu estrellita al repositorio.<br> Espero te haya servido de mucho, Saludos.</p> ionic angular programming android