pwaring, to random
@pwaring@fosstodon.org avatar

TIL: If you try to manually INSERT a row into a MySQL table and set an AUTO_INCREMENT column to 0, MySQL ignores the provided value and assumes you want the next increment amount.

Found this whilst migrating a legacy database to a new structure, where the legacy database had foreign keys (not actually defined as constraints) with 0 values.

You can control this with NO_AUTO_VALUE_ON_ZERO in sql_mode (it's on by default I think).

leanpub, to ComputerScience
@leanpub@mastodon.social avatar

Build Your Own Database From Scratch by build-your-own.org is on sale on Leanpub! Its suggested price is $29.00; get it for $19.75 with this coupon: https://leanpub.com/sh/GVNwqXYy

br00t4c, to asia
@br00t4c@mastodon.social avatar

Researchers claim Windows Defender can be fooled into deleting databases

https://go.theregister.com/feed/www.theregister.com/2024/04/22/edr_attack_remote_data_deletion/

aral, to SmallWeb
@aral@mastodon.ar.al avatar
leanpub, to elixir
@leanpub@mastodon.social avatar

Northwind Elixir Traders by Isaak Tsalicoglou is on sale on Leanpub! Its suggested price is $29.70; get it for $15.92 with this coupon: https://leanpub.com/sh/oRQHj3OZ

leanpub, to ComputerScience
@leanpub@mastodon.social avatar

Build Your Own Database From Scratch by build-your-own.org is on sale on Leanpub! Its suggested price is $29.00; get it for $19.75 with this coupon: https://leanpub.com/sh/BjexLW1x

Posit, to random
@Posit@fosstodon.org avatar

We’re most pleased to announce the release of dbplyr 2.5.0!

dbplyr is a database backend for dplyr that allows you to use a remote database as if it were a collection of local data frames. dbplyr 2.5.0 introduces succinct new syntax for literal table identifiers.

Learn more on the tidyverse blog: https://www.tidyverse.org/blog/2024/04/dbplyr-2-5-0/

leanpub, to books
@leanpub@mastodon.social avatar

Leanpub book LAUNCH! Northwind Elixir Traders: A practical tutorial on databases with Ecto by Isaak Tsalicoglou https://youtu.be/jr8-Z4hnUmg

leanpub, to elixir
@leanpub@mastodon.social avatar

Northwind Elixir Traders: A practical tutorial on databases with Ecto https://leanpub.com/northwind-elixir-traders by Isaak Tsalicoglou is the featured book on the Leanpub homepage! https://leanpub.com

leanpub, to ComputerScience
@leanpub@mastodon.social avatar

Build Your Own Database From Scratch: Persistence, Indexing, Concurrency https://leanpub.com/build_your_own_database_from_scratch by build-your-own.org is the featured book on the Leanpub homepage! https://leanpub.com

leanpub, to elixir
@leanpub@mastodon.social avatar

Northwind Elixir Traders: A practical tutorial on databases with Ecto https://leanpub.com/northwind-elixir-traders by Isaak Tsalicoglou is the featured book on the Leanpub homepage! https://leanpub.com

leanpub, to ComputerScience
@leanpub@mastodon.social avatar

Build Your Own Database From Scratch by build-your-own.org is on sale on Leanpub! Its suggested price is $29.00; get it for $19.75 with this coupon: https://leanpub.com/sh/X7ZbTCdt

cincura_net, to dotnet
@cincura_net@mas.to avatar

Package Microsoft.EntityFrameworkCore has now over 1B downloads.

🎉

br00t4c, to random
@br00t4c@mastodon.social avatar

Zapier's New Features Will Be a Hit With Automation Nerds

https://lifehacker.com/tech/zapier-new-features-hit-with-automation-nerds

DaveMasonDotMe, to random
@DaveMasonDotMe@mastodon.social avatar

Developer tells me the new table they just created is 'temporary' and will only be around for a week or two. 🙄

I should also receive the ownership deed to the Brooklyn Bridge any moment now...


Posit, to apple
@Posit@fosstodon.org avatar

Posit Professional Drivers - ODBC data connectors for connecting to some of the most popular databases - now natively support Apple silicon!

Now, it’s even easier to connect and use your databases from RStudio.

Learn more: https://posit.co/blog/pro-drivers-2024-03-0/

br00t4c, to australia
@br00t4c@mastodon.social avatar
khalidabuhakmeh, to rust
@khalidabuhakmeh@mastodon.social avatar

This is a cool project for accessing .

https://diesel.rs/

vyruss, to PostgreSQL
@vyruss@fosstodon.org avatar

📢 This week: "Recovering from Data Loss Despite Not Having a Backup: A Postgres True Story" 📆 Friday March 15 at 17:00, Ballroom H @ — see you there!

https://www.socallinuxexpo.org/scale/21x/presentations/recovering-data-loss-despite-not-having-backup-postgres-true-story promo code SPEAK for 50% off registration.

br00t4c, to Health
@br00t4c@mastodon.social avatar
clairegiordano, to PostgreSQL
@clairegiordano@hachyderm.io avatar

It’s official 🐘 I am on my way ✈️ to @nordicpgday & —and I am so excited 🎉🥳 to see some of my favorites—and to meet new ppl in the PG community too.

At Nordic I will give a beginners guide talk about partitioning & sharding—and in Paris I’ll give a lightning talk about fighting the butterflies & giving your first Postgres conference talk.

Who do I know that’s going?

khalidabuhakmeh, to rust
@khalidabuhakmeh@mastodon.social avatar

The language injections feature continues to be one of the slickest features of IDEs, and I'm so happy to see it works flawlessly in .

If you're working with in , check this out. It helps you catch silly spelling errors by validating SQL against a schema.

RustRover language injections.

leanpub, to ComputerScience
@leanpub@mastodon.social avatar

Build Your Own X: Redis, Database, Compiler https://leanpub.com/b/byo_redis_db_compiler by build-your-own.org is the featured bundle on the Leanpub homepage! https://leanpub.com

vyruss, to PostgreSQL
@vyruss@fosstodon.org avatar

👋 Valued contacts in IT and specifically in the / community: I'd love it if you could reach out to me with insights or stories to tell regarding 🧠 mental health in the . Many thanks in advance 🙏

changelog, to webdev
@changelog@changelog.social avatar

Sounds like @jerod has no qualms with connecting to a remote database while doing local web development.

🎥 https://youtu.be/FXEYMuuHNas

Is his reasoning sound or has he lost his marbles?

  • All
  • Subscribed
  • Moderated
  • Favorites
  • provamag3
  • rosin
  • thenastyranch
  • tacticalgear
  • InstantRegret
  • Durango
  • DreamBathrooms
  • ngwrru68w68
  • magazineikmin
  • khanakhh
  • Youngstown
  • mdbf
  • slotface
  • kavyap
  • JUstTest
  • modclub
  • ethstaker
  • cubers
  • normalnudes
  • everett
  • GTA5RPClips
  • cisconetworking
  • osvaldo12
  • megavids
  • Leos
  • tester
  • anitta
  • lostlight
  • All magazines