My sister started a new position that involves HTML. She tried to explain an issue to me, but I’m not a web guy. I told her to send it to me on Monday and she sent this…

  • ByteOnBikes@slrpnk.net
    link
    fedilink
    arrow-up
    55
    ·
    5 months ago

    https://css-tricks.com/css-database-queries/

    1. Use a hand-modified-to-ESM version of SQL.js, which is SQLite in JavaScript.
    2. Get a database ready that SQL.js can query.
    3. Build a Houdini PaintWorklet that executes queries in JavaScript and paints the results back to the screen in that <canvas>-y way that PaintWorklets do.
    4. Pass the query you want to run into the worklet by way of a CSS custom property.
    • herrcaptain@lemmy.ca
      link
      fedilink
      arrow-up
      61
      ·
      edit-2
      5 months ago
      1. Go straight to jail.

      Edit: No idea what’s up with the formatting. In my app this shows as step 5 but it seems to render as step 1. Is the Lemmy DB done in CSS?

      • morrowind@lemmy.ml
        link
        fedilink
        arrow-up
        31
        ·
        5 months ago

        Lemmy is fine, it depends on the markdown parser/renderer. Markdown allows you to use any numbers for numbered lists and the renderer is supposed to display them corrected.

        As you can imagine that leaves a lot of ambiguity

      • OpenStars@discuss.online
        link
        fedilink
        English
        arrow-up
        19
        ·
        5 months ago

        For me it shows as step 5, in Firefox on Android using web browser interface. Also I can view your source which shows as simply “5. Go…”, so it is definitely your app.

        • herrcaptain@lemmy.ca
          link
          fedilink
          arrow-up
          5
          ·
          5 months ago

          Weird! Thanks for letting me know. I guess that’s what I get for using an app (Sync) that the developer abandons for months at a time.

          • OpenStars@discuss.online
            link
            fedilink
            English
            arrow-up
            2
            ·
            5 months ago

            It’s not the best UI, but you can also view your comment from a standard web browser, just to see how it looks. The advantage to the web browser is that it is always by definition maximally up-to-date:-) - though its baseline functionality may still be lower than an app if the latter is done well.

      • melvisntnormal@feddit.uk
        link
        fedilink
        arrow-up
        7
        ·
        5 months ago

        Put a slash before the dot, like 5\.:

        5. Go straight to jail.

        This is a Markdown issue really. Starting a line with a number and then a dot turns that line into an item in an ordered list. The most common behaviour (that I’ve seen) is to start that list from 1, regardless of what number is used. The intent is to make it easy to add items later without renumbering everything, for living documents at least.