What about pedestrians trying to cross these streets you want to blaze along?

Nothing changes for them. Pedestrians have the right of way on a crosswalk regardless of whether a signal is in play. It’s the cyclists responsibility to avoid the pedestrian which is generally a matter of cycling behind the pedestrian, sometimes slowing down a bit if needed.

What about bicyclists who need to merge, or perhaps are not as fast as you?

No need for stopping; just vary speed as needed.

Do you not yield to traffic in roundabouts??

Depends on if the traffic is cars or cycles as far as whether yielding requires a stop. Cars move a lot of mass very fast so I must stop if timing forces me to. And that’s frequent. Roundabout traffic in the form of cycles does not require stopping. I’ve seen it 1st hand at Critical Mass events. You only need to vary your speed, unless the round about is so clusterfucked with bikes that you need to stop, which is rare and would never be a realistic scenario outside of Critical Mass. But if it were, I would argue that the civil engineers fucked up… that the roundabout is not proportioned for the capacity it needs to serve. Regardless, in the very worst of cases you never need to be stopped at a roundabout when there is no traffic. Stops also only last as long as necessary. They are not artificially imposed by the timing of a traffic light.

Of course it is, when “Big Brother” is going to block you from becoming “road pizza”.

lookup “traffic circles” and “roundabouts”.

Nonsense. Every single red light in my daily journies could be eliminated if cyclists were not sharing the road with 100s of 1000s of cars bringing 1000s of kilos of glass and steel to the equation.

Let’s not attribute surveillance harms and faults to victims of mass surveillance.

Privacy is about control and having autonomy. Both privacy and autonomy are human rights, which Tesla and other mass surveillance pushers encroach on. Worth noting that there exists a demographic of cyclists who cycle for the privacy it gives.

My point exactly. Cyclists who are mindful of laws of physics but not traffic law could potentially get burnt by Tesla.

I might try scraping. It’s not my 1st choice but it might be a viable plan B.

Guess I will mention that the library search page blocks Tor and my machine does not work on clearnet, which was yet another motivating factor in my request. But I can always work around that on a one-off basis… to either scrape or grab a whole DB.

You asked, but didnt like the answer.

I was looking for good answers. Convincing answers. Which I expected to correspond with data volume.

In any case, good answers are defensible, should the occasion arise. When you cannot defend your answers, it indicates a lack of justified confidence despite an expectation that others adopt some kind of blind confidence in your answers.

It is simple in sqlite (which is purpose-built to be simple and small,) so you assume all other databases are equally simple.

It’s the other way around. I expect a simple DB to be more basic. A more complex DB should be even more featured. If, for example, an Oracle DB cannot easily handle the job that a small and simple home kit can, Oracle should be embarrassed.

and self-centered.

Yikes! What leads you to think this is about me? It’s about databases. I did not invent sqlite. It was an example. You can fuck off with your vitriol.

Someone would need to query the data and encode it to JSON/etc. on the fly. There may not be a way to do this without having one of the programmers directly connect to the DB and run custom queries.

I use sqlite. They are probably using some heavier duty db but for sqlite exporting JSON is trivial so I would be surprised if other DBs did not have a similar mechanism. And to be clear, I said to the library that I prefer JSON but would handle whatever open format they prefer, be it XML or CSV.

To dump everything blindly would be irresponsible. It’s possible the DB could lock up or that incorrect/inappropriate data could be queried.

This does not sound like a realistic problem. I might imagine if they had a DB of all ISBNs, they would obviously have to use a query that limits to their catalog. Apart from that, I don’t see what would be inappropriate. If it’s in their catalog, why hide it? Not sure what you have in mind but I should say it’s not the US where there would be some right wing concern to prevent children from getting sex education type of material, or the Christian right trying to make Darwin’s theories hard to reach.

If you are thinking in terms of sensitive info, like accounts of people and what they borrow, it would be irresponsible if that kind of info were not in a separate table.

Their software is either homebrew or off the shelf. If it’s off the shelf, they may need to put in a support ticket and have their vendor figure it out. It’s highly unlikely there is a government employee or team sitting around and waiting for your request.

I was expecting my request to be ignored, as open data requests often are – and rarely fufilled in my experience even when they answer. But in the case at hand, they first responded favorably, saying essentially: we can give you some data but your request is vague… what exactly do you want? I basically replied with “everything”. So they were not opposed to exporting some data, but the volume involved (100s of 1000s of records) seems to be a show-stopper.

I believe that the library has a point about not performing this amount of work on an individual request.

I might agree that it’s a bit much to serve one person. They also said it would take disproportionate resources when they have a whole public to serve. But I was figuring “build it, and they will come”. There would be a first person to make a request. I am a bit disappointed that if it were made available that we could not expect many people to exploit the option to be free from the UIs limitations.

