Masthash

#sql

Inautilo
8 hours ago
Gruener_Antifa
11 hours ago

#MySQL #Datenbank #SQL
soweit wie ich es verstehe liegt es daran das ich "virtual"e einträge habe.... bringt bloß nicht weil ich keine ahnung habe wie das weg geht

Ich hab die Laufzeit einer #SQL Query von 16s auf 0.2s gedrückt. Das fühlt sich besser an als es das Hanföl von Seitenbacher jemals könnte 🙃

RPGPGM
19 hours ago

Erweiterung der #SQL-Ansicht SYSCOLUMNSTAT für VARCHAR-Spalten.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/03/more-useful-information-added-to.html

makemoremusic
1 day ago

mysql > postgres

There, I said it. Come at me, bro.

#programming #data #sql #vs #fight

J.P. Wing
1 day ago

I'm still looking for two full-stack #PHP #Javascript #HTML #SQL developers for my development team with a major telecommunications company. The position is 100% remote and the team mate would work on internal web applications. The team is spread across the country. #Azure #DevOps, #git, #Linux experience a plus. Reach out to me for more information if interested, boosts appreciated. Salary is decent.

Taras Novak 🇺🇦
2 days ago

Loading & running 20+ #Sql queries in our new #DataNotebookPro 📓 extension for #VSCode IDE ...

#SqlTools 📜 #DataNotebooks 📚 #ProDataTools 🔬 ...

Taras Novak 🇺🇦
2 days ago

Quick example of running #SQL query in our new #DataNotebook 📓 code extension we plan to release to our Pro sponsors on github soon ...

Query results are displayed using our public #DataTableRenderers 🈸 extension for VSCode IDE:

📥 https://marketplace.visualstudio.com/items?itemName=RandomFractalsInc.vscode-data-table

#DataNotebooks 📚 ... #DataTools 🔬 ...

Jobs for Developers
2 days ago
Milan
2 days ago

I can play around with #SQL again, thanks to the GSC bulk data export to BigQuery :-) So awesome, dream come true! #SEO #Google

Jobs for Developers
2 days ago

Servian is hiring Senior/Lead Data Engineer

🔧 #python #sql #seniorengineer #techlead
🌎 Bengaluru, India
⏰ Full-time
💰 $90k - $225k (Estimate)
🏢 Servian

Job details https://jobsfordevelopers.com/jobs/senior-lead-data-engineer-at-servian-com-jan-20-2021-dcb1d9?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
2 days ago

Space and Time is hiring Principal Software Engineer - Apache Arrow

🔧 #dao #dapp #rust #blockchain #defi #nft #web3 #sql #principalengineer
🌎 Remote; United States
⏰ Full-time
💰 $110k - $200k (Estimate)
🏢 Space and Time

Job details https://jobsfordevelopers.com/jobs/principal-software-engineer-apache-arrow-at-space-and-time-jun-21-2022-6aaa0a?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
2 days ago

Diligent is hiring Software Engineer (Python)

🔧 #python #c #django #api #rest #aws #cicd #sql #tdd
🌎 Budapest, Hungary
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 Diligent

Job details https://jobsfordevelopers.com/jobs/software-engineer-python-at-diligent-oct-13-2022-22f908?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
2 days ago
IT News
2 days ago

YugabyteDB Managed adds managed command line interface - Yugabyte on Monday said that it was adding a new managed command line interface along ... - https://www.infoworld.com/article/3691653/yugabytedb-managed-adds-managed-command-line-interface.html#tk.rss_all #relationaldatabases #softwaredevelopment #cloudcomputing #database #sql

MariaDB Foundation
2 days ago
RDN
3 days ago

The #SQL script processor execsql.py (https://pypi.org/project/execsql/) now has a BREAK metacommand to immediately exit a loop, sub-script, or included script file. Full documentation is at https://execsql.osdn.io/.

#Database #Python #FOSS

Michael Eaton
3 days ago

Here is my 13th Interesting Links post for 2023. I found lots of outstanding leadership and software development posts last week.

https://samestuffdifferentday.net/2023/03/27/Interesting-links-of-the-week-2023-13/

#leadership #agile #csharp #dotnet #azure #sql #github

Jobs for Developers
3 days ago

Space and Time is hiring Software Engineer - Core Database

