GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Conversation

Notices

  1. Embed this notice
    Anton Zhiyanov (antonz@c.im)'s status on Friday, 14-Jun-2024 19:44:50 JST Anton Zhiyanov Anton Zhiyanov

    UUIDv7 is nice. Still a 128-bit unique identifier, but also time-sortable with 1 ms precision.

    A UUIDv7 value encodes a unix ms timestamp, and you can decode it back.

    To work with UUIDv7 in SQLite, there's the sqlean-uuid extension.

    https://github.com/nalgeon/sqlean/blob/main/docs/uuid.md

    In conversation about a year ago from c.im permalink

    Attachments



    1. https://s3.c.im/media_attachments/files/112/614/532/674/980/104/original/a4b928bc4f63d73d.png

    Feeds

    • Activity Streams
    • RSS 2.0
    • Atom
    • Help
    • About
    • FAQ
    • TOS
    • Privacy
    • Source
    • Version
    • Contact

    GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

    Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.