Hacker GitHub

← All repos

mackyle/sqlite

View on GitHub ↗ ★ 1,954 C

Unofficial git mirror of SQLite sources (see link for build instructions)

39 mentions on Hacker News by 28 people: 17 stories, 22 comments · first 2015-03-13 · latest 2025-03-14

Mentions per year 39 mentions · busiest year 2023 (8)
20082026
  1. …rather than just reporting "SQLite3 Database". It's convenient that `Pack` is 32 bits long ;) [0] https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... [1] https://www.sqlite.org/pragma.html#pragma_application_id
  2. …smart ** enough to know that calling the developer will not help get rid ** of the file. [0]: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14...
  3. …extension of "etilqs". That's a grandiose example of this. That was not even a documentation link! https://github.com/mackyle/sqlite/blob/3cf493d/src/os.h#L52-...
    comment by fsniper · 2023-11-30 · in XCurl
  4. …alternative front-end for "non logged in" github users. I like it, but it still needs work. [1] https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... [2] https://gh.bloatcat.tk/mackyle/sqlite/blob/18cf47156abe94255... [3]…
  5. Or the direct link thither: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... .
  6. …you also notice that the link is simply a link to the file, not a specific line (something like https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... ), so you are expected to read the whole C file to figure out why.
  7. Looks like the line numbers were lost: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... It's because McAfee started using SQLite, angry users would stumble upon the files, do a minimum of searching or thinking, and be…
  8. Link directly to the reason comment: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14...
  9. etilqs[1] [1] https://github.com/mackyle/sqlite/blob/3cf493d/src/os.h#L52-...
    comment by supriyo-biswas · 2023-01-29 · in The Untold Story of SQLite (2021)
  10. …were receiving phone calls in the middle of the night, so decided to change temporary files prefix: https://github.com/mackyle/sqlite/blob/3cf493d/src/os.h#L52-... In both cases, their libraries were used in some other software, which…
  11. …found license of SQLite, so obviously they decided to contact SQLite and complain on bad software. https://github.com/mackyle/sqlite/blob/3cf493d/src/os.h#L52-... Now imagine facebook api breaks backwards compatibility, so you get 1000 of…
    comment by agilob · 2021-01-31 · in GitHub Should Start an App Store
  12. …It appears that it is an etilqs_ prefix rather than .etilqs but the story is somewhat humorous: https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
    comment by kevincox · 2020-08-16 · in SQLite 3.33
  13. …is amazing. It has very clean and readable code, so I'd suggest using it as a reference as well: https://github.com/mackyle/sqlite
    comment by photon_lines · 2019-09-22 · in Ask HN: Resources for Learning about Databases
  14. …to "etilqs_" because they were getting support calls and abuse for unrelated applications [1] [1] https://github.com/mackyle/sqlite/blob/3cf493d/src/os.h#L52-...
    comment by SaberTail · 2019-08-23 · in WiringPi – deprecated
  15. …to admins what's happening. (On the other hand, some projects need to make things _less_ clear - https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db... - "users would (...) call [the developers] to wake them up at night and…
    comment by JoachimSchipper · 2017-04-08 · in New Features Coming in PostgreSQL 10
  16. Reminds me of the SQLite developers who got overwhelmed: https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
    comment by Tomte · 2016-11-14 · in “I have toyota corola”
  17. SQLite has had this problem: https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
    comment by Jabbles · 2016-01-19 · in “Subject: Urgent Warning”
  18. …frequently see linked lists used for all manner of things, in some widely deployed performant code: https://github.com/mackyle/sqlite/search?q=linked+list https://github.com/freebsd/freebsd/search?l=c&q=linked+list
  19. …the file format is very well documented, for example: https://www.sqlite.org/fileformat.html or https://github.com/mackyle/sqlite/blob/master/src/pager.c#L2...
  20. See https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
  21. The commit: https://github.com/mackyle/sqlite/commit/70b2e37d42971a61cc2...
  22. …know, GitHub has a cool little feature that allows you to link directly to line ranges, i.e. https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db... See the awesome GitHub Cheat Sheet for details:…