🔧 #dao #dapp #cplusplus #rust #blockchain #defi #nft #web3 #sql
🌎 Remote; India
⏰ Full-time
💰 $110k - $200k (Estimate)
🏢 Space and Time

Job details https://jobsfordevelopers.com/jobs/software-engineer-core-database-at-spaceandtime-io-apr-21-2022-d92456?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
3 days ago

DoorDash is hiring System Engineer Lead

🔧 #csharp #python #dotnet #dotnetcore #html #kafka #mysql #sql #techlead
🌎 Atlanta, United States; Austin, United States; New York City, United States; Phoenix, United States; San Francisco, United States
⏰ Full-time
💰 $90k - $210k (Estimate)
🏢 DoorDash

Job details https://jobsfordevelopers.com/jobs/system-engineer-lead-at-doordash-nov-22-2022-1bc54c?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Adam Jurkiewicz
3 days ago

Czytając poranne inspiracje trafiłem na ciekawy projekt i jednocześnie kurs SQL https://duckdb.org/docs/sql/introduction
#sql #rdbms #python #kurs #introductionen

Jobs for Developers
3 days ago

DoorDash is hiring Data Engineer

🔧 #python #aws #druid #gcp #postgresql #sql
🌎 Atlanta, United States; Austin, United States; Chicago, United States; Los Angeles, United States; New York City, United States; Pittsburgh, United States; San Francisco, United States; Seattle, United States; Washington D.C., United States
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 DoorDash

Job details https://jobsfordevelopers.com/jobs/data-engineer-at-doordash-nov-22-2022-18f6c2?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
4 days ago

DoorDash is hiring BI Engineer

🔧 #java #python #postgresql #sql
🌎 New York City, United States; San Francisco, United States; Seattle, United States
⏰ Full-time
💰 $90k - $225k (Estimate)
🏢 DoorDash

Job details https://jobsfordevelopers.com/jobs/bi-engineer-at-doordash-nov-22-2022-f5dc66?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
4 days ago

Space and Time is hiring Streaming Engineer

🔧 #dao #dapp #api #blockchain #defi #nft #web3 #kafka #sql
🌎 Remote; United States
⏰ Full-time
💰 $110k - $200k (Estimate)
🏢 Space and Time

Job details https://jobsfordevelopers.com/jobs/streaming-engineer-at-space-and-time-apr-21-2022-0c968b?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
4 days ago

DoorDash is hiring Software Engineer Intern (Summer 2023)

🔧 #java #kotlin #python #aws #sql
🌎 Los Angeles, United States; New York City, United States; San Francisco, United States; Seattle, United States
⏰ Internship
💰 $90k - $230k (Estimate)
🏢 DoorDash

Job details https://jobsfordevelopers.com/jobs/software-engineer-intern-summer-2023-at-doordash-nov-22-2022-2bfde9?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Goldfishbrain
4 days ago

Maybe a stupid question, but as basically this is like the void with no echo, I'll try it anyways.

I learn SQL on Google Big Query Sandbox. I use the public datasets.
Unfortunatly, I don't really know, how to describe my issue.

So the questions are:

How can I do the SQL queries without the sandbox? What program do I need?
Is there a program for Ubutu where I can download this or any other dataset to work "offline"?

#sql #bigdata #bigQuery

Jobs for Developers
5 days ago

Servian is hiring Senior Data Engineer

🔧 #aws #azure #gcp #sql #seniorengineer
🌎 Sydney, Australia
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 Servian

Job details https://jobsfordevelopers.com/jobs/senior-data-engineer-at-servian-com-aug-19-2021-6ea2da?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

kalvn
5 days ago

GitHub - drizzle-team/drizzle-orm: TypeScript ORM for SQL
https://github.com/drizzle-team/drizzle-orm

Un query builder pour Node.js. L'outil se définit comme un ORM mais de ce que j'ai pu lire, ça ressemble beaucoup plus à un query builder. Une alternative à Knex.js en somme.

#orm #sql #javascript #nodejs #libhttps://links.kalvn.net/shaare/6yQghA

Jobs for Developers
5 days ago

Patreon is hiring Staff Data Scientist - Growth

🔧 #python #sql
🌎 New York
⏰ Full-time
💰 $189k - $245k
🏢 Patreon

Job details https://jobsfordevelopers.com/jobs/staff-data-scientist-growth-at-patreon-feb-3-2023-cedc44?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Jobs for Developers
5 days ago

Space and Time is hiring Software Engineer - Database Internals

🔧 #dao #dapp #scala #blockchain #defi #nft #web3 #sql
🌎 Remote; India
⏰ Full-time
💰 $110k - $200k (Estimate)
🏢 Space and Time

Job details https://jobsfordevelopers.com/jobs/software-engineer-database-internals-at-spaceandtime-io-apr-21-2022-1bb18a?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Henrik Loeser
6 days ago

Here is link to a #blog post which points to another blog post with a link to #Python and #SQL code 😀 . https://blog.4loeser.net/2023/03/analyze-your-ibm-cloud-access.html

Sarah Roth
6 days ago

@srekel Took me a while to notice that you only mean as storage. I'm actually interested even more as using #sql as part of the game logic or if only #cellularautomata are the ideal #gamedev solution for many interactive systems.
https://is.muni.cz/th/w12aw/SimulatingWorldsCA.pdf

Reuben Walker
6 days ago
Illustration of a woman looking a physical database
Jobs for Developers
6 days ago
Mike (Multiverse of Badness)
6 days ago

What I learned looking work in #IT after #RemoteWork became more normal:

2 #jobs I interviewed for demanded #OnSite work. #Salary was a bit better.

One manager was an outdated #SQL #Developer hell-bent on "gotcha" interview questions. Explained to him how I did something in production and he said it was "impossible"..ok..

Other was the third employer at a company of 500. Non-IT guy hell-bent on using trendy tech he didn't understand.

Now I work #remote for a #job w/a VP that knows his shit..

Hold on now! I think I'm seeing a pattern here.
Jobs for Developers
6 days ago
Jobs for Developers
6 days ago
Jobs for Developers
6 days ago

Space and Time is hiring Software Engineer - Query Engine

🔧 #dao #dapp #cplusplus #rust #blockchain #defi #nft #web3 #sql
🌎 Remote; India
⏰ Full-time
💰 $110k - $200k (Estimate)
🏢 Space and Time

Job details https://jobsfordevelopers.com/jobs/software-engineer-query-engine-at-space-and-time-apr-21-2022-0364ae?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Marc Robinson-Rechavi
1 week ago

New preprint, where we discuss various approaches to knowledgebase interoperability based on our experience at @bgeedb:
Boosting interoperability: towards an increasingly reusable bioinformatics knowledge base
https://arxiv.org/abs/2303.12329
#bioinformatics #knowledgebase #interoperability #ontology #SQL #SPARQL #SIB @monarch_initiative @wikidata

A simplified illustration of the Bgee interoperability network. In an inner circle are examples of the ensemble
of techniques used to implement the Bgee interoperability with diverse databases
and systems; ontop, RDF, CSV, Sparql, etc. In an outer circle are logos of knowledgebases with which Bgee interoperates: GeneCards, OSP, Spoke, Monarch Initiative, OncoMX, OMA, Google Dataset, RIKEN, NCBI Gene, Wikipedia, Wikidata, and UniProt.

@rafaelcaricio Okay, Software Names really went out of control...

#Backie makes sense for a #backend service and #PostgreSQL is just the #Postgres #SQL database but WTH is #Tokio and #Diesel?

Inautilo
1 week ago

#Development #Launches
MySQL for Developers · A video course to learn everything you need to know about MySQL https://ilo.im/11tvb8

_____
#WebDevelopment #WebDev #Backend #Database #SQL #MySQL #Free

Olivier Leroy
1 week ago

Today I read an other post on what tools a student in GIS should learn. Obv it was an other QGIS vs ESRI.

Am I wrong to think now student should learn either #Rstats, #Python or #Sql instead ? Is it too much to ask? #Gischat

FOSS Android :verified_twtr:
2 weeks ago

Squircle CE - Code Editor
A fast multi-language code editor and file manager for Android

Squircle CE currently supports coding in the following programming languages: ActionScript, C, C++, C#, Groovy, HTML, Java, JavaScript, Json, Julia, Kotlin, Lisp, Lua, Markdown, PHP, Python, Ruby, Shell, Smali, SQL, Toml, TypeScript, Visual Basic, XML and YAML.

Download: https://github.com/massivemadness/Squircle-CE/releases

#foss #android #OpenSource #python #CodeEditors #C #Java #HTML #kotlin #javascipt #PHP #SQL #json

Assaf
2 weeks ago

Outerbase https://outerbase.com/

Web-based and macOS app for running and sharing database queries, generating dashboards (ie charts), and — of course — an AI-assisted #SQL query engine.

There are some other features, and it feels like this could replace the aging #RDBMS GUIs (TablePlus, et al), but I think the target audience here is more PMs sharing business-level queries and charts.

Cédric Belin
2 weeks ago

After several years of using several database tools (DataGrid, SQL Server Management Studio, etc.), I still think that #HeidiSQL is the best one, even though it is free! Very simple and very effective.

https://www.heidisql.com
#SQL #Tools

Claudia Regio
2 weeks ago

Did you miss our #vscode Polyglot Notebooks livestream this morning with @cecilphillip ?? Not a problem - catch up on the recording here to learn how notebooks are a great tool for exploring SDKs!

https://www.youtube.com/watch?v=cY9wHDhJA6Y

#jupyter #csharp #fsharp #powershell #javascript #html #sql #kql #mermaid #stripe #dotnet

What entry-level courses/tutorials/guides do people recommend for learning SQL basics for web apps: schema design, foreign keys, relationships, but also: how to express these this in ORMs and DB migration tooling. Postgres flavour preferred, but any will do. #sql #databases #BoostsOk

I'm SO looking forward to today. After I identified several weaknesses in our #sql server setup (we have several servers I "inherited" and administer), as well as weaknesses in my own knowledge about how to *best* eliminate the them, my boss hired an external consultant to upgrade ME.
So today is MY day, where I get to play with things I love, learning to play with them the RIGHT way - instead of just winging it like so many of us usually have to 😛
So today, MY DAY 🥳
#cybersecurity #infosec

Claudia Regio
2 weeks ago

Want to use multiple languages in a notebook while getting rich IntelliSense? Check out the
#vscode Polyglot Notebooks extension, now in GA!🎉

#polyglotnotebooks has language server support and variable sharing for C#, JavaScript, SQL, & more!
👉 https://aka.ms/PolyglotNotebooksGA

#csharp #fsharp #javascript #powershell #javascript #html #sql #mermaid #kql

Alexander Reelsen
2 weeks ago

9 years of open source database development: reviewing rqlite design choices: Nice blogpost about the evolution of rqlite and a regular reminder that databases take their time to get right. Bonus points for finding a bug in sqlite https://www.philipotoole.com/9-years-of-open-source-database-development-the-design-docs/ #databases #sql

rmoff 🏃🏻 🍺 🥓
2 weeks ago

One of my favourite things about my job is that 25+ years after learning SQL I get to still learn new tricks and syntax. Discovered this one in #duckdb (and #postgres too apparently) today :)

#TIL #SQL #Datadon

Why didn't any of you tell me how fun #SQL is!?

Alexander Reelsen
2 weeks ago

Improving JSON parsing in a database. What sounds like a minor issue for a database like CockroachDB can easily turn into a CPU/memory allocation bottleneck, as modern databases have a lot of format parsing functions. If a system splits storage and compute the impact is 'just' slower or more expensive indexing, otherwise you will have competing resources with running queries.. https://www.cockroachlabs.com/blog/high-performance-json-parsing/ #database #sql

Jobs for Developers
3 weeks ago

DoorDash is hiring Data Science Manager - Machine Learning (Pricing and Growth)

🔧 #sql #machinelearning
🌎 Remote; New York City, United States; San Francisco, United States; Seattle, United States; United States
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 DoorDash

Job details https://jobsfordevelopers.com/jobs/data-science-manager-machine-learning-pricing-and-growth-at-doordash-nov-22-2022-e507b1?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Goldfishbrain
3 weeks ago

Back to my course...
Actually, I'm a bit tired, but everything's gonna be alright. Maybe this gets me out of the dirt and cold into an office at best into a home-office. 🤞

Anyway, calculations in SQL is bit fun, I start to really like SQL, but I assume, if it gets more real, it gets harder and then... We'll see. But until then I enjoy it. 😬 ✌️

Have a great day.

#dataNerd #SQL #DataAnalysis

Continuing the theme of fixing fatfingered mistakes on my mastodon instance…

Today we're fixing up missing avatars

SELECT
'-O', 'cache/accounts/avatars/' || REGEXP_REPLACE(LPAD(id::varchar, 18, '0'), '(...)(...)(...)(...)(...)(...)', '\1/\2/\3/\4/\5/\6') || '/original/' || LOWER(REGEXP_REPLACE(avatar_remote_url, '.*[/]([^.]*)[.]([a-z]*)(?:[?].*)?$', '\1.\2')),
avatar_remote_url
FROM accounts
WHERE
domain not in (
SELECT domain
FROM domain_blocks
UNION
SELECT domain
FROM unavailable_domains
)
AND avatar_remote_url <> ''
AND avatar_file_name IS null
AND LOWER(REGEXP_REPLACE(avatar_remote_url, '.*[/]([^.]*)[.]([a-z]*)(?:[?].*)?$', '\2'))in ('gif', 'jpeg', 'jpg', 'png', 'webp')
ORDER BY domain

and on the bash side

pv /tmp/missing-avatars.txt | grep -v -e mastodon.nu -e \' | sed 's/ /%20/' | xargs -n 4 -P 1 wget2 --tries=1 --timeout=1 --no-ocsp --no-hsts --no-hpkp --no-clobber --filter-mime-type='image/gif,image/jpeg,image/png,image/webp'

And there's going to be a nice little sql UPDATE in a minute there too, to populate avatar_file_name (as you'll notice it's empty, and that's how i can determine which avatars are missing.

#mastoadmin #SQL #bash

Henry
3 weeks ago

@cory Thanks for the find of 'Birds in Row' from your https://coryd.dev/now page. I've been fighting some #SQL for the last hour in a personal project; and if there's something that will reduce me to the emotional, confused and angry state of my teenage years it's SQL, and so they've been a very cathartic listen.

Shawn Hooper (he/him)
3 weeks ago

I have a query for you SQL devs out there.

I’m delivering a “Introduction to SQL” workshop for a group of developers soon.

What’s one thing you wish you’d learned about early in your SQL journey?

#SQL

AdiPolak
3 weeks ago

Data folks, which query language is your goto?

#data #sql #python #chatgpt

Ronalds Vilciņš
3 weeks ago

lol, all links on twitter right now 😁 did Elon forgot to pay for something again?

#webdev #programming #frontend #backend #css #html #javascript #code #ui #ux #apple #ios #macos #php #python #java #sql #database #coder #vim

Sharon Machlis
3 weeks ago

Learn a data skill and support Ukraine. These 2-hour workshops on topics like R, Python, Bayesian modeling and Quarto are just $20 or €20 each. Or, you can volunteer to teach.
https://www.infoworld.com/article/3689971/data-workshops-for-ukraine-learn-a-skill-and-support-a-cause.html

#rstats #python #SQL #stats #ggplot2 #QuartoPub #InfoWorld
@rstats

Aalaap Ghag 🟡
4 weeks ago

Should I write a #SQL #subquery?

Jon Udell
4 weeks ago

@wendynather Kind of like guns in the US, there's a massive installed base of spreadsheets to reckon with, and they are not going away.

Can/should we use tools to check their integrity? Here's one experiment that points in that direction. I would have thought there are a lot of validators, but when researching that article I didn't find many.

https://steampipe.io/blog/sql-for-googlesheets#enforce-named-ranges

#steampipe #spreadsheet #sql

nosh :fosstodon:
4 weeks ago

@sirber Sounds good.

I normally run an instance of postgresql via docker on the local machine.

Usually only the docker file needs to be pushed with source code.

Wonder how many people do it this way.

#sql
#docker

0xC0DEC0DE07E7
4 weeks ago

Seriously, I'm sitting here trying to learn #preact because learning async #rustlang and #sql weren't enough.

Everything Open Conference
1 month ago

Next up for our #EverythingOpen Speaker Spotlight we have @danshearer@twitter.com, creator of #LumoSQL.

He will talk about "Enforcing #Privacy Rights Against Big Tech and Big #Surveillance" and cover joint work in #cryptography in #SQL with @survstudies colleagues at VU Brussels.

https://2023.everythingopen.au/schedule/presentation/15/

Michal Bryxí
1 month ago

And probably last blog post of the day on "How to select duplicate records".

https://dev.to/michalbryxi/selecting-duplicate-records-4me9

#RubyOnRails #SQL #Blog

Jeff Morris ZA
1 month ago

Hi all, maybe someone can point me in the right direction. Looking for a user friendly #standalone #opensource #sql service to develop a small #relationaldb on #windows. #MicrosoftAccess would do but not free. Using #libreOffice at the moment but not ideal. Help please.