Cómo abrir ficheros sqlite en Windows.

Hoy necesitábamos consultar el contenido de un fichero .sqlite3 , un fichero de base de datos SQLite. Os dejamos cómo se puede hacer en Windows.

Abrir un fichero de SQLite en Windows.

Podéis bajaros un programa como DB Browser for SQLite, DB4S (aquí Github), que es un visor y editor ligero para ficheros de bases de datos SQLite. Una GUI, parecido a phpMyAdmin o Adminer para SQL.

También existe Spatialite.

Sólo tenéis que descargar el programa de la web, versión para Windows, y ejecutarlo. Desde ahí abrís el fichero y ya podéis ver la estructura, o editarlo.

No es nada avanzado, pero sirve para su función: poder consultar crear, modificar y consultar ficheros SQLite.

 

Os recomendamos los siguientes productos relacionados con la informática:

 

Amazon Basics - Cable HDMI 4K de 1.8 m, Alta Velocidad de 18 Gbps con Ethernet, 4K@60 Hz, 2160p, Negro

(535983)

3,59 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Auriculares USB C,In-Ear Auriculares Tipo C con Micrófono Control de Volumen de Llamadas Compatible con iPhone 15/15 Pro,Samsung S20/S21/S22,Huawei P50/Mate 30,iPad Pro,OnePlus,Pixel Dispositivo USB C

(8814)

7,99 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

HP 305 6ZD17AE, Negro y Tricolor, Cartuchos de Tinta Originales, Pack de 2, compatible con impresoras de inyección de tinta HP Deskjet, HP Deskjet Plus y HP Envy

(49119)

22,99 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Logitech K380 Teclado inalámbrico multidispositivo - Arena

(2068)

19,99 € (as of 21 noviembre, 2024 04:06 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

INIU Cable USB C, 100W 2m Cable de Carga Rápida QC de USB C a USB C, Cable Tipo C Trenzado Nylon de Datos Cargador de Teléfono USB-C para Samsung S22 iPad Pro MacBook Tabletas LG Google etc

(35011)

7,48 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Tarjeta Gráfica Gigabyte GEFORCE RTX 4070 SUPER 12 GB RAM

(316)

635,99 € (as of 21 noviembre, 2024 08:45 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

CMF by Nothing Buds Pro 2 Auriculares inalámbricos con Sonido HiFi, 50 dB Cancelación Activa de Ruido híbrida, 6 micrófonos HD y Efecto Audio Espacial - Naranja

(620)

45,00 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

ARCTIC MX-4 (8 g) - Premium Performance Pasta Térmica para Todos los procesadores (CPU, GPU - PC, PS4, Xbox), Muy Alta conductividad térmica, Larga Durabilidad, Aplicación Segura, No conductora

(15513)

5,50 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

Samsung 990 PRO 2TB PCIe 4.0 (hasta 7,450MB/s) NVMe M.2 (2280) SSD Interno (MZ-V9P2T0BW)

(9377)

178,99 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

AMD RYZEN ™ 7 9800X 3D 8 Núcleos/16 Hilos Desenfrenados, Arquitectura Zen 5, Caché de 104 MB, TDP de 120 W, Aumento de frecuencia de hasta 5,2 GHz, Socket AM5, Ventilador no Incluido

(22)

799,00 € (as of 21 noviembre, 2024 08:46 GMT +01:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)