#SQL

Vulnerable systems
Attacked by malicious SQL
Devastating harm

#sql #moveit #cyberattack #haiku #poetry

https://arstechnica.com/information-technology/2023/06/mass-exploitation-of-critical-moveit-flaw-is-ransacking-orgs-big-and-small/

Solana is hiring Senior Full Stack Engineer - Defi

🔧 #rust #typescript #react #node #redux #api #graphql #grpc #rest #blockchain #cypress #defi #web3 #aws #css #docker #gcp #html #postgresql #sql #seniorengineer
🌎 San Francisco, NYC, Chicago or Remote within N. America
⏰ Full-time
💰 $100k - $215k (Estimate)
🏢 Solana

Job details https://jobsfordevelopers.com/jobs/senior-full-stack-engineer-defi-at-solana-apr-14-2023-060c29?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

I spent the last two days writing #SQL queries like a madman. I need a holiday.

#CS50 #ComputerScience

Thinking about my future... I have skills in IT, art and now possibly in geo/paleo. I would want to mix them together and have a well paying stable job sometime in 1-3 years from now on. Any ideas? Any sphere needs such soup of skills?
.
Mid (5yrs exp) #programmer #csharp #typescript #powershell #sql
.
#UI design (~2yrs exp) and #2D #art - #illustration (~10 yrs exp hobbyist)
.
Ongoing Master's degree in general #geology with concentration towards #paleontology and a plan on PhD

I have been a #developer for just a little more than 2 years now, and today marks the first time I ever opened #SQL developer, and interacted with a real #database.
Not saying that I never worked with databases ever, but since I do mostly work with low-code platforms, everything is usually handled in the back-end.

Super cool to learn new things!

DoorDash is hiring Software Engineer - Product

🔧 #java #kotlin #rest #elasticsearch #nosql #postgresql #redis #sql
🌎 Chicago, United States; Los Angeles, United States; Mountain View, United States; New York City, United States; Pittsburgh, United States; San Francisco, United States; Seattle, United States
⏰ Full-time
💰 $100k - $240k (Estimate)
🏢 DoorDash

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

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

Mystery solved! The most fun problem so far on CS50x. Time for week 8.

#programming #SQL #cs50 #cs50x #computerscience #softwaredevelopment

An amazing Postgres playground to validate ones sql-fu

https://www.crunchydata.com/developers/playground

#postgres #playground #sql #TIL

How do you track down and explore data changes in your dbt project?

One way is to explore rows that fall outside previous boundaries

Check out this upcoming PipeRider feature that highlights a change, and shows the SQL you need to find the affected rows

#dbt #DataQuality #eda #DatatViz #sql #DataOps #DataReliability #DataEngineering #AnalyticsEngineering

Y'know, #SQL can already do result shaping quite well. #Postgres has the cool json_agg, which lets you construct proper objects from your queries.
It's just awkward to do with SQL. It wasn't really built for that.

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

Binance is hiring Senior Rust Developer (C/C++ to Rust)

🔧 #c #cplusplus #rust #sql #blockchain #mongodb #mysql #postgresql #seniorengineer
🌎 Remote; Asia
⏰ Full-time
💰 $110k - $220k (Estimate)
🏢 Binance

Job details https://jobsfordevelopers.com/jobs/senior-rust-developer-c-c-to-rust-at-binance-jul-9-2018-641f7a?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Any recommendations on #SQL #software ? I’m learning SQL now using an online class. I mainly use a machine running #LinuxMint . Can #LibreOffice Base be used? #MySQL ? My main application would be sports analytics, using publicly-available datasets. I’m decent with #Python but still very much a self-taught programmer.

Vertical Knowledge is hiring Senior Software Engineer

🔧 #c #javascript #python #react #serverless #aws #cicd #css #elasticsearch #gcp #nosql #sql #terraform #seniorengineer
🌎 Remote; Chagrin Falls, United States
⏰ Full-time
💰 $100k - $230k (Estimate)
🏢 Vertical Knowledge

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-at-vk-ai-mar-28-2023-efb093?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Patreon is hiring Fullstack Engineer - Growth

🔧 #javascript #python #typescript #sql
🌎 San Francisco, United States
⏰ Full-time
💰 $139k - $193k
🏢 Patreon

Job details https://jobsfordevelopers.com/jobs/fullstack-engineer-growth-at-patreon-apr-27-2023-bfa266?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

#sql experts, IT is telling me that a huge report run on the production db, not a data warehouse, can't possibly impact performance for other users accessing the prod db. I wanted to call hogwash on that, but I didn't. Who's correct?

PostgreSQL and SQL:2023

Link: http://peter.eisentraut.org/blog/2023/04/18/postgresql-and-sql-2023
Discussion: https://news.ycombinator.com/item?id=36162269

#postgresql #sql

Using #SQL table function to view the data in an User Space, no need for an API.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2021/06/getting-data-from-user-spaces-made-easy.html

Here is my
#introduction for the pin.
Hi, I discovered this place by accident.? :o.
Anyways, now that I am here after quitting centralized social media (I've hated it ever since I was a child), I might as well get to know other people like me who found this place by accident. (maybe there are no accidents.)
I am intrested in #tech, #sql, #data , #content #creation , #mushrooms #jobs #networking #math #mandelbrot and some more stuff... Looking forward to attract like minded people.

Next is my business logic, perhaps some kind of REST handler, which only relies on DBInterfaceExample:

module BusinessLogicExample

export on_request

using DBInterfaceExample

function on_request(input::String)
println("Handling request with input $input")
println("Preparing...")
results = DBInterfaceExample.query("SELECT * FROM $input") #SQL Injection attack here, don't do this in real code
println("Results: $(results.results)")
println("Request complete")
end

end

Finstek is hiring Senior .Net Developer

🔧 #dotnet #csharp #typescript #react #android #ios #redux #azure #sql #seniorengineer
🌎 Remote
⏰ Full-time
💰 $90k - $210k (Estimate)
🏢 Finstek

Job details https://jobsfordevelopers.com/jobs/senior-net-developer-at-finstek-com-mar-14-2023-3e60d4?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

SQL:2023 is finished: Here is what’s new | Peter Eisentraut

#SQL http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new

SQL: 2023 Has Been Released

Link: https://www.iso.org/standard/76584.html
Discussion: https://news.ycombinator.com/item?id=36154102

#sql

Learn how to write intuitive and type-safe Java Stream queries using JPAStreamer and Hibernate in Quarkus. #shorts

By Julia Gustafsson

Get Started:
https://code.quarkus.io/?extension-search=origin:other%20jpastreamer

JPAStreamer documentation:
https://speedment.github.io/jpa-streamer/

#jpastreamer #quarkus #quarkus3 #hibernate #jpa #java #javastreams #sql #sh

@nixCraft #awk #bash #SQL #m4

#TIL #sql #ThingsTheyDontTellYou

Anti joins exist as a term.

As usually there's a left anti-join, right anti-join, and a full anti-join.

Backbase is hiring Senior Performance Engineer

🔧 #java #springframework #aws #cicd #docker #mysql #sql #seniorengineer
🌎 Amsterdam, Netherlands
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 Backbase

Job details https://jobsfordevelopers.com/jobs/senior-performance-engineer-at-backbase-feb-15-2023-998ac9?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Just spent over an hour pulling my hair out trying to get a test to pass because #sqlite doesn't interpret "&&" as "AND". It also doesn't give me an error. In most #SQL && can be used instead of AND. So yeah, awesome way to spend the morning.

Make Use Of: Working With SQL Databases in Rust https://www.makeuseof.com/working-with-sql-databases-in-rust/ #Tech #MakeUseOf #TechNews #IT via @morganeogerbc #CodingTutorials #Programming #Database #SQL

Didn't know, but seems I like #sql

I can tolerate a lot of things, but spaces in #SQL column names must be stopped.

Servian is hiring Senior/Lead Data Engineer

🔧 #python #sql #seniorengineer #techlead
🌎 Bengaluru, India
⏰ Full-time
💰 $95k - $235k (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

Julian Arenas-Guerrero from OEG (UPM) is presenting #SQL views over #CSV files with #RML in Morph-KGC.

#ESWC2023 #RDF #KnowledgeGraph #SemanticWeb @eswc_conf

@SpaceLifeForm What often happens is that projects are started with a boss and a few developers. Neither side really knows what a DBA does, so they don't have one. So when their database struggles, they think "#SQL sucks."

Had one company considering consider NoSQL due to a 15 minute query. A couple of minutes later, my index reduced it to a couple of seconds.

I give a talk, "How to fake a database design" to help some of that, but it can't fix the underlying issue.

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

Still love the struggling client who explained they picked their #NoSQL database because they misread the documentation.

Our company still goes into clients who are considering #NoSQL and it turns out it's because they don't know how to use a #database. Denormalized, no foreign keys, 20 indexes on a table that needs one, and so on. So they decide to trade a known set of problems for an unknown set of problems. It often ends poorly.

PS: we can fix this for you.

#sql

📨 Latest issue of my curated #cybersecurity and #infosec list of resources for week #21/2023 is out! It includes, but not only:

‣ 🇬🇧 🇺🇸 #NHS data breach: trusts shared patient details with #Facebook without consent
‣ ☁️ Severe Flaw in #Google Cloud's Cloud #SQL Service Exposed Confidential Data
‣ 🇨🇭 💰 US govt contractor #ABB confirms #ransomware attack, data theft
‣ 🦠 🤖 #Predator: Looking under the hood of Intellexa’s #Android spyware
‣ 🇦🇿 🇦🇲 Hacking in a war zone: #Pegasus #spyware in the Azerbaijan-Armenia conflict
‣ 🦠 🎮 Dark Frost #Botnet Launches Devastating #DDoS Attacks on Gaming Industry
‣ 🇷🇺 🦠 Mysterious #malware designed to cripple industrial systems linked to #Russia
‣ 🇧🇷 🇵🇹 ‘Operation Magalenha’ targets credentials of 30 Portuguese #banks
‣ 🩹 #GitLab 'strongly recommends' patching max severity flaw ASAP
‣ 🇮🇷 🇮🇱 Iranian hackers use new #Moneybird ransomware to attack Israeli orgs
‣ 🇺🇦 Cyber Attacks Strike #Ukraine's State Bodies in Espionage Operation
‣ 🇨🇳 🇺🇸 Chinese state hackers infect critical infrastructure throughout the US and Guam
‣ 🐍 👨🏻‍⚖️ #PyPI was subpoenaed
‣ 🇰🇵 🦠 N. Korean #Lazarus Group Targets #Microsoft IIS Servers to Deploy Espionage Malware
‣ 🦠 🤖 Data Stealing Malware Discovered in Popular Android Screen Recorder App
‣ 🇩🇪 Arms maker Rheinmetall confirms #BlackBasta ransomware attack
‣ 🦠 New ‘GoldenJackal’ APT Targets Middle East, South Asia Governments
‣ 🇺🇸 🇰🇵 Treasury Department sanctions entities tied to North Korean IT scams, hacking
‣ 🇺🇸 📰 Cuba ransomware claims #cyberattack on Philadelphia Inquirer
‣ 🇺🇸 🏥 After ransomware attack, state’s second-largest health insurer says patient data stolen
‣ 🇯🇵 🇮🇳 🏍️ #Suzuki motorcycle plant shut down by cyber attack
‣ 🇺🇸 🪖 #Pentagon explosion hoax goes viral after verified #Twitter accounts push
‣ 🇺🇸 🇪🇺 #Meta Fined Record $1.3 Billion and Ordered to Stop Sending European User Data to US
‣ 🦠 🎬 Cloned #CapCut websites push information stealing malware
‣ 🇰🇷 🇺🇸 Warning: #Samsung Devices Under Attack! New Security Flaw Exposed
‣ 🍏 #Apple fixes three new zero-days exploited to hack iPhones, Macs

#hacking #cyber #cyberdefense #security #health #cloud #infrastructure #OT #ICS

📚 This week's recommended reading is: "Cyber Defense Matrix: The Essential Guide to Navigating the Cybersecurity Landscape" by Sounil Yu

Subscribe to the #newsletter to have it piping hot in your inbox every Sunday ⬇️

https://0x58.substack.com/p/infosec-mashup-week-212023

whats a good resource for learning SQL? #sql

How often do you write a (#SQL or otherwise) #database query that returns more results than there are rows in any of the tables used? (on purpose!!)

#CaseStudy - Meta is rolling out #MySQL Raft in its data centers to replace its current MySQL semisynchronous databases. The new consensus engine helps operation and allows MySQL servers to take responsibility for promotions and membership.

More on #InfoQ: https://bit.ly/437uO6w

#AI #ML #SQL #RelationalDatabases

Running into problems with EntityFramework and enum support for things that should be trivial, like this type of LINQ: context.FooBars.Where(f => EnumFilterList.Contains(f.Enum));

It created the weirdest non-functional SQL for that instead of a straight-forward:
where foobars.enum in ('Enum.One', 'Enum.Two');

I suppose it isn't helping that I am storing the values in the DB as strings. But even if storing the enums as int values would fix this, I like having the strings in the DB because they make interacting with the data directly in a SQL tool much easier.

#EntityFramework #DotNet #SQL

My range of emotions involving #coding this week have ranged from "I never want to do anything else for a living again other than #code" to "I never want to see another line of #SQL or any other #language again in my life.."

...of course it may have to do with the fact I've been working heavily in #legacy #ASPClassic code that is too big to replace easily this week..🤢

..I think I'm gonna take a break and code on my #python #framework and #fediverse app to get some mojo back this #Saturday

I had to write my first SQL queries in a couple years and I think I still remember how it works. Also Python... what are these type things?! 😀

All of this is because I'm doing some data analysis of feature requests, bugs, etc. Some fun stuff to play with:

- vector similarity search
- tfidf as a secondary search
- LLMs for a bunch of steps, extracting lists, some categorization, etc
- random forest for categorization

#llm #devrel #ml #sql #python #data

As a #dotnet #entityframework user, you must remind yourself that any #LINQ you write will be directly translated to a #SQL Query as written. There’s no “make my query better” magic happening in EF Core.

Here are two examples of logically equivalent queries using different LINQ methods and their SQL translations.

Write LINQ, test your performance, and try again.

#entityframework 8 works. It’s fantastic that there is now array support for primitive types. You can even see it in the generated #sql.

This should open up many options for #dotnet developers using #SQL server and a lot of discussions with DBAs 😅.

Update: Added a screenshot of how data is stored in SQL Server.

..I remember when I wanted to work my way up to #management

..be careful what you wish for...

I got there and I hated it and quit.. #burnout is a mofo..

Now I'm back at the same company on a #contract and pumping out #SQL and #Python 4 hours a day and loving it, and I get to pick up side contracts and work on my own small #business some

I will say I respect what a good manager does a lot more now that I've been one. They run block and let their team crank out #code and I am here for it!

@synlogic @ghorwood
For #Java, I would replace the last one with

"3. expert/never-hipster: uses jOOQ"

When I discovered #jOOQ years ago, it was eye-opening. One can really get the same level of control as with hand-written #SQL bit still have a comfortable API! Its author @lukaseder says that the guiding principle for designing this #FluentAPI is that jOOQ *is* SQL.

See the comparison image in this post: https://foojay.social/@foojay/110067514875132847

#Hasura is fun! I've just written the entire user management business logic for a new service in #sql and #yaml

#WebDev #Backend

Love #PostgreSQL Looking to work with #MachineLearning and AI? Wanna use them together?

Look no further than #pgvector

https://github.com/pgvector/pgvector

Allows you to store and index vectors as well as do vector math and distance calculations - all in THE BEST database in the universe.

Hat tip to this blog post for bringing it to my attention

https://www.crunchydata.com/blog/whats-postgres-got-to-do-with-ai

#sql #isThereAnythingPostgresCantDo

Welcome to #SQL Keyword of the Week!

This week's keyword is: DELCARE

Now here is a keyword I use all the time. You'll probably find it to be self-explanatory, but here's the definition just in case.

DELCARE is used whenever my script fails to run because I mistyped DECLARE again.

Today's excitement involves trying to bend into shape a #SQL query that includes (so far) 2 CTEs, a cross join, two unions, a left join, 3 inner joins and an aggregate.

It's... a bit head hurty, but I'm getting there.

SQL programmers be like

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

TIL about #SQL window functions and @rrwo’s helper module for them in the leading #Perl #ORM, DBIx::Class. You can use them in many different relational database systems like #MariaDB, #MySQL, #PostgreSQL, and #SQLite. https://fosstodon.org/@rrwo/110334747507360471

Spent the morning answering a #JetBrains #dotnet blog reader's question about filtering on a #JSON collection using #EFCore and #sql

Any folks have some thoughts? It turns out this is such a new use case that there isn't query support yet for arrays through LINQ.

https://blog.jetbrains.com/dotnet/2023/02/14/getting-started-entity-framework-core-7-json-support/#remark42__comment-db104e2f-baec-4801-9b33-334fe2586753

📰 another brief one up (in terms of word count at least 😅)
"Checking out EF Core inheritance options"

Recently there was a need to use a hierarchy in a domain model, and there was a question about which of the available approaches to use - table per hierarchy (TPH), table per type (TPT) or table per concrete type (TPC). This very brief post is just a quick look at some benchmarks I created on the subject.

#DotNet #CSharp #EFCore #SQL

https://blog.codingmilitia.com/2023/05/08/checking-out-ef-core-inheritance-options/

@UkiahSmith @scimon Do it!

(Though the “experience with #SQL and ORMs such as DBIx::Class” requirement might preclude your qualification, depending on what you mean by “haven’t touched #Perl in ages)

3Pillar Global is hiring Senior .Net Developer

🔧 #dotnet #java #dotnetcore #aws #azure #nosql #sql #seniorengineer
🌎 Guatemala
⏰ Full-time
💰 $90k - $230k (Estimate)
🏢 3Pillar Global

Job details https://jobsfordevelopers.com/jobs/senior-net-developer-at-3pillar-global-feb-28-2022-c8bc72?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

New blog post: Chat GPT says SSMS is the best SQL Server monitoring tool-- and it's right

#sql #sqlserver #monitoring #chatgpt #ssms #blog

https://littlekendra.com/2023/05/03/ssms-is-the-best-sql-server-monitoring-tool-chatgpt/

Am I the only one who wants pipelined/chained functions in #SQL?

Something to the tune of

select response |> body() |> convert_from('utf-8')

instead of

select convert_from(body(response), 'utf-8')

Free Intro to SQL class - four 1-hour sessions in May, all at 9 am PDT/noon EDT, taught by Paul Buffa at @observablehq
May 23, 24, 30, 31
https://observablehq.com/@observablehq/intro-to-sql-course
#SQL

Can't a #GPT do this for me? Well, here's an explanation as to why it's still useful to learn #SQL.

#Development #Tools
A list of programming playgrounds · A community-sourced collection of playgrounds for web developers https://ilo.im/12dmwi

_____
#Playground #WebDevelopment #WebDev #Frontend #Backend #HTML #SVG #CSS #JavaScript #TypeScript #JSON #RegEx #Unicode #Git #PHP #Python #Ruby #Rust #SQL #DNS

Available for hire: entry-level backend software engineer looking for full-time position or internship. He prefers Bay Area on-site.

Proficient in #JavaScript / #Node.js, #Java, #SQL. Also used #C / #C++, #Redis, #TypeScript, #LLaMA, & more.

https://linkedin.com/in/nmorearty/

This engineer is my adult son, Nick Morearty. He started as a Computer Engineering major at UC Santa Cruz but ended up deciding to take a different path. He has taken NuCamp’s Full-Stack Web + Mobile Development bootcamp, and I’ve been teaching him all about software engineering for the last ten years--since he wan ten years old. In 2020 he got a perfect 5 on the AP Computer Science test, self-taught from a book and tutored by me.

Please share for reach.

Demystifying #SQL Window functions. In these two videos @markhneedham does a great job of that

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

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

@sushee that is why I never got into nosql database at all.

I did learn them but when it comes to reporting sql dbs are so good, one cant beat them.

Also I have yet to work at an organisation where they get user numbers near a million.

If one is working with thousands of users sql is the best.

#sql
#database

Make sure you read the license

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

True story

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

If it works, don't touch it

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

Found this PR in the twitter open source algorithm repo

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

Just started using #ChatGPT and #GithubCopilot for a personal project and I'm pretty impressed. They've been super helpful with writing tests and figuring out complex #SQL queries and #Regex.

Also, I accidentally discovered that Copilot can help write commit messages. Using a commit message template with a prompt comment and running git commit --verbose, Copilot does a great job of reading the diff and figuring out the appropriate commit message.

This mad lad fixed twitter with a single pull request

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

Please help me find the error

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

Here is a #Jupyter Notebook where I use the #LangChain framework + #LLM to write #SQL and build #dataviz in #python. It was extra fun to do this with real voter data. I learned a lot!
#projects #PoliticalTech

https://github.com/hodgesmr/LangChain-Data-Demo/blob/main/LangChain%20Data%20Demo.ipynb

Noticias sobre Python y Datos de la semana, episodio 71 🐍⚙️

En resumen: El impacto de NumFOCUS, versiones nuevas de Kedro-Viz, Fugue, y deepchecks, Markdown avanzado en JupyterLab, aplicaciones con PyScript, y la PyCon Latam en Mexico

https://astrojuanlu.substack.com/p/episodio-71

Apoya el noticiero suscribiéndote por correo 📬

#numfocus #kedroviz #fugue #sql #markdown #jupyter #pyconlatam #pyscript #python #pydata #noticieropythonydatos

And following up on yesterday's Data Wrangling comparisons across #Javascript, #Rstats, #Python, #SQL, and #Excel by @allison_horst, here is a dive into Descriptive Statistics across the same set of tools https://observablehq.com/@observablehq/descriptive-statistics-translations

It seems that #pgadmin is not quite ready for #Debian bookworm.

I tried building it from scratch; but, it's a whole bunch of #javascript node intimidating crap. Total rat-hole waste of time...

I'll be giving DbGate & dBeaver a test drive this week to see if they work as #SQL GUIs.

pgadmin seems to release pretty regularly, so perhaps I'll get a 7.0 release in a week or so. *shrug*

#Business #Design #Development #Launches
sqlTranslate · Easily translate SQL commands into natural language and vice versa https://ilo.im/11vh0y

_____
#Tool #WebDesign #WebDevelopment #WebDev #Backend #Database #SQL #NaturalLanguage #Translator #DataAnalysis

Data wrangling essentials: comparisons in #JavaScript, #Python, #SQL, #Rstats, and #Excel by @allison_horst https://observablehq.com/@observablehq/data-wrangling-translations

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.

Learn for free 📚 (2/2)

#Node → https://gitconnected.com/learn/node-js
#Java → https://javatpoint.com
#DSA Visuals → https://visualgo.net
#SQL → https://sqlbolt.co
#Interviews → https://interviewbit.com
#HTML → https://w3schools.com
#CSS → https://css-tricks.com
#JavaScript → https://javascript.info
#React→ https://react-tutorial.app
#Angular → https://angular.io/tutorial/tour-of-heroes

#learn #web #dev #webdev #code

The "SQL for Backend Developers" track is live on JetBrains Academy! In just 11 hours, you'll:

✅ Learn how to use databases to develop effective services.
✅ Work with #SQL statements.
✅ Get familiar with MySQL, the most popular open-source database.

https://jb.gg/academy/sql-for-backend-developers

SQL is one of the most in-demand skills for anyone working with data. With this new track on JetBrains Academy, you will:

🔹Learn how to query data with #SQL
🔹Dive further into data analysis with #Python
🔹Get familiar with SQLAlchemy

Learn more 👇
https://jb.gg/academy/new-track-sql-python

We've got the Monday Merries thanks to industrious community members, such as...

Federico Dotta (@apps3c) who wrote #PHP rules to catch #SQL injection, #XSS, and broken access control in general PHP as well as in the #YII framework! Thank you, Federico! https://security.humanativaspa.it/semgrep-rules-for-php-security-assessment/

The SQL Fundamentals track is now available on #JetBrainsAcademy! ⚡️

In just 8 hours, you will:

– Learn the basics of #SQL
– Work with MySQL, the most popular open source database
– Use SQL functions in real-life tasks
– Get a certificate of completion

https://jb.gg/academy/sql-fundamentals-track