rogerbinns

7 ms·

31.
by rogerbinns 1y ago
Unless you compile SQLite yourself, you'll find the maximum mmap size is 2GB. ie even with your pragma above, only the first 2GB of the database are memory mapped. It is defined by the SQLITE_MAX_MMAP_SIZE compile time constant. You
32.
by rogerbinns 1y ago
The general test suite is not proprietary, and is a standard part of the code. You can run make test. It uses TCL to run the testing, and covers virtually everything. There is a separate TH3 test suite which is proprietary. It generates
33.
by rogerbinns 1y ago
I'd love to see an analysis of byte ordering impact on CPU implementation. Does little vs big endian make any difference to the complexity of the algorithms and circuits?
34.
by rogerbinns 2y ago
Yes you need calibration files for supported models. You can see the details and explanation at the asahi audio repository. They also criticize the MacOS curves, and point out how some Windows vendors are doing the same DSP approach. htt
35.
by rogerbinns 2y ago
This is how Apple addressed audio hardware and do something similar for speakers. Instead of trying to make speakers that have the desired frequency response or microphones that produce the desired signal, they let the analog hardware do w
36.
by rogerbinns 2y ago
SQLite has a session extension that can record changes on a local database into a changeset and you can replay those changes on another SQLite instance. Note that it replays what the changes were, not the queries that resulted in the chang
37.
by rogerbinns 2y ago
Rump kernel/anykernel is the concept. The drivers can run in user space with minimal underlying support. https://en.wikipedia.org/wiki/Rump_kernel
38.
by rogerbinns 2y ago
Location: Santa Cruz, California Remote: Yes Willing to relocate: No Technologies: Python (including its C API), C, SQLite (C API), Linux, deep techie generalist Résumé/CV: https://www.rogerbinns.com/rogerbresume.html
39.
by rogerbinns 2y ago
Where I worked we got an early system as we made graphical desktops for workstations. IBM required that we have a separate locked room for the system! Despite having over 20 different brands/Unix systems, AIX was the only one we had t
40.
by rogerbinns 2y ago
SQLite itself is in C so you can use the API directly https://www.sqlite.org/fts5.html#custom_tokenizers The text is in UTF8 bytes so any C code would have to deal with that and mapping to Unicode codepoints, plus lots of o
41.
by rogerbinns 2y ago
My project APSW may have exactly what you need. It wraps SQLite proving a Python API, and that includes the FTS5 full text search functionality. https://rogerbinns.github.io/apsw/textsearch.html You can store your te
42.
by rogerbinns 2y ago
My technique is to give an estimate with error bars. Something like 6 weeks plus or minus 2. That then leads into discussion as to what is unknown/undefined leading to the uncertainty. Sometimes the error bars are larger than the es
43.
by rogerbinns 2y ago
I worked on X.Desktop at IXI. All the Unix workstation vendors (and I mean all of them) had us port X.Desktop to their Unix systems. We had over 20 varieties of Unix systems in our office including Sony workstations, IBM, HP, Motorola,
44.
by rogerbinns 2y ago
Actually providing electricity consists of two parts. There is the fixed infrastructure of all the transmission lines, transformers, maintenance, and similar, plus the preparedness of generators to provide electricity on demand even when i
45.
by rogerbinns 2y ago
If you are offering consumer products, then you generally want to offer 3 tiers. It is conventionally known as good-better-best [1]. But you also have to be careful attaching your brand to all three because people don't want to pay b
46.
by rogerbinns 2y ago
The PyUnicode object is what represents a str. If the UTF-8 bytes are ever requested, then a bytes object is created on demand and cached as part of the PyUnicode, being freed with the PyUnicode itself is freed. Separately from that the co
47.
by rogerbinns 3y ago
I use vscode. It didn't have line by line operations until recently. The sweet spot is working on hunks, not lines. For example hunk operations are quick and easy with short menus, while selecting some text then has the regular righ
48.
by rogerbinns 3y ago
Thanks - I eventually found it in the package repositories. It does indeed have the same functionality as gitg for staging and reverting individual lines. It does have several UI niggles. For example when selecting it does not do so on a
49.
by rogerbinns 3y ago
Not a gui, and rather painstaking. With gitg you single click on lines in changes (green added, red removed) which selects them. You can separately click on as many disjoint ones across as many hunks as you want. There is a 'Discard
50.
by rogerbinns 3y ago
git gui says unknown command for me. gitk doesn't let you click on individual lines, and revert or add them as far as I could find.
51.
by rogerbinns 3y ago
> but haven't seen any apps built with it yet. The gitg git gui is written in vala. I've used it for several years because it allows easy staging of individual lines, as well as reverting them. https://github.com&#x
52.
by rogerbinns 3y ago
It is well worth understanding how these older computers worked. All the components were doing double or triple duty, so that together all the tasks like refreshing memory, reading/writing memory, generating video, generating audio, a
53.
by rogerbinns 3y ago
A relevant term is "help vampire". The original post describes how to spot them, and suggestions for addressing it. https://slash7.com/2006/12/22/vampires/
54.
by rogerbinns 3y ago
One big mistake SourceForge made was not scoping repositories. There could only be one project of a name on the entire site, which is why there was manual review. People naturally wanted to participate at the one true project, not a differ
55.
by rogerbinns 3y ago
I see your =) and raise you this: ren *.htm *.html
56.
by rogerbinns 3y ago
The company I worked at IXI [1] was the leading provider of Motif. We took the official release, fixed all the bugs, documented it, and sold it with most companies using Unix workstations buying licenses. We also did better versions of th
57.
by rogerbinns 3y ago
Binary Coded Decimal was also popular - eg most processors included instructions for operating that way. You need 4 bits for a BCD digit, so a multiple of 4 bits is convenient. https://en.wikipedia.org/wiki/Binary-code
58.
by rogerbinns 3y ago
They wouldn't decide for you, merely make you an offer. Eg you say "go to supermarket A" which you fully intend to go to because it fully meets your needs and expectations. You get an offer to go to supermarket B instead, a
59.
by rogerbinns 3y ago
The most valuable owner in this space is whoever you communicate with to tell them where you want to go. They get to offer you a price, they get to offer you alternative destinations, and they get to offer you "deals". For examp
60.
by rogerbinns 3y ago
It depends on how much you operate it. They (used to) cost around $1.6m per month to lease. Airlines typically get around 14c per seat per mile in revenue, and would make a slight loss if it wasn't for their frequent flyer programs (

More ›