You seem to be saying: find out what you want and ask the library for it. I tried that once. I asked for a particular book. The librarian basically said “nope, we don’t have it… but English bookstore X might have it”.

Note that I am generally interested in English content in a non-English region. There are some English books and media for whatever reason (certainly with DVDs it’s because the original film is often in English) but asking them to procure something in English is probably a long shot… a bigger ask than asking them for a DB of what they have.

So, to me it seems like the main reason you would want this list in the first place is not to waste time deciding on something only for it to not be at the library in the end.

The point in doing an SQL intersection between a long list of some sort and their DB is to find what they already have that may be interesting. It’s not to discover what they don’t have.

(dupe deleted)

I think it should be feasible, if you can reach them. I’m done with github, who forced 2FA on my acct via email confirmation before my email address died. I’m not going to dance for Microsoft in order to give my attention and interaction to MS users.

In principle, I think if someone were to set up a TeX-specific forgejo/gitea instance, it would be attractive for LaTeX devs because they probably are not getting much benefit from be centralised on Github anyway. It was likely an arbitrary choice for them. If there were a LaTeX-themed git community, it would be attractive.

I harvested the CTAN DB to research this. The results:

   1390 github.com
     90 gitlab.com
     36 sourceforge.net
     31 codeberg.org
     20 tug.org
     18 framagit.org
     16 bitbucket.org
     10 git.gnu.org.ua
      8 gitlab.gutenberg-asso.fr
      8 gitee.com
      6 dickimaw-books.com
      5 puszcza.gnu.org.ua
      5 heptapod.host
      3 git.robertalessi.net
      3 git.framasoft.org
      2 lists.tug.org
      2 git.sr.ht
      2 gitlab.ti.bfh.ch
      2 gitlab.inria.fr
      2 gitlab.adullact.net
      2 gitea.com
      1 uds-datalab.github.io
      1 tufte-latex.github.io
      1 todo.sr.ht
      1 texnia.com
      1 svn.tuxfamily.org
      1 svn.gnu.org.ua
      1 svn.code.sf.net
      1 svenharder.github.io
      1 savannah.nongnu.org
      1 savannah.gnu.org
      1 repo.or.cz
      1 qa.parsilatex.com
      1 plmlab.math.cnrs.fr
      1 osda.ws
      1 latex-project.org
      1 humenda.github.io
      1 guitex.org
      1 git.umaneti.net
      1 git.savannah.nongnu.org
      1 git.savannah.gnu.org
      1 git.ortolo.eu
      1 git.linta.de
      1 gitlab.science.ru.nl
      1 gitlab.reutlingen-university.de
      1 gitlab.git.nrw
      1 gitlab.fi.muni.cz
      1 forge.apps.education.fr
      1 bastien-dumont.onmypc.net
      1 archiv.dante.de

The 3 most common forges for LaTeX projects are shitty centralised walled-gardens (MS Github, Gitlab, & Sourceforge). Only 174 projects out of 1690 are using open access free-world/decentralised forges (~10%).

It is disturbing indeed. It also means reporting bugs on ~90% of LaTeX pkgs requires dancing with an evil gatekeeper, licking boots, etc.

A lawyer once told me there are a few left-leaning AGs who genuinely take the consumer protection role seriously. He named off a few states where he said you can expect decent treatment of compaints. Then he said a lot of AGs have no interest in the job at all. That they are just looking to climb the ladder and get a CV that enables them to run for governor. I think I have been quite unlucky with the states that are relevant to where I get burnt as a consumer. Though I don’t suppose that’s chance. The shittiest corporations are likely to select right-leaning anti-consumer states for their HQ.

I don’t consider successors to necessarily obsolete their predecessor. People still use and appreciate vinyl records despite having several successors (including magnetic tape which eventually lost ground to vinyl in the end, amid digital successors).

The story:

https://slrpnk.net/post/34202438

A commenter wrote:

“Just as stubbing your toe serves to remind you that you are real and alive, days-long server outages remind us that we are bare metal and not on a government-compromised cloud.”

Indeed!

Have you never heard SSNs called slave surveillance numbers? It’s the same thing. They are synonyms – borne from the fact that what was originally simply intended as a primary key in the DB of one gov administration became a global identifier ripe for abuse.

Better headline / TL;DR:

🇺🇸 Entire US social security DB¹ was exfiltrated by Elon’s DOGE and leaked to Cloudflare². (¹ SSN, name, home address, medical+bank+credit card info, tax details, work histories,…; ² corp that already sees ~⅓ of all your web traffic)

Interesting extracts here.