SQLite documentation covers this quite well, see "Database File Format" [0] or have a look at pager.c source code [1]. SQLite database is actually recommended by Library of Congress for archiving [2]
0: https://www.sqlite.org/fileformat.html
380 karma · joined March 7, 2017
0: https://www.sqlite.org/fileformat.html
What really grinds my gears with this is the fact that you cannot see quarantined activity via the API. If you browse a user's overview on the website, you'll see comments/posts in quarantined subs with a "quarantined" label. But if you fetch the exact same data via API, the quarantined activity is simply not returned at all, even if the account is opted in to the quarantined subreddits. There is no way to retrieve this data, and as a result, my bot can't block users that hail from these cesspools...
Sorry for going off-topic on rant here, but yesterday I had a 3 months old win10 workstation refuse to start the built-in calculator app. It worked fine the evening before, and no updates were installed in between...
This is apparantly a common problem for many users. I found lots of possible solutions, but of course, none of them worked for me. I took ownership of install dirs, redeployed the appx, every hack I could find...
Eventually I gave up and copied calc.exe from a win7 computer -- of course it doesn't run on win10, that would be too easy. So I installed a third-party calculator and apologized to the user on behalf of Microsoft...
> Very urgently, I imagine, Microsoft is trying to change the perception of Windows 10
Nothing will change my perception of win10.
Very hard to find the time to upstream something like that when you are on a limited budget in the first place..
Glad to hear that! Running an open project is hard.
> [...] switched again (ClearSilver -> Genshi -> Jinja)
Genshi was current when I used it; I wasn't aware it had switched to jinja (or it slipped my mind by now..)
> Lack of Milestone customization: I'm not sure I understand.
Back then, there were no custom fields for milestones, and the code didn't make it easy to do. Of course, this means you need changes to search facilities, and any other parts of the codebase. I had to write that also, and the target workflow was not at all complex.
As for the performance, we had about 20k tickets and 2k milestones when the system was replaced. By then it had been completely unusable for a long time.
Honestly, the only positives I have to say about Trac concern real-world usage by a hacker. Once you've learned it, and hacked it to your liking, it's very productive. But to get to that point, it's a sixty feet tall stack of ugly hacks, and frankly I would not recommend it to anyone...
Again to be clear, I did not look at the trac repo in many years, nor do I intend to.
> It seems not that many people have enough time and long-term interest in contributing significant improvements to such projects.
I am not convinced that is the only reason. The trac mailing list was (in my opinion) hostile to people that showed up with an idea and willingness to work on it; nobody would give encouragement or guidance and there was usually a "fk off and fork" or two in there. People aren't going to stick around to contribute if the maintainers/community are not interested to include them. That is/was a serious shortcoming.
The data model was not well thought out, with lots of UNION and UNION ALL in the queries, row-modelling things that should be normalized, and so on. That's probably my #1 technical issue, in terms of the code, it was hard to correctly add functionality because things were just read into RAM and manipulated there (expert SQL knowledge is of no use when working with the trac database)
The switch of templating engine did not make the codebase simpler, but instead made everything more convoluted and difficult to work with.
The primary issue though, was the lack of Milestone customization, and the incredibly poor performance. I had to implement custom search, custom indexes, custom reports, and custom everything else. And this was a 5-person team, using only ticketing (no repo, no wiki, nothing).
No progress was made on GenericTrac [1] whatsoever for the 5+ years I ran Trac in production and followed the project. Bloodhound made a single release, and then I never heard a word about it again.
Honest question.... Long-term morphine use will not dull the mind?
Me too, historically anyway, but I'm not a fan of this half-way approach. Someone explicitly requested that Larry create an alias for the language [0].
> If another name is truly as superior as the full-rename proponents claim it would be, I believe the alias can become a defacto name through its sheer amount of use. Thus, the creation of the alias can be seen as a means for the full-rename proponents to prove their claims.
Emphasis mine. Among other things, this does not compute for me. Adopting three names for the language (Raku, Raku Perl 6, Perl 6) is the exact opposite of what the full-rename proponents are suggesting. You're not giving them an opportunity to prove their claims, you're giving them the middle finger. Or that's how it seems to me, anyway.
[0] https://rakudo.party/post/A-Request-to-Larry-Wall-to-Create-...
> Larry Wall has created a second name for the language, an alias or a "stage name" if you will. That name is "Raku". It can be used interchangeably with the original "Perl 6" name or even be combined with it to form "Raku Perl 6". Pick the one that works the best for you and use it consistently.
So it used to be 6.c for "Christmas", now it's "6.d" for "Diwali", it used to be "Rakudo Perl 6", now it's "Raku Perl 6". At this point I have to ask, are they trolling?
The game is "play once", and you don't get a chance to try alternate paths through it without purchasing it again. It was decent entertainment, but terrible value for money compared to... all other board games. Edit: it doesn't help that there are dozens of pandemic games and the concept was bled dry years ago.
Surely not the US? Right?
Oh absolutely, and let's not forget the middle between leaves and teaware: brewing technique. It's incredibly wide, ranging from decorative chaxi to "obviously bullshit" mid-air hand gestures to straight up science (heat retention, fermentation, etc).
> but goodness me am I ever passionate about tea.
It's a great hobby. However, my advice to beginners is always to keep the passion and dreams in check when it comes to purchasing decisions. If you think software marketing is bad and full of buzzwords ... don't try tea.
Babelcarp Chinese Tea Lexicon [0] is very useful if you are exploring tea culture. I will also throw in Baisao [1] as worth a read - if Zen monk turned tea seller sounds like your kind of thing.
Completely off topic, but here in Norway we also have a right to reverse-engineer software if the vendor can't or won't provide what you need to complete an integration. This has been the case since the 1960s if I remember correctly, and it's still in there after revising the law this year.
Ref: Åndsverkloven of 2018 §42 [0] (in Norwegian), https://lovdata.no/lov/2018-06-15-40/§42
I was a bit surprised to hear advertising for "reddit the site" towards a younger audience.. but there was plenty of it during the recent counter-strike major league event in London. Many times throughout the programme they "organically" discussed how everyone wants to be at the top of reddit, how it is the place you wanna be, etc. They obviously took money for it. I'd link videos, but the faceittv twitch channel is subscribers only. I would not be surprised if they are marketing in similar ways for other e-sports.
Aside, but another counter-strike event (eleague iirc) recently had an actual uniformed army officer handing out trophy to the winners. That I found truly distasteful.
That said, my bet for reddit is also on stagnation.
As a counterexample, Eric Torrell was recently shot to death by Swedish police [0] (link is Swedish). He was 20 years old with Downs syndrome and carrying a toy gun.
I had a pretty surreal experience last year. My youtube use is almost exclusively for learning; coding, maths, astronomy, science, and so on. Recommendations were never great for me, usually recommending videos I've already watched. At some point I inadvertently clicked a link to a teenage girl's vlog, and watched maybe 5 seconds of it before closing. Instantly half of my recommendations were teenage girl's vlogs. I then misclicked a video in recommendations a few days later, and it turned into exclusively teenage girl vlogs. A year later, it's slightly recovered, but I still get them.
I am pretty confident their recommendation would not be overrun with science if they inadvertantly click a video.
The real question is how can you disable Microsoft apps if you don't want them? For example, disable Cortana on a Win10 system and something new will break every day, including security updates.
There is an interesting lecture series by Donald Knuth on this topic which I've listened to multiple times. It's described here [0], but I can't find the recordings. It appears a condensed version was given at Google 10 years later [1]
[0] https://www-cs-faculty.stanford.edu/~knuth/mit-lectures.html [1] https://www.youtube.com/watch?v=JPpk-1btGZk
I recently deployed an upgrade of an "enterprise-type" jboss application, and it failed. The log file was literally 200kb of stack traces with some "INFO" entries sprinkled here and there.
I sent it to the vendor, and their response was "everything looks okay"
[0] http://forum.apollo-accelerators.com/viewtopic.php?f=9&t=190...
Back in the days, there was another way to access expensive conferences without a ticket. It probably still works in some locations. Basically, almost all hotels were equipped with camera/microphone in the lecture hall. This was broadcast on the hotel's TV system, so important people could do business from their room and keep up with the event.
These old systems had security in the TV itself; it was simply restricted from tuning in to certain channels (such as pay-tv), but the signals were broadcast everywhere. It's well known that you could get free pay-TV by bringing your own TV tuner. The same trick let you tune in to feeds from conference(s) hosted at the hotel - I know some famous talks from closed corporate events were recorded this way and distributed on the Internet underground... All you really needed was a room at the hotel.
Edit: my bad, I opened the link from a comment..
[0] https://medium.com/liberapay-blog/the-first-year-of-liberapa...
The article is dated February 2017, I didn't notice before "In 2017 we’re going to keep improving Liberapay." near the end. According to their frontpage today, 462 new donations were started in the past month (totaling €350/week). The headline seems misleading.