Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
schleuss.online is one of the many independent Mastodon servers you can use to participate in the fediverse.
This instance has a focus on IT security, general computing, retro video games and game collector discussion. Please, no #NSFW and other 18+ discussion on this instance. See rules for more details

Administered by:

Server stats:

10
active users

schleuss.online: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sqlite

0 posts0 participants0 posts today
Continued thread
Public
SuperIlu

I managed to fix the #SQLite issue.

So far the #curl problem eludes me.
Curl checks if the connection is established using select().

On #Win10 this eventually returns 1, on #win98 it always returns 0.

I checked with a self made endpoint and the connection is established. Only cf_tcp_connect()->SOCKET_WRITABLE()->Curl_socket_check()->Curl_poll()->our_select()->select() never sees it 😥

Public
FErki

I accept a few new customers in the coming weeks. Contact me when your:

- systems getting too slow or old
- IT solutions are getting too expensive
- software and infra takes too long to change
- customers face too many bugs or outages

I often work with #OpenSource projects like: #Perl #Gentoo #Linux #PostgreSQL #SQLite #Laminar #CICD #Rex #OpenStack

I offer 50% discount when publishing our work results under free/libre/open source terms.

See my profile & DM me for details!

#getfedihired
Public
FErki

I accept a few new customers in the coming weeks.

I'm on a mission to enable high performance IT systems and software delivery for growing organizations.

Contact me when your:

- systems getting too slow or old
- IT solutions are getting too expensive
- software and infra takes too long to change
- customers face too many bugs or outages

I often work with #OpenSource projects like: #Perl #Gentoo #Linux #PostgreSQL #SQLite #Laminar #CICD #Rex

See my profile & DM me for details!

#GetFediHired
Public *
scy

Did you know that you can have a #SQLite CLI config file? Pretty handy for changing the default memory limit, output format, or even print a nice banner.

Here's mine:
codeberg.org/scy/dotfiles/src/

It allows SQLite to use up to 1 GiB of page cache, uses nice Unicode box drawing characters, and tracks the runtime of queries by default. It also reminds me of how to turn these things off again.

(Pro tip: Set `.timer on` last, else it will print the stats for each of the start-up commands … 😬)

Screenshot of me using the SQLite command-line tool, invoked as `sqlite3 addr.sqlite`. It prints: -- Loading resources from /home/scy/.sqliterc Setting `.headers on`, `.timer on` and `.mode box --wrap 32 -ww`. Other helpful modes are `list`, `json`, `csv`, `tabs` or `insert`. SQLite version 3.40.1 2022-12-28 14:03:47 Enter ".help" for usage hints. Then, at the prompt, I enter: select * from attributes limit 10; The result is an easily human-readable table with header (type, id, lat, lon, key, value) and values like n, 129, 53.9593574, -1.0815173, addr:city and York. After the 10 entries in the table, before the next prompt, SQLite prints: Run Time: real 0.000 user 0.000000 sys 0.000999
#CLI
Continued thread
Public
scy

So, uhm, not to dunk on Photon, but I've just built a proof of concept #SQLite database containing all of the addresses in OpenStreetMap and created a full-text search index over them.

A query like "give me all OSM objects where any of the address fields starts with 'Frankf'" takes 36 ms and uses 11 MB of RAM.

That's a FTS5 trigraph search over 13.5 million unique strings and then joining them with nodes & ways.

The database takes 25 GB, compared to Photon's 230 GB.

I'm impressed.

Public
FErki

I accept a few new clients in the coming weeks.

I specialize in making IT infrastructure and software delivery solutions faster and cheaper in the cloud and on-premises.

My clients hire me because of my no-nonsense approach: transparent, pragmatic, and holistic.

I often work with well-known #opensource projects such as #perl, #gentoo #linux, #postgresql and #sqlite, as well as niche ones like #laminar #cicd and #rex.

Please DM if interested, and boost for reach!

#getFediHired#freelance
ExploreLive feeds
About