hachyderm.io is one of the many independent Mastodon servers you can use to participate in the fediverse.
Hachyderm is a safe space, LGBTQIA+ and BLM, primarily comprised of tech industry professionals world wide. Note that many non-user account types have restrictions - please see our About page.

Administered by:

Server stats:

9.7K
active users

#sql

60 posts44 participants2 posts today
QuanwenZhao<p>Acquired the new knowledge!!!<br>SQuizL 29-MAR-25<br>5/6 guesses<br>664 seconds<br>🟦🟩🟩⬜⬜⬜⬜<br>🟦🟩🟩🟩🟩⬜⬜<br>🟦🟩🟩🟩🟩⬜🟩<br>🟦🟩🟩🟩🟩⬜🟩<br>🟦🟩🟩🟩🟩🟩🟩<br><a href="https://bit.ly/SQuizL-game" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">bit.ly/SQuizL-game</span><span class="invisible"></span></a><br><a href="https://techhub.social/tags/SQuizL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQuizL</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
Jobs for Developers<p>MongoDB is hiring Data Architect</p><p>🔧 <a href="https://mastodon.world/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a> <a href="https://mastodon.world/tags/aws" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aws</span></a> <a href="https://mastodon.world/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> <a href="https://mastodon.world/tags/gcp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gcp</span></a> <a href="https://mastodon.world/tags/mongodb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mongodb</span></a> <a href="https://mastodon.world/tags/nosql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nosql</span></a> <a href="https://mastodon.world/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.world/tags/solutionsarchitect" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>solutionsarchitect</span></a><br>🌎 Austin, Texas<br>⏰ Full-time<br>🏢 MongoDB</p><p>Job details <a href="https://jobsfordevelopers.com/jobs/data-architect-at-mongodb-com-mar-5-2025-940a83?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jobsfordevelopers.com/jobs/dat</span><span class="invisible">a-architect-at-mongodb-com-mar-5-2025-940a83?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting</span></a><br><a href="https://mastodon.world/tags/jobalert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobalert</span></a> <a href="https://mastodon.world/tags/jobsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobsearch</span></a> <a href="https://mastodon.world/tags/hiring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hiring</span></a></p>
weirdjokes<p>Coding is now about problem solving, not about syntax.</p><p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
Jobs for Developers<p>Impact.com is hiring Software Engineer</p><p>🔧 <a href="https://mastodon.world/tags/java" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>java</span></a> <a href="https://mastodon.world/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>javascript</span></a> <a href="https://mastodon.world/tags/springframework" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>springframework</span></a> <a href="https://mastodon.world/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a><br>🌎 Columbus, Ohio<br>⏰ Full-time<br>🏢 Impact.com</p><p>Job details <a href="https://jobsfordevelopers.com/jobs/software-engineer-at-impact-com-jun-17-2024-c5be9f?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jobsfordevelopers.com/jobs/sof</span><span class="invisible">tware-engineer-at-impact-com-jun-17-2024-c5be9f?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting</span></a><br><a href="https://mastodon.world/tags/jobalert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobalert</span></a> <a href="https://mastodon.world/tags/jobsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobsearch</span></a> <a href="https://mastodon.world/tags/hiring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hiring</span></a></p>
Christopher Silsby (he/him)<p>Ran into a random <a href="https://hcommons.social/tags/WordPress" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WordPress</span></a> issue today. Ok, isn't really WordPress's fault, but a <a href="https://hcommons.social/tags/modsec" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>modsec</span></a> false positive. In trying to protect from <a href="https://hcommons.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> injections, our firewall sees WordPress posts as dangerous. So every once in a while, a professor assigns a post about or related to the topic of sleep. </p><p>This is a problem for modsec. It thinks anyone writing a parenthetical clause after talking about sleep (like this) is trying to hack our server. </p><p>But WordPress doesn't have a way to process the error code, and gives the students a wholly unhelpful error message. </p><p>Luckily, this has now happened about 3 or 4 times in the past 15 years. So I know to look out for it. And to recommend emdashes instead of parens. See, my dissertation writing IS useful in my EdTech job! <a href="https://hcommons.social/tags/EmdashPride" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EmdashPride</span></a> <a href="https://hcommons.social/tags/DigitalHumanities" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DigitalHumanities</span></a></p>
Habr<p>Уже через год мы будем общаться с базами данных по-русски</p><p>По прогнозу Gartner, запросы на естественном языке вытеснят SQL уже в 2026 году. Возможно, прогноз Gartner чересчур оптимистичный, но если они и ошибаются, то только в сроках — сам переход на естественный язык в работе с БД неизбежен.</p><p><a href="https://habr.com/ru/companies/postgrespro/articles/895436/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/postgres</span><span class="invisible">pro/articles/895436/</span></a></p><p><a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/%D0%B8%D1%81%D1%81%D0%BA%D1%83%D1%81%D1%82%D0%B2%D0%B5%D0%BD%D0%BD%D1%8B%D0%B9_%D0%B8%D0%BD%D1%82%D0%B5%D0%BB%D0%BB%D0%B5%D0%BA%D1%82" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>исскуственный_интеллект</span></a> <a href="https://zhub.link/tags/%D1%81%D1%83%D0%B1%D0%B4" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>субд</span></a> <a href="https://zhub.link/tags/%D0%B3%D0%B5%D0%BD%D0%B5%D1%80%D0%B0%D1%86%D0%B8%D1%8F_sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>генерация_sql</span></a></p>
Henry<p><span class="h-card" translate="no"><a href="https://c.im/@jake4480" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>jake4480</span></a></span> <span class="h-card" translate="no"><a href="https://fosstodon.org/@Htbaa" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>Htbaa</span></a></span> I seem to remember it was a lot like this.</p><p><a href="https://social.lol/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
Habr<p>Промежуточные витрины в SQL</p><p>Привет, Хабр! Сегодня я хочу поговорить о том, без чего не обходится практически ни один серьёзный проект с большими данными (да и с не слишком большими тоже) — о промежуточных витринах (или более привычно – staging, core, data mart).</p><p><a href="https://habr.com/ru/companies/otus/articles/894850/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">habr.com/ru/companies/otus/art</span><span class="invisible">icles/894850/</span></a></p><p><a href="https://zhub.link/tags/BI%D0%B0%D0%BD%D0%B0%D0%BB%D0%B8%D1%82%D0%B8%D0%BA%D0%B0" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BIаналитика</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/%D0%9F%D1%80%D0%BE%D0%BC%D0%B5%D0%B6%D1%83%D1%82%D0%BE%D1%87%D0%BD%D1%8B%D0%B5_%D0%B2%D0%B8%D1%82%D1%80%D0%B8%D0%BD%D1%8B" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Промежуточные_витрины</span></a> <a href="https://zhub.link/tags/%D0%B1%D0%BE%D0%BB%D1%8C%D1%88%D0%B8%D0%B5_%D0%B4%D0%B0%D0%BD%D0%BD%D1%8B%D0%B5" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>большие_данные</span></a> <a href="https://zhub.link/tags/staging" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>staging</span></a></p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
Jonathan Lamothe<p>I am in urgent job search mode, so I'm gonna throw this out here and see if anything comes of it.</p><p>I am a <a href="https://social.jlamothe.net/search?tag=Canadian" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Canadian</span></a>, fluent in both <a href="https://social.jlamothe.net/search?tag=English" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>English</span></a> and <a href="https://social.jlamothe.net/search?tag=French" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>French</span></a>. I have experience with several programming languages. My strongest proficiency is with <a href="https://social.jlamothe.net/search?tag=Haskell" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Haskell</span></a> and <a href="https://social.jlamothe.net/search?tag=C" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>C</span></a>. I also have a reasonable grasp of <a href="https://social.jlamothe.net/search?tag=HTML" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HTML</span></a>, <a href="https://social.jlamothe.net/search?tag=JavaScript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JavaScript</span></a>, <a href="https://social.jlamothe.net/search?tag=SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a>, <a href="https://social.jlamothe.net/search?tag=Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a>, <a href="https://social.jlamothe.net/search?tag=Lua" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Lua</span></a>, <a href="https://social.jlamothe.net/search?tag=Linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Linux</span></a> system administration, <a href="https://social.jlamothe.net/search?tag=bash" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>bash</span></a> scripting, <a href="https://social.jlamothe.net/search?tag=Perl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Perl</span></a>, <a href="https://social.jlamothe.net/search?tag=AWK" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AWK</span></a>, some <a href="https://social.jlamothe.net/search?tag=Lisp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Lisp</span></a> (common, scheme, and emacs), and probably several others I've forgotten to mention.</p><p>I am not necessarily looking for something in tech. I just need something stable. I have done everything from software development, to customer support, to factory work, though my current circumstances make in-person work more difficult than remote work. I have been regarded as a hard worker in every job I have ever held.</p><p><a href="https://social.jlamothe.net/search?tag=GetFediHired" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GetFediHired</span></a></p>
Habr<p>Экономия RAM с pandas.read_sql</p><p>Как экономить до 90% оперативной памяти при загрузке pandas DataFrame из базы данных? Сравним различные способы выгрузки данных и найдем метод для снижения потребления оперативной памяти.</p><p><a href="https://habr.com/ru/articles/895330/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/895330/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/%D0%BE%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_%D0%BF%D0%B0%D0%BC%D1%8F%D1%82%D0%B8" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>оптимизация_памяти</span></a> <a href="https://zhub.link/tags/pandas" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pandas</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a></p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
Habr<p>Удобное сканирование в структуры в связке Go/PgX. Решение проблемы сканирования в PgX. Golang</p><p>Go. PgxWrappy как решение всех проблем PgX. Если вы сталкивались с неудобным сканом в структуры посредством PgX на Go, то гляньте эту либу. Она решает все проблемы сканинга.</p><p><a href="https://habr.com/ru/articles/895298/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/895298/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/Golang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Golang</span></a> <a href="https://zhub.link/tags/go" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>go</span></a> <a href="https://zhub.link/tags/pgx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pgx</span></a> <a href="https://zhub.link/tags/%D0%B3%D0%BE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>го</span></a> <a href="https://zhub.link/tags/%D0%BE%D1%80%D0%BC_%D0%B2_%D0%B3%D0%BE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>орм_в_го</span></a> <a href="https://zhub.link/tags/golang_orm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>golang_orm</span></a> <a href="https://zhub.link/tags/orm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>orm</span></a> <a href="https://zhub.link/tags/driver" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>driver</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/sqlx" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sqlx</span></a></p>
weirdjokes<p>Don't push to production on Friday.<br><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
QuanwenZhao<p>Lucky!<br>SQuizL 28-MAR-25<br>1/6 guesses<br>63 seconds<br>🟩🟩🟩🟦🟩🟩🟩<br><a href="https://bit.ly/SQuizL-game" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">bit.ly/SQuizL-game</span><span class="invisible"></span></a><br><a href="https://techhub.social/tags/SQuizL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQuizL</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
Jobs for Developers<p>Mindera is hiring Dot Net Fullstack Developer (Senior/Tech Lead)</p><p>🔧 <a href="https://mastodon.world/tags/csharp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>csharp</span></a> <a href="https://mastodon.world/tags/javascript" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>javascript</span></a> <a href="https://mastodon.world/tags/dotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dotnet</span></a> <a href="https://mastodon.world/tags/aspdotnet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aspdotnet</span></a> <a href="https://mastodon.world/tags/react" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>react</span></a> <a href="https://mastodon.world/tags/api" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>api</span></a> <a href="https://mastodon.world/tags/aws" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>aws</span></a> <a href="https://mastodon.world/tags/azure" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>azure</span></a> <a href="https://mastodon.world/tags/gcp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>gcp</span></a> <a href="https://mastodon.world/tags/mvc" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mvc</span></a> <a href="https://mastodon.world/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.world/tags/seniorengineer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>seniorengineer</span></a> <a href="https://mastodon.world/tags/techlead" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>techlead</span></a><br>🌎 Bengaluru, India<br>⏰ Full-time<br>🏢 Mindera</p><p>Job details <a href="https://jobsfordevelopers.com/jobs/dot-net-fullstack-developer-senior-tech-lead-at-mindera-com-mar-26-2024-94ca8b?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jobsfordevelopers.com/jobs/dot</span><span class="invisible">-net-fullstack-developer-senior-tech-lead-at-mindera-com-mar-26-2024-94ca8b?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting</span></a><br><a href="https://mastodon.world/tags/jobalert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobalert</span></a> <a href="https://mastodon.world/tags/jobsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobsearch</span></a> <a href="https://mastodon.world/tags/hiring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hiring</span></a></p>
Andrii Kuznietsov<p><a href="https://social.kyiv.dcomm.net.ua/tags/WrenAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WrenAI</span></a> - це open-source <a href="https://social.kyiv.dcomm.net.ua/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a>-асистент для аналізу даних і генерації <a href="https://social.kyiv.dcomm.net.ua/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a>-запитів (Text-to-SQL)</p><p>Він дає змогу користувачам взаємодіяти з даними за допомогою природної мови й автоматично формувати SQL-запити, будувати діаграми, звіти та таблиці.</p><p>🔗 <a href="https://github.com/Canner/WrenAI?tab=readme-ov-file" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/Canner/WrenAI?tab=r</span><span class="invisible">eadme-ov-file</span></a></p>
Habr<p>Аномалии конкурентного доступа</p><p>В распределённых базах данных YDB, CockroachDB по умолчанию используется уровень изоляции SERIALIZABLE. В PostgreSQL, Oracle Database, MySQL по умолчанию используется READ COMMITED. В стандарте SQL указаны только три аномалии. В статье приводится пример аномалии потерянного обновления в задаче "списания средств" и рассматривается, почему уровень READ COMMITED и ограничения целостности достаточны для решения задачи. Если с данными (строками таблиц) работает одна сессия в базе данных, то разницы между уровнями изоляции транзакций нет, так как нет транзакций, от которых нужно изолироваться. Если есть несколько транзакций, которые пересекаются во времени, то нужно обращать внимание на то, что параллельно с теми же данными работают другие транзакции. Другими словами, учитывать особенности (феномены, аномалии) "конкурентного доступа".</p><p><a href="https://habr.com/ru/articles/894984/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">habr.com/ru/articles/894984/</span><span class="invisible"></span></a></p><p><a href="https://zhub.link/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> <a href="https://zhub.link/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://zhub.link/tags/lost_update" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>lost_update</span></a> <a href="https://zhub.link/tags/%D0%B8%D0%B7%D0%BE%D0%BB%D1%8F%D1%86%D0%B8%D1%8F_%D1%82%D1%80%D0%B0%D0%BD%D0%B7%D0%B0%D0%BA%D1%86%D0%B8%D0%B9" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>изоляция_транзакций</span></a> <a href="https://zhub.link/tags/constraint" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>constraint</span></a></p>