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
      56
      ·
      4 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
        60
        ·
        edit-2
        4 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
          32
          ·
          4 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
          ·
          4 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
            ·
            4 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
              1
              ·
              4 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
          6
          ·
          4 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.