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. ▲ 2
    The default prefix used to be "SQLite_". (2006)
    story by Tomte · 2025-03-14 · 0 comments
  2. ▲ 2
    Why SQLite Temp Files Use the Prefix "etilqs_"
    story by carlos-menezes · 2025-02-24 · 1 comment
  3. ▲ 1
    etilqs_
    story by tosh · 2024-09-16 · 0 comments
  4. …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
  5. …smart ** enough to know that calling the developer will not help get rid ** of the file. [0]: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14...
  6. …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
  7. …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]…
  8. Or the direct link thither: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14... .
  9. …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.
  10. 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…
  11. Link directly to the reason comment: https://github.com/mackyle/sqlite/blob/18cf47156abe94255ae14...
  12. ▲ 396
    Why sqlite3 temp files were renamed 'etilqs_*' (2006)
    story by bsmith89 · 2023-06-12 · 139 comments
  13. 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)
  14. …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…
  15. ▲ 1
    Prefix for SQLite Tmpfiles
    story by Tomte · 2022-03-22 · 0 comments
  16. ▲ 4
    Prefix for SQLite Tmpfiles
    story by Tomte · 2021-07-15 · 0 comments
  17. …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
  18. …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
  19. ▲ 1
    Prefix for Sqlite Tmpfiles
    story by Tomte · 2020-06-04 · 0 comments
  20. ▲ 2
    Prefix for Sqlite Tmpfiles
    story by Tomte · 2019-11-30 · 0 comments
  21. …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
  22. …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
  23. ▲ 1
    Prefix for Sqlite Tmpfiles
    story by Tomte · 2019-04-25 · 0 comments
  24. ▲ 2
    SQLite Source Code: “In place of a legal notice, here is a blessing”
    story by max10541 · 2019-02-11 · 1 comment
  25. ▲ 1
    Prefix for sqlite tmpfiles
    story by Tomte · 2018-12-16 · 0 comments
  26. ▲ 1
    Prefix for sqlite tmpfiles
    story by Tomte · 2018-07-11 · 0 comments
  27. ▲ 1
    Prefix for sqlite tmpfiles
    story by Tomte · 2018-01-02 · 0 comments
  28. ▲ 3
    Prefix for sqlite tmpfiles
    story by Tomte · 2017-08-21 · 0 comments
  29. ▲ 3
    Prefix for sqlite tmpfiles
    story by Tomte · 2017-05-20 · 0 comments
  30. …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
  31. 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”
  32. SQLite has had this problem: https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
    comment by Jabbles · 2016-01-19 · in “Subject: Urgent Warning”
  33. ▲ 1
    Implementing SQL PREPARE for sqlite
    story by mingodad · 2015-09-06 · 0 comments
  34. …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
  35. …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...
  36. See https://github.com/mackyle/sqlite/blob/3cf493d4018042c70a4db...
  37. The commit: https://github.com/mackyle/sqlite/commit/70b2e37d42971a61cc2...
  38. …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:…
  39. ▲ 792
    SQLite developer must have received a lot of phone calls
    story by DaGardner · 2015-03-13 · 108 comments