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
      48·
      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
        54·
        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
          27·
          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.onlineEnglish
          17·
          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
            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.onlineEnglish
              2·
              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
          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.

      • HowManyNimons@lemmy.world
        3·
        4 months ago

        Sounds like the boss wanted a grid layout of some kind. Honestly, if they can express themselves in Excel, and they can be made to understand the limitations of responsive Web design, then it’s not so bad. At least it’s a requirement and you don’t have to guess.

  • BluesF@lemmy.world
    15·
    4 months ago

    Ah, good ol’ TEXTJOIN. I’ve used excel to write M before when I couldn’t figure out a way to do something concisely but I also couldn’t be bothered to write it out by hand. In hindsight, I was a shit programmer, but I’m at least good enough now that I can see how shit I was then!

  • umbraroze@lemmy.world
    15·
    4 months ago

    Flashback to my first job. Coworker designed a giant complex web app with bazillion UI messages. Another coworker (in the Management) sent me the UI messages. As an Excel file.

    I was tasked to manually convert the messages to a PHP data structure of some description (because this was 2002 and Excel files didn’t exactly lend themselves to scripting in Linux). Surprisingly, the management person did acknowledge my complaint that the conversion process was far more painful than necessary. Not that this helped, because soon after the startup got acquired and as far as I know the tech currently only exists in conceptual level in some big corporate vault or other.

      • umbraroze@lemmy.world
        7·
        4 months ago

        This was so long ago that I can’t actually remember the actual reason why things had to be done by hand. Part of it may have been a conversion snag, but there were probably some other reasons why it wasn’t as simple as writing a script to do the job. Because I distinctly remember I wrote some scripts to help with other data conversion jobs.

  • oo1@lemmings.worldEnglish
    5·
    4 months ago

    l often get sent a long list of info/ criteria in excel. It’s often easiest (and traceable / maintainable back to their request) just to stay in the excel to generate large chunks of the SQL

  • pseudo@jlai.lu
    2·
    4 months ago

    I’ve build entire databases/management tools out of Excel with following of administrative file completion, warning of due payment and KPIs. It was a pain to build but it kinda worked. Then I learn to build actual relational database and I went on rebuilding them on PostgreSQL… as a back, using Acess as front that would allow Excel-like usage and Excel export of the request response.
    We can say what we want about Excel but it is working really well and people are already formed to use it or at least they are enough familiar with it so they are not nearly as frighten by the idea of learning Excel as they are to learn to read a single-table SELECT SQL statement.