SQLite Forum

Timeline
Login

10 events by user itroot

2021-10-26
19:30 Reply: Configuring SQLite to wait indefinitely artifact: e90db2a100 user: itroot

Curious, why do you need that? It is possible to get an example of an actual use-case?

2021-10-20
11:41 Reply: Serialize database to text artifact: a4b831eb85 user: itroot

https://www.sqlite.org/cli.html#converting_an_entire_database_to_an_ascii_text_file

sqlite> .dump
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE test(info TEXT);
INSERT INTO test VALUES('info1');
COMMIT;
sqlite> 
2021-10-15
13:01 Edit reply: x86_64/amd64 sqlite3 binaries artifact: 429590a0e8 user: itroot

Probably project has access to this type of machine, as Fossil has 64-bit build on it's download page

13:01 Reply: x86_64/amd64 sqlite3 binaries artifact: 7cc7f1093e user: itroot

Probably project has access to this type of machine, as Fossil has 64-bit build on it's download page: https://www.fossil-scm.org/home/uv/download.html

12:39 Reply: (Deleted) artifact: 941b2f9a73 user: itroot

Will

sqlite> SELECT 0.875 * 24;
0.875 * 24 = 21.0
Run Time: real 0.000 user 0.000000 sys 0.000122
sqlite> 


work for you?

2021-10-12
19:02 Reply: x86_64/amd64 sqlite3 binaries artifact: e8627680c9 user: itroot

Ok, finally I wrote a script:

#!/usr/bin/env bash
set -euxo pipefail

cat <<__EOF | docker build -t sqlite:latest -
FROM ubuntu:20.04 as builder

WORKDIR /root

RUN apt-get update && apt-get install -y build-essential file libreadline-dev zlib1g-dev curl
RUN curl -sL https://www.sqlite.org/2021/sqlite-autoconf-3360000.tar.gz | tar xzv 
RUN cd sqlite-autoconf-3360000 && ./configure --enable-readline && make -j 
__EOF

docker cp $(docker create sqlite:latest):/root/sqlite-autoconf-3360000/sqlite3 ~/bin/sqlite3

It works, and I'm happy.

11:05 Reply: x86_64/amd64 sqlite3 binaries artifact: 89756c69c9 user: itroot

👍 wow really nice hack, thank you!

11:04 Reply: x86_64/amd64 sqlite3 binaries artifact: 8a2592faed user: itroot

The question is that sqlite download page gives you an ability to get 32-bit binaries (and not 64-bit, which is a mainstream now) for Linux xD .

And yep, sqlite shell is useful!

2021-10-08
19:56 Reply: x86_64/amd64 sqlite3 binaries artifact: 201b6bde66 user: itroot

Yep, x86-64 is not something exotic. It's just a 64-bit linux, I think it much more popular that 32-bit one nowadays.

2021-10-07
08:32 Post: x86_64/amd64 sqlite3 binaries artifact: f794ab0075 user: itroot

Hi!

I'm a bit curious that there is no easy way (except compiling from the amalgamation) to get the latest greatest sqlite binaries for amd64.

There are only 32-bit precompiled binaries for linux on the download page.

Is it possible to add there amd64 binaries as well? (And what should be done to make it possible?)

Thanks, and sorry if this question is stupid. :-)