Re: [sqlite] Import XLS file?

There is FreeXL (https://www.gaia-gis.it/fossil/freexl/index) may suit your need. 2019/10/2 02:58, Winfried: Simon Slavin-3 wrote 1) export your XLS data in CSV format 2) Use the SQLite shell tool to import the CSV data into your database Thanks. Is there a free (beer|speech) tool to

Re: [sqlite] sqlite trig/geometry error

Hello, Obviously these trig functions comes from SpatiaLite. http://www.gaia-gis.it/gaia-sins/spatialite-sql-5.0.0.html 2019/1/4 1:01, Brent Wood: > Yep, either a SQL file run from a shell script or SQL's directly piped into > the sqlite3 command, eg: > > > > echo "insert into qgis_gps >

Re: [sqlite] Doing math in sqlite

You can use recently supported window function (portable): SELECT * FROM ( SELECT car, lag(date) OVER w last_date, date, od_reading - (lag(od_reading) OVER w) diff FROM mileage WINDOW w AS (PARTITION BY car ORDER BY date) ) q WHERE diff IS NOT NULL; 2018/12/21 11:48, Jungle Boogie: >

Re: [sqlite] HELP!

There are some cloud solutions: https://dbhub.io/ for sharing https://bedrockdb.com/ for distributed hosting 2018/11/11 8:49, am...@juno.com: > November 10, 2018 Dear Good People: I work for a company that has a many > locations with more than one person in every location. I want to share the >

Re: [sqlite] forming sqlite3_statements using stored sql

It seems that SpatiaLite (an extension for GIS) plans to support that: https://www.gaia-gis.it/fossil/libspatialite/wiki?name=Stored+Procedures 2018-11-02 03:53, Thomas Kurz: >> Rather than inserting the SQL into a user-visible table, it might be > preferable to support CREATE PROCEDURE. > > +1

Re: [sqlite] Database identified as zip

It opens correctly now. 2018-10-30 22:37, Richard Hipp: > On 10/30/18, Dingyuan Wang wrote: >> >> Is this considered a bug? > > Should be fixed on trunk, now. > ___ sqlite-users mailing list sqlite-users@mail

[sqlite] Database identified as zip

Dear list, When my database opened with sqlite3 command line program, it shows this: SQLite version 3.26.0 2018-10-29 21:01:28 Enter ".help" for usage hints. sqlite> .schema CREATE VIRTUAL TABLE zip USING zipfile('funddata.db') /* zip(name,mode,mtime,sz,rawdata,data,method) */; sqlite> select *

Re: [sqlite] Python program to convert CSV to sqlite

Hi, I've also written a similar script to convert csv to sql (SQLite and PostgreSQL compatible). This script doesn't require fancy external libraries, and will correctly identify data types. 2018-01-18 15:33, Simon Slavin: >