pythonofftopic | Unsorted

Telegram-канал pythonofftopic - Offtopic

12466

Offtopic group for casual talking about anything. @rules_for_python still apply (except for the ontopic rule)

Subscribe to a channel

Offtopic

It has nothing to do with human rights or the other old excuses!

The U.S. invasion of Iraq, under the pretext of Saddam’s weapons of mass destruction, resulted in nothing but destruction.

Of course, Iran is different from Iraq.

Читать полностью…

Offtopic

If I may ask straight; you're afraid of occupation?

Читать полностью…

Offtopic

Now i get this idea of how to handle this 1NF 💚

Читать полностью…

Offtopic

After i now learn all the nf now i points to why it say this is not good table what it cause NF problem.

1NF: Each cell holds a single atomic value; every row is uniquely identifiable.
All the attributes (columns) contain only atomic (indivisible) values.
Each column contains values of a single type.

Now see as if i will allow Null for email, so my column will hold str|None, but this upper say i should to use only 1 data type also & it should be Atomic

Читать полностью…

Offtopic

Where exactly does it says so?
And what NF is that?

Читать полностью…

Offtopic

Where in NF says that you cannot have Null values??
You got some things wrong here...

Читать полностью…

Offtopic

if it's too slow that what do you use for NoSQL

Читать полностью…

Offtopic

For example, I read that applying all Normal Forms (NF) properly can cause significant problems. Suppose I have an e-commerce website where I collect user addresses containing multiple fields, but some users may not fill in all the fields.

Since normalization requires tables to be atomic and minimizes null values, how should I structure the user data storage table to avoid nulls if I apply all NFs? Would I need to create multiple tables (e.g., one for Student ID and Name, one for Student ID and City, one for Student ID and State, etc.) and join them to keep the database free of null values? Is that the correct approach?

Читать полностью…

Offtopic

Hmmm, thinking of sqlite
it doesn't have full Alter table support

Читать полностью…

Offtopic

He makes it complex in his head

Читать полностью…

Offtopic

And?
It is the essence of relational databases
Using tables and joins

Читать полностью…

Offtopic

after applying all the nf its just end up with lot pf tables and connect them 🧠🤯

Читать полностью…

Offtopic

No, you use what you need
Right tool for the right job

And who says you cannot have both?
I usually run Postgres (SQL) and Redis (NoSQL) together

No issues 🤷‍♂

Normal developer workflow
Use the best tool for the job

Читать полностью…

Offtopic

yaa its what you get the point, as the NF things so really not logical so i want to find better way mongo but 💔

Читать полностью…

Offtopic

So he can skip learning NF

Читать полностью…

Offtopic

Occupation is a possibility, but I consider it unlikely to happen.

What has been officially stated by U.S. officials includes occupation, partition, and other major threats.

The weakness of a country’s national government does not give the United States the right to attack it.

This war is entirely about controlling energy resources in the Middle East.

Читать полностью…

Offtopic

I was and still am one of the protesters myself, and I was out on the streets during all those terrifying nights.

But we’re not children!

That has nothing to do with another country coming in and plundering us, taking our oil, and taking control of our energy resources.

This isn’t one of the Arab countries in the Persian Gulf, and it isn’t Venezuela.

Читать полностью…

Offtopic

You are mixing database layer with runtime layer

In database it will be either None or some value

It does not break 1NF - there are no multiple values represented at the same time

It can be either None or specifi value - it cannot be both and it should not contain multiple values

But using NULL does not breal NF

Читать полностью…

Offtopic

You've got your hands full living under the control of your own government.

edit:

Got to correct myself:

Killed the protest wave. The January 2026 protests were the largest in a generation — the regime was genuinely on the brink. The war shut that down overnight. The Small Wars Journal's July analysis calls it a textbook rally-around-the-flag: "once foreign strikes began, there was no comparable mass anti-regime uprising." 

Everyone's on the same page now.

Читать полностью…

Offtopic

in the atomic data insertion level that keeping null is against the NF

Читать полностью…

Offtopic

aabouzaid96/performance-benchmark-between-couchbase-and-mongodb-26ab2abd4b6e" rel="nofollow">https://medium.com/@aabouzaid96/performance-benchmark-between-couchbase-and-mongodb-26ab2abd4b6e

Читать полностью…

Offtopic

that's say i think this tabel is good for my website, but then NF rules say, there should not be Null value in my table, so as you say i must to apply the concept of NF here, bu so to apply this will i really make many small small table just for store user address?

Читать полностью…

Offtopic

In my opinion if you don't need data migration or good lookup performance, or you have really few of data you don't need sql

Читать полностью…

Offtopic

its end up messing up with many tables and finding one data i need to do many queries and so on 😔
and then also i think to make a stat like balance in my website,i also must need to separate all those 🥹
its looks like i cannot skip this 5NF fully

Читать полностью…

Offtopic

He don't have that complex relationship of data

Читать полностью…

Offtopic

Honestly he could skip sql NF without picking another database..

Читать полностью…

Offtopic

Yeah, sure
We all heard that before

Читать полностью…

Offtopic

but i am really learn this one day

Читать полностью…

Offtopic

i listen i many videos even in schools teach both sql and nosql btw , that they Say in real hosting case we should to use sql always must !!!

Читать полностью…

Offtopic

No, just another buzzword for him

Читать полностью…
Subscribe to a channel