calpaterson

9 ms·

1. 91.▲
   by calpaterson 2y ago

   If csv files bring criminal liability then I am guilty. Sidenote: this particular criminal conspiracy is open to potential new members. Please join the Committee To Keep Csv Evil: https://discord.gg/uqu4BkNP5G Jokes aside,
2. 92.▲
   by calpaterson 2y ago

   It's mojibake for "probably a bad idea" [in Chinese]
3. 93.▲
   by calpaterson 2y ago

   Yes you're right, UTF-8 technically does as well. I've never seen them in real life either. UTF-16 BOMs do have a useful function as I recall: they really help Excel detect your character encoding (Excel is awful at detecting cha
4. 94.▲
   by calpaterson 2y ago

   榥\ue0af侬펭懃䒥亷
5. 95.▲
   You can't just assume UTF-8(csvbase.com)

   195 points by calpaterson 2y ago|471 comments
6. 96.▲
   Gmux – raise the PRs for a single feature across multiple repos(github.com)

   1 points by calpaterson 2y ago|0 comments
7. 97.▲
   by calpaterson 3y ago

   csvbase is written in Python instead of Perl and FCGI instead of "trad" CGI but otherwise is a lot like a site from 1994...
8. 98.▲
   by calpaterson 3y ago

   One of the things I really need to sort on csvbase is permissions. Currently it has something very basic: you own your table and it's either public (meaning everyone has read) or private (meaning only you have read). I really don&#x27
9. 99.▲
   Caching secrets of the HTTP elders, part 1(csvbase.com)

   142 points by calpaterson 3y ago|35 comments
10. 100.▲
    by calpaterson 3y ago

    I'm sorry you're not a fan :) I do take your point - to an extent. I think the subject you're touching on is basically that of configuration. Configuration is what allows you to change the behaviour of code without making a
11. 101.▲
    by calpaterson 3y ago

    Yes, though as I try to explain in https://news.ycombinator.com/item?id=39993176 the bit I was trying to get at is that for `pd.read_csv('csvbase://calpaterson/opcodes-6502')` there is no API surfac
12. 102.▲
    by calpaterson 3y ago

    http is already registered as a protocol and you can indeed do that already. It's printed on every table page. eg on https://csvbase.com/calpaterson/opcodes-6502 : import pandas as pd; opcodes_6502 = pd.rea
13. 103.▲
    by calpaterson 3y ago

    > Total clickbait title, obviously being able to make an HTTP request to an endpoint, and get a CSV back, is an API. Respecting the “accept” header to return different data formats, based on what the client requests, is totally fine&#x2F
14. 104.▲
    by calpaterson 3y ago

    > Exaggerative title aside I apologise for the title. Not intended to mislead, just to be a bit of fun :) > t's really cool to learn about how fsspec [...] I'm glad you took something from it. At the last place I worked I
15. 105.▲
    by calpaterson 3y ago

    I love your tool. If you want a slightly more structured version of Gists that speaks parquet try my own tool, csvbase :). I pasted this data in as https://csvbase.com/calpaterson/opcodes-6502 and you can get parquet
16. 106.▲
    It looks like a product but is a subscription (2021)(calpaterson.com)

    3 points by calpaterson 3y ago|0 comments
17. 107.▲
    Is Tesla more valuable than Toyota?(calpaterson.com)

    36 points by calpaterson 3y ago|99 comments
18. 108.▲
    Is Tesla more valuable than Toyota?(calpaterson.com)

    3 points by calpaterson 3y ago|1 comments
19. 109.▲
    by calpaterson 3y ago

    Thanks for your advice. I agree and will try to improve on this for the future
20. 110.▲
    by calpaterson 3y ago

    There is an nginx server running on debian stable somewhere in the dark heart of Germany. But I do have numerous tricks (too many, probably) to keep things quick. But there are still ways to be quicker. For example, the header photo is sm
21. 111.▲
    by calpaterson 3y ago

    That is very kind - glad to hear that you enjoyed it.
22. 112.▲
    by calpaterson 3y ago

    > Is there a reason to build a database on top of a filesystem abstraction rather than a block abstraction? Oracle DB for a long time supported running on raw partitions which I think suggests that the answer is "not really".
23. 113.▲
    by calpaterson 3y ago

    I was tempted to define and cite the term more carefully before I used it but that leadened the article a lot right in the middle and so I cut it and just hoped. It is a great concept and also a great book. I really enjoyed it but I'v
24. 114.▲
    by calpaterson 3y ago

    Thanks. I take your point on the first one and have corrected it (maybe you need to shift+F5 to bust your cache in order to see it). For the second one, what's your objection? That it's fragmentary?
25. 115.▲
    by calpaterson 3y ago

    Sorry - this was an early draft of a future post that somehow was submitted here. I've removed it now, thanks for proofreading :)
26. 116.▲
    by calpaterson 3y ago

    Sorry - this was a draft that I published accidentally while fixing a typo in another article and which someone apparently submitted it here before I could take it down. It should 404 now. Perhaps next week :)
27. 117.▲
    by calpaterson 3y ago

    Author here, I can't reply to the GP because that comment is "dead" but yes, please, be specific! Then I can fix the sentences that are bad and perhaps also improve in the future.
28. 118.▲
    by calpaterson 3y ago

    I have to say that I'm not hugely convinced. I don't really think that being able to pull out the keys before or after a prefix is particularly impressive. That is the basis for database indices going back to the 1970s after all
29. 119.▲
    Software Mitchell Baker logs off for good as CEO of Firefox maker Mozilla(theregister.com)

    4 points by calpaterson 3y ago|1 comments
30. 120.▲
    by calpaterson 3y ago

    He is considered to be aligned with the Putin regime: https://www.spectator.co.uk/article/sanction-gerhard-schr-de...