anti-idpol action

I am working on fedi software that is hoping to allow Kodi, Plex and Popcorn Time get rid of IMDb/TMDB dependency. Dm me if you’re skilled in SvelteKit and/or Go, especially the Fiber framework, or machine learning with Rust and willing to contribute.

  • 0 Posts
  • 66 Comments
Joined 1 year ago
Cake day: September 10th, 2023
  • anti-idpol action@programming.devtoProgramming@programming.dev•SQL Has Problems. We Can Fix Them: Pipe Syntax In SQL
    1·
    1 month ago

    In Clojure, -> is used for inserting the piped argument at the head position in the arguments of whatever it is passed to, while ->> is used for inserting it at the tail. This approach is great for working with immutable data in a series of approachable transformations, which I believe is one reason why so many Domain-Specific Languages for generative programming are written in that language, aside from its interactive REPL. Additionally, there is no need to worry about excessive copying, as this is generally well optimized.

    This can be particularly useful with HoneySQL, which is more of a DSL for SQL rather than a typical ORM tool. For example:

    (defn apply-filters [query filters]
"applies WHERE clauses to a query"
  (reduce (fn [q [column value]]
            (helpers/where q [:= column value]))
          query
          filters))

(defn build-dynamic-query [{:keys [table columns filters sort-by limit]}]
  (-> {}
      (helpers/select columns)
      (helpers/from table)
      (apply-filters filters)
      (helpers/order-by sort-by)
      (helpers/limit limit)
      sql/format))

;; Result - a super readable function call that resembles a natural language 
(build-dynamic-query 
  {:table :products 
   :columns [:id :name :price] 
   :filters {:category "electronics" :in-stock true}
   :sort-by [:price :desc]
   :limit 20})
  • anti-idpol action@programming.devtoAsklemmy@lemmy.ml•What is a product you would never recommend?
    21·
    2 months ago

    also Huawei laptops. Jfc what a trashy counterfeit of a MacBook and if you get an AMD one, better also get a good cooling stand. The keyboard is terrible and costs a fuckton to replace and generally the repairability is like with macs, the USB ports are built in a way that just begs for either them or your peripherals to be broken, they might overheat while charging, they ship bloatware and the speakers are ridiculously quiet. My friend’s mom bought her one contrary to my advice to get a second-hand thinkpad or just any other business-line laptop and it she had to return the first shipment because the screen got bent during shipment.

    MIUI… don’t even get me fucking started on this garbage. It literally removes numerous features from vanilla android, presumably to relocate some performance budget to the bloat they add.

  • anti-idpol action@programming.devtoAsklemmy@lemmy.ml•What is something people you encounter at your job say that makes you want to scream? (Job, person & quote)
    5·
    2 months ago

    premature optimization is a root of all evil.

    also when those morons decide to do ‘microservices’ but end up creating glorified SOA with one messy DB where half the tables are not even used by anything, updates in place are the standard and there is nothing like one team per service, but instead everyone is expected to navigate millions of lines of spaghetti code with poor documentation, barely any reuse and inconsistencies all across the board with this oh too-fucking-common entity service anti-pattern.

    and so much fucking coupling that you better start deploying your dev cluster just right after waking up so it maybe is up and running by the time your daily is over.

    Fun fact, I used to work at a company where a lot of projects use Elixir and a bulk share of my coworkers have been outspoken critics of microservices precisely because OTP manages to power fault tolerant and scalable systems but not by insane levels of complexity like kubernetes does but by CoC that rarely gets in your way.

  • anti-idpol action@programming.devtoAsklemmy@lemmy.ml•What's an IT profession that is realistically possible to self-study for and become proficient enough in to get employed within a year?
    9·
    8 months ago

    Vue.js, it’s the simplest of the popular frontend frameworks

    You can learn a hellton about sysadmin and DevOps by running a home lab and aiding that with some courses and maybe one cert or two but I wouldn’t splurge on certs that readily.

    Golang, Express.js, Nest, Flask, SQL (a must), maybe Spark if you dare. Any popular and expressive framework/language for full stack/backend, except for Rails and PHP, those are dying technologies despite their still relatively high popularity in some countries.

    Maybe Flutter, Swift or React Native if you want to get into mobile dev.

    Just go to a job board, then to learnxinyminutes.com, pick something and start with building small, then medium sized, then maybe more complex projects or contributing to FLOSS written using your tech of interest (but please, PLEASE don’'t treat OSS contributions primarily as a way to get a job. Pick something you use instead. Try to figure out how you would implement something, do that and don’t let the impostor syndrome win if it uses a tech you’re familiar with whenever you want to open an issue on a git forge.

  • anti-idpol action@programming.devtoProgramming@programming.dev•Codeberg.org Opinions?
    6·
    8 months ago

    Had no trouble getting access to their CI, my request took less than a day for my one AGPL-licensed project. Also has a weblate instance. In the past the UI could have been a little laggy with large diffs but that improved somehow. Not too many 3rd party integrations supported though and not as feature-rich as Gitlab, but still very friendly UX that’d probably cover your GitOps needs in 90% of the cases.

    They also got really good ToS, see tosdr.