{"id":13640,"date":"2021-07-21T11:14:54","date_gmt":"2021-07-21T14:14:54","guid":{"rendered":"https:\/\/blog.absam.io\/?p=13640"},"modified":"2021-07-21T11:14:54","modified_gmt":"2021-07-21T14:14:54","slug":"como-instalar-a-usar-o-sqlite-no-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/","title":{"rendered":"Como instalar a usar o SQLite no Ubuntu 20.04"},"content":{"rendered":"\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/blog.absam.io\/wp-content\/uploads\/2021\/07\/unnamed-file.png\" alt=\"\" class=\"wp-image-13641\"\/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Introdu\u00e7\u00e3o<\/h3>\n\n\n\n<p>SQLite \u00e9 um sistema de gerenciamento de banco  de dados gratuito, multiplataforma e facilmente integr\u00e1vel com diversas tecnologias.<\/p>\n\n\n\n<p>Neste tutorial, voc\u00ea instalar\u00e1 o SQLite no Ubuntu 20.04. Em seguida, voc\u00ea criar\u00e1 um banco de dados, ler, escrever, atualizar e excluir itens de  uma tabela. Para seguir este tutorial voc\u00ea precisar\u00e1 ter uma maquina com o sistema Ubuntu 20.04 instalada, esse tutorial poder\u00e1 ser aplicado em vers\u00f5es anteriores do sistema, caso voc\u00ea n\u00e3o tenha, voc\u00ea poder\u00e1 criar uma Cloud Nat, facilmente utilizando o nosso dashboard, com alguns cliques voc\u00ea ter\u00e1 uma m\u00e1quina totalmente configurada e poder\u00e1 acessa-l\u00e1 de forma simples com as credenciais enviadas para o seu email, <strong><a href=\"http:\/\/absam.io\/\">clicando aqui voc\u00ea poder\u00e1 criar a sua conta<\/a><\/strong>.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Etapa 1 &#8211;  Instalar SQLite no Ubunto 20.04<\/h3>\n\n\n\n<p>Primeiro vamos atualizar os repositorios do ubuntu<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt update<\/pre>\n\n\n\n<p>Agora instale o SQLite<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt install sqlite3<\/pre>\n\n\n\n<p>Verifique se a instala\u00e7\u00e3o deu certo<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlite3 --version<\/pre>\n\n\n\n<p>Voc\u00ea ver\u00e1 uma saida igual a essa:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">3.31.1 2020-01-27 19:55:54 3bfa9cc97da10598521b342961df8f5f68c7388fa117345eeb516eaa837balt1<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Etapa 2 &#8211; Criando um base de dados SQLite<\/h3>\n\n\n\n<p>Nessa etapa, vamos criar um banco de dados, vamos salvar carros com diferentes modelos e atributos. Abra o seu terminal e execute o seguinte comando para criar o sue banco.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlite3 cars.db<\/pre>\n\n\n\n<p>Ao rodar esse comando voc\u00ea entrar\u00e1 no shell, onde voc\u00ea poder\u00e1 rodar comandos sql. Se voc\u00ea n\u00e3o executar nenhum comando, o arquivo cars.db n\u00e3o ser\u00e1 criado.Para garantir que o arquivo seja criado, voc\u00ea pode executar uma consulta vazia digitando ;e pressionando \u201cEnter\u201d. Dessa forma, voc\u00ea ter\u00e1 certeza de que o arquivo de banco de dados foi realmente criado.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Etapa 3 &#8211; Cria\u00e7\u00e3o de uma tabela no SQLite<\/h3>\n\n\n\n<p>Bancos de dados de SQLite s\u00e3o organizados em tabelas. As tabelas organizam as informa\u00e7\u00f5es, nesse passo vamos entender como inserir os dados no nosso banco. Lembrando que todos os comandos devem se encerar com &#8220;;&#8221;<\/p>\n\n\n\n<p>Vamos acessar o nosso banco<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sqlite3 cars.db<\/pre>\n\n\n\n<p>Agora vamos criar uma tabela e algumas colunas para v\u00e1rios dados:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Um ID<\/li><li>O nome do carro<\/li><li>O tipo do carro<\/li><li>Pre\u00e7o do carro<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE TABLE cars(id integer NOT NULL, name text NOT NULL, cartype text NOT NULL, price integer NOT NULL);<\/pre>\n\n\n\n<p>Utilizaremos o NOT NULL para sinalizar que o campo \u00e9 obrigat\u00f3rio. Para mais informa\u00e7\u00f5es sobre tipos voc\u00ea<a href=\"https:\/\/www.w3schools.com\/sql\/sql_notnull.asp#:~:text=By%20default%2C%20a%20column%20can,a%20value%20to%20this%20field.\"> pode conferir aqui<\/a>.<\/p>\n\n\n\n<p>Depois de criar a tabela, um prompt vazio retornar\u00e1.&nbsp;Agora vamos inserir alguns valores nele.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Inserir dados na tabela<\/h4>\n\n\n\n<p>O SQLite, o comando para inserir valores em uma tabela segue esta forma geral:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">INSERT INTO nomeDaTabela VALUES(valores);<\/pre>\n\n\n\n<p>Agora insira tr\u00eas linhas de dadps em sua tabela de cars<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">INSERT INTO cars VALUES (1, \"Gol\", \"hatch\", 34000); \nINSERT INTO cars VALUES (2, \"Onix\", \"hatch\", 46000); \nINSERT INTO cars VALUES (3, \"Camaro\", \"esportivo\", 12800);<\/pre>\n\n\n\n<p>Pronto agora voc\u00ea tem 3 dados na sua tabela, na pr\u00f3xima etapa n\u00f3s iremos ler os dados que est\u00e3o salvos na tabela.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Etapa 4 &#8211; Lendo tabelas no SQLite<\/h3>\n\n\n\n<p>Nesta etapa vamos acessar a tabela cars dentro do banco e ler os dados que est\u00e3o salvos.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM cars;<\/pre>\n\n\n\n<p>Voc\u00ea ver\u00e1 os dados inseridos anteriormente<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">1|Gol|hatch|34000\n2|Onix|hatch|46000\n3|Camaro|esportivo|12800<\/pre>\n\n\n\n<p>Para visualizar um elemento filtrando por um ID especifico voc\u00ea pode utilizar<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM cars WHERE id IS 1;<\/pre>\n\n\n\n<p>Isso retorn\u00e1:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">1|Gol|hatch|34000<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Etapa 5 &#8211; Atualizando uma tabela no SQLite<\/h3>\n\n\n\n<p>Vamos agora atualizar a tabela, podemos atualizar modificando os valores ou adicionando novas colunas dentro da tabela.<\/p>\n\n\n\n<p>Use&nbsp;<code>ALTER TABLE<\/code>para criar uma nova coluna.&nbsp;Esta nova coluna definir\u00e1 o ano do veiculo.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE cars ADD COLUMN age integer;<\/pre>\n\n\n\n<p>Agora voc\u00ea ter\u00e1 uma nova coluna chamada <em>age<\/em><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Atualizando os valores<\/h4>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE cars SET age = 2015 WHERE id=1; \nUPDATE cars SET age = 2013 WHERE id=2; \nUPDATE cars SET age = 2017 WHERE id=3;<\/pre>\n\n\n\n<p>Nesta etapa, voc\u00ea alterou a composi\u00e7\u00e3o da sua tabela e, em seguida, atualizou os valores dentro dela.&nbsp;Na pr\u00f3xima etapa, voc\u00ea excluir\u00e1 informa\u00e7\u00f5es de uma tabela.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Etapa 6 &#8211;  Excluindo informa\u00e7\u00f5es  no SQLite<\/h3>\n\n\n\n<p>Agora voc\u00ea aprender\u00e1 a excluir um dado da tabela com base em algum argumento<\/p>\n\n\n\n<p>Neste exemplo, voc\u00ea estar\u00e1 excluindo um carro com base no ano (age), seja menor que 2014.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM cars WHERE age &lt;= 2014;<\/pre>\n\n\n\n<p>Voc\u00ea com essa condi\u00e7\u00e3o excluira o carro de id=2, pois o seu ano \u00e9 menor que 2014. Voc\u1ebd poder\u00e1 ver a tabela por completo e atualizada executando o comando <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM cars;<\/pre>\n\n\n\n<p>O resultado ser\u00e1<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">1|Gol|hatch|34000|2015\n3|Camaro|esportivo|12800|2017<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Conclus\u00e3o<\/h3>\n\n\n\n<p>SQLite \u00e9 uma ferramenta \u00fatil para gerenciamento de banco de dados.&nbsp;Pode-se criar um banco de dados rapidamente e manipul\u00e1-lo com v\u00e1rios comandos.&nbsp;Seguindo este tutorial, voc\u00ea agora tem um conhecimento b\u00e1sico do SQLite e est\u00e1 preparado para mergulhar mais fundo neste sistema de gerenciamento de banco de dados.<\/p>\n\n\n\n<p>Al\u00e9m de muitas integra\u00e7\u00f5es com diversas linguagens de forma simples, como Python, Node e PHP. Outra fonte confi\u00e1vel de informa\u00e7\u00f5es seria a <strong><a href=\"https:\/\/www.sqlite.org\/docs.html\">documenta\u00e7\u00e3o oficial.<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introdu\u00e7\u00e3o SQLite \u00e9 um sistema de gerenciamento de banco de dados gratuito, multiplataforma e facilmente integr\u00e1vel com diversas tecnologias. Neste tutorial, voc\u00ea instalar\u00e1 o SQLite no Ubuntu 20.04. Em seguida, voc\u00ea criar\u00e1 um banco de dados, ler, escrever, atualizar e [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":13641,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[],"class_list":["post-13640","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-conteudo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.1 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Como instalar a usar o SQLite no Ubuntu 20.04 - Blog da Absam<\/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:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como instalar a usar o SQLite no Ubuntu 20.04\" \/>\n<meta property=\"og:description\" content=\"Introdu\u00e7\u00e3o SQLite \u00e9 um sistema de gerenciamento de banco de dados gratuito, multiplataforma e facilmente integr\u00e1vel com diversas tecnologias. Neste tutorial, voc\u00ea instalar\u00e1 o SQLite no Ubuntu 20.04. Em seguida, voc\u00ea criar\u00e1 um banco de dados, ler, escrever, atualizar e [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog da Absam\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/absam.io\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-21T14:14:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"312\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Absam Cloud Platform\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Absam Cloud Platform\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\"},\"author\":{\"name\":\"Absam Cloud Platform\",\"@id\":\"https:\/\/absam.io\/blog\/#\/schema\/person\/526a6029912e48d2f2816fde49b0d3e4\"},\"headline\":\"Como instalar a usar o SQLite no Ubuntu 20.04\",\"datePublished\":\"2021-07-21T14:14:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\"},\"wordCount\":700,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/absam.io\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png\",\"articleSection\":[\"Conte\u00fado\"],\"inLanguage\":\"pt-BR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\",\"url\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\",\"name\":\"Como instalar a usar o SQLite no Ubuntu 20.04 - Blog da Absam\",\"isPartOf\":{\"@id\":\"https:\/\/absam.io\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png\",\"datePublished\":\"2021-07-21T14:14:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage\",\"url\":\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png\",\"contentUrl\":\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png\",\"width\":820,\"height\":312},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/absam.io\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como instalar a usar o SQLite no Ubuntu 20.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/absam.io\/blog\/#website\",\"url\":\"https:\/\/absam.io\/blog\/\",\"name\":\"Blog da Absam\",\"description\":\"Conte\u00fados sobre cloud computing, data centers, infraestrutura, automa\u00e7\u00e3o e alta performance para profissionais e empresas que buscam tecnologia de ponta\",\"publisher\":{\"@id\":\"https:\/\/absam.io\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/absam.io\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/absam.io\/blog\/#organization\",\"name\":\"Blog da Absam\",\"url\":\"https:\/\/absam.io\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/absam.io\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2024\/02\/logo-absam-150x150-1-1.png\",\"contentUrl\":\"https:\/\/absam.io\/blog\/wp-content\/uploads\/2024\/02\/logo-absam-150x150-1-1.png\",\"width\":150,\"height\":150,\"caption\":\"Blog da Absam\"},\"image\":{\"@id\":\"https:\/\/absam.io\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/absam.io\",\"https:\/\/br.linkedin.com\/company\/absam-io\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/absam.io\/blog\/#\/schema\/person\/526a6029912e48d2f2816fde49b0d3e4\",\"name\":\"Absam Cloud Platform\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/533a5ae229a9c1745080d3597147b43496aa54e17a639df69e2ed0b497d16b8b?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/533a5ae229a9c1745080d3597147b43496aa54e17a639df69e2ed0b497d16b8b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/533a5ae229a9c1745080d3597147b43496aa54e17a639df69e2ed0b497d16b8b?s=96&d=mm&r=g\",\"caption\":\"Absam Cloud Platform\"},\"url\":\"https:\/\/absam.io\/blog\/author\/absam\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Como instalar a usar o SQLite no Ubuntu 20.04 - Blog da Absam","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:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/","og_locale":"pt_BR","og_type":"article","og_title":"Como instalar a usar o SQLite no Ubuntu 20.04","og_description":"Introdu\u00e7\u00e3o SQLite \u00e9 um sistema de gerenciamento de banco de dados gratuito, multiplataforma e facilmente integr\u00e1vel com diversas tecnologias. Neste tutorial, voc\u00ea instalar\u00e1 o SQLite no Ubuntu 20.04. Em seguida, voc\u00ea criar\u00e1 um banco de dados, ler, escrever, atualizar e [&hellip;]","og_url":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/","og_site_name":"Blog da Absam","article_publisher":"https:\/\/www.facebook.com\/absam.io","article_published_time":"2021-07-21T14:14:54+00:00","og_image":[{"width":820,"height":312,"url":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png","type":"image\/png"}],"author":"Absam Cloud Platform","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Absam Cloud Platform","Est. tempo de leitura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#article","isPartOf":{"@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/"},"author":{"name":"Absam Cloud Platform","@id":"https:\/\/absam.io\/blog\/#\/schema\/person\/526a6029912e48d2f2816fde49b0d3e4"},"headline":"Como instalar a usar o SQLite no Ubuntu 20.04","datePublished":"2021-07-21T14:14:54+00:00","mainEntityOfPage":{"@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/"},"wordCount":700,"commentCount":0,"publisher":{"@id":"https:\/\/absam.io\/blog\/#organization"},"image":{"@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png","articleSection":["Conte\u00fado"],"inLanguage":"pt-BR"},{"@type":"WebPage","@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/","url":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/","name":"Como instalar a usar o SQLite no Ubuntu 20.04 - Blog da Absam","isPartOf":{"@id":"https:\/\/absam.io\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png","datePublished":"2021-07-21T14:14:54+00:00","breadcrumb":{"@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#primaryimage","url":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png","contentUrl":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2021\/07\/unnamed-file-1.png","width":820,"height":312},{"@type":"BreadcrumbList","@id":"https:\/\/absam.io\/blog\/como-instalar-a-usar-o-sqlite-no-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/absam.io\/blog\/"},{"@type":"ListItem","position":2,"name":"Como instalar a usar o SQLite no Ubuntu 20.04"}]},{"@type":"WebSite","@id":"https:\/\/absam.io\/blog\/#website","url":"https:\/\/absam.io\/blog\/","name":"Blog da Absam","description":"Conte\u00fados sobre cloud computing, data centers, infraestrutura, automa\u00e7\u00e3o e alta performance para profissionais e empresas que buscam tecnologia de ponta","publisher":{"@id":"https:\/\/absam.io\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/absam.io\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":"Organization","@id":"https:\/\/absam.io\/blog\/#organization","name":"Blog da Absam","url":"https:\/\/absam.io\/blog\/","logo":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/absam.io\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2024\/02\/logo-absam-150x150-1-1.png","contentUrl":"https:\/\/absam.io\/blog\/wp-content\/uploads\/2024\/02\/logo-absam-150x150-1-1.png","width":150,"height":150,"caption":"Blog da Absam"},"image":{"@id":"https:\/\/absam.io\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/absam.io","https:\/\/br.linkedin.com\/company\/absam-io"]},{"@type":"Person","@id":"https:\/\/absam.io\/blog\/#\/schema\/person\/526a6029912e48d2f2816fde49b0d3e4","name":"Absam Cloud Platform","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/secure.gravatar.com\/avatar\/533a5ae229a9c1745080d3597147b43496aa54e17a639df69e2ed0b497d16b8b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/533a5ae229a9c1745080d3597147b43496aa54e17a639df69e2ed0b497d16b8b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/533a5ae229a9c1745080d3597147b43496aa54e17a639df69e2ed0b497d16b8b?s=96&d=mm&r=g","caption":"Absam Cloud Platform"},"url":"https:\/\/absam.io\/blog\/author\/absam\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/posts\/13640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/comments?post=13640"}],"version-history":[{"count":0,"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/posts\/13640\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/media\/13641"}],"wp:attachment":[{"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/media?parent=13640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/categories?post=13640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/absam.io\/blog\/wp-json\/wp\/v2\/tags?post=13640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}