Am I the only one that consistently gets hammered in the groin when using MySQL?
 It's All Fucked Shirt $22.14 |
 Thalidomide Vintage Ad Shirt $22.14 |
It's All Fucked Shirt $22.14 |
Am I the only one that consistently gets hammered in the groin when using MySQL?
Yes, install Postgres.
>set up new instance
>make a user with every available privilege on any client
>user not allowed to run query
>2 hours of debugging later
>simply restart the daemon and it works
>insert table columns values
>data to long for *non existant column*
>well frick, that's useful
>change all varchar N cols to text
>same issue
>okay, frick MySql support for this program
>running a query using dbeaver
>simple select statement won't return on small database table
>terminating query won't work
>know there is only one client (a program) connected besides dbeaver
>stop the connected program
>still fricking frozen garbage
>welp
>restart the database
>ok, it works
sqlite bros... I'm coming home
okay, THATs shy my post was not submitting. You can't type varchar ( n *closing parenthese*
I tell you, I ALWAYS hit these phaggy little snags with technology
t. op
Holy shit you're right.
Why is that? What's special about "varchar(n*close parentheses*" that makes 4ch/cloudflare shit themselves?
scared of sql skiddies
Tell her to stop. It's technically abuse.
>using mysql and not mariadb
joever for you tbh
Come home brown man
Do you guys have any recommendations for someone trying to learn SQL?
I’m not in the tech industry or anything, but I‘ve been fricking around with M language and DAX in Excel/Power BI long enough now (even if it’s mostly basic inner/left outer joins) that I should probably cut out the middleman- plus it might help me find a job that I hate less.
not really, just use the database docs themselves when you're really stuck. also get started on a project what uses sql. That's how you learn best
sqlite is fine for me and if you need more youre using your database wrong
Just use Firebird
I know SQL syntax way better than I know using the SQL-GUI, so I just grab the UI and input raw SQL commands lmao
no, that's why most everyone uses postgres and gets hammered in groin in a different, but somewhat more mitigated, way.
can't imagine using a database that isn't MVCC in 2024 honestly. SQL Server is pretty ok too if you use the right isolation levels.
What? MySQL with InnoDB (which is the default), and PostgreSQL by default are MVCC. SQLServer is the only one that isn't by default and needs to be configured for it.
good to know.
thanks anon.
SQL Server is a b***h to use thanks to its moronic API bullshit, even if it is pretty neat. At work, there are a few queries which consistently time out (30s max runtime for queries) despite the fact that sometimes they are the only process running. Something inside the database, definitely NOT another query, locks the table data and causes the query to never actually complete until the dbms either kills the process locking the table, or the process finishes whatever the frick it was doing
It literally works in my machine though? We use it at the company too and I haven't really had problems with the database server.
Workbench shits itself on the regular though.
my company uses it too, and I'm baffled it works for others. Idk if its cus I
(page 10, I needed to bump, quickly)
cus I didnt read the full mysql docs of how to operate mysql, or what, but I always have these weird hang ups with it. It's made me turn to SQLITE. I dont want to frick with user privileges and data types