@coreysnipes at @lhc, our local hackerspace in Brazil, people are very interested in this topic and trying to create nodes all over the city, but I agree with you that I didn't see anyone with a better use case than sending "hello" messages to each other.

Side effect of being reading a SQL book: instead of using Django ORM to perform some queries and data cleanup in the DB of a project, I am running a bunch of SQL commands and I am considering them so much easier to understand (even with some weird aggregates)! #sql

@anna @steko @juliobiason NextCloud is in the top of my list of services that I want to self-host ...

@steko @juliobiason @anna I believe that there is not a service like that. I was looking at https://cal.com/ but didn't spent time with that yet

@juliobiason @anna @anna I am using https://migadu.com/ with my own domain paying a small amount yearly. Self-hosting email is something that I will never try to do myself ...

@Roneyb @skarnio @cadusilva @fediadminbr pior que ele assinou mesmo ....

https://mamot.fr/@pluralistic/113821581138163179

@Roneyb @skarnio @cadusilva @fediadminbr não vi nenhum comentário do Cory Doctorow no site dele, nem nas contas do Fediverso. E dado o histórico dele, é muito, muito estranho ele colocar o nome dele em algo desse tipo ...

Sometimes I forget how a simple index in a column may provide a significant impact in the performance of our system ...

https://github.com/lhc/thebook/commit/8830e9f0e15943dbad4bc85d6588f67cbf3b11a0#diff-641b4ae0a3769c5f1eee1f471ee7292ed173d2f600aa9e766b1d4630227cc6baR20

Now the transactions page loads faster 🙂

#django #index #sql #postgresql

Estava procurando alguma ferramenta para me ajudar a organizar meus livros digitais (apesar de eu não ter o hábito de ler livros assim) e descobri o Kavita. Parece ser bem interessante e ainda permite que outras pessoas tenham acesso (com autenticação) aos meus livros ...

https://wiki.kavitareader.com/

Considerando fazer uma instalação para testar 🙂 Alguém já utiliza/utilizou?

@anna provavelmente o @ericof tenha experiência com isso.

@bmispelon I did some research and you are right. Custom aggregates are the cleanest solution for this problem and it can be as simple as:

```class Median(Aggregate):
template = 'PERCENTILE_CONT(.5) WITHIN GROUP (ORDER BY %(field)s)'```

Unfortunately, it should't be possible to have built-in, as median isn't an ANSI SQL function, so a different implementation is needed for each DB (the one I tested in PostgreSQL).

The hack also is worried about annotations. Need to test a bit more.

@julia não seria BC inteira uma área imprópria?

First code contribution to @gancio (I hope it is is good enough to solve the problem and they accept my merge request 🙂)

https://framagit.org/les/gancio/-/merge_requests/72

For a Python developer, digging into Javascript world was a bit challenging, but it was good to learn new things.

Saving USD23/month destroying some ancient Digital Ocean droplets that I left unmaintained running services and project that I wasn't really using.

@adorilson eu quero uma AI que faça o que eu não sou capaz ;-)

Do you know when I will really believe that AI will take our jobs and we will have a revolution in tech world? In the moment when an AI will be capable of configuring and sending one single page PDF to a printer, any printer and we get that page printed in a paper sheet! Just a f***** printer! I dare you AI! You will never be able to accomplish that!

@oni you can clearly know who you are paying for a Peertube instance as well (if you chose it with care). The only difference is that the money for Vimeo is going to a NASDAQ traded company that needs to answer to stakeholders (not you) or to a community/person hosting an open source project, federated, that is more likely to listen to your needs.

It is more a philosophical choice than technical anyway ...

@hamatti it is like you insert a USB device in your computer, the first way is wrong, the second is also wrong, then the third is the right 🙂

@oni moving to another PeerTube instance that is open for new users isn't a viable choice? Using (and paying) Vimeo doesn't look better than using YouTube ...

E se em 2025 eu procurasse mais umas 2-3 pessoas para organizar um Django Day aqui na região (talvez em SP?)?

Sempre achei interessante como no Brasil não existe nenhum evento voltado para Django (como existe a DjangoCon nos EUA e na Europa) ...

#django #python #evento #comunidade