Tag Info

The point of a thesis depends on who grades it. To some, the point is to prove that you can work scientifically. To others, it's to make a small contribution to science. I think the point is not to do ...

From the Prisma docs: findFirst calls findMany behind the scenes and accepts the same query options. Assuming based on your reply that you are passing in query options that will return exactly one ...

It's impressive to have achieved what you did as an undergraduate. You should not evaluate your project by comparing it to mature RDBMS projects that in fact have thousands of engineer-years of work ...

Thank you, that really helped. Even if my project is small, rebuilding these ideas from scratch has taught me a lot, and I should not ignore that.

You aren't a fool; you're reinventing the wheel. This is something we all do. Recreating something that was previously created allows you to explore the topic much deeper. Those analysis skills will ...

This really did remind me: how could I possibly compare an undergraduate thesis project with the work of people who have spent more than a decade in the field? Anyone who does that is obviously a fool,...

Real systems are made over years and decades, by entire teams and divisions of engineers, in response to concrete pain points that someone needs solved. Nobody builds a skyscraper by himself. Don't be ...

You can do it in one query (if your IoTDB version supports subqueries): SELECT time, s1, s2, s3, s4 FROM root.sg.d1 WHERE s1 = (SELECT MAX(s1) FROM root.sg.d1); This returns all rows where s1 is at ...

In GBase 8a, data distribution determines how rows are physically distributed across nodes in the cluster. Besides hash distribution, the following strategies are supported: Replication Description: ...

Firebase (Firestore/Realtime Database) is NoSQL — there's no built-in SQL mode. But you can query your Firestore data with real SQL using fire_duck_ext, a DuckDB community extension that connects ...

If you are wondering if this is faster in the specific case where findMany returns exactly one result, you may wish to edit your question to clarify this.

The user thing was just an example, I'm talking about queries where I'd need to fetch a single record like a getById, for example. Currently I use findFirst() and the first item from findMany() ...

I guess that pulling only one is faster too but I'm seeking some confirmation from people that have bigger knowledge than me.

Why do you want the first user, in particular? Is it possible you're really thinking of a different query? If so, maybe you could edit your question to ask something closer to what you're really ...

could you not just try out both ways and compare? it seems logical that asking for just one when that's all you need would be faster than pulling everything over and then selecting one from that.

Without some corresponding data to compare, you can only make an informed guess.

Some portals show roadmaps with details - ie. Data Engineer Roadmap on roadmap.sh

if Data Engineering means you want to learn also Machine Learning and AI then you should see page Kaggle. There are competitions for ML/AI with example data which you can reuse in learning pandas/...

Thank you!! So I will continue my path :)

You learn elements which are useful not only in Data Engineering but also in Web Designing and other situations - so it good direction.

Haven't seen this answer yet: subquery with LIMIT 1. SELECT any_userdata FROM user WHERE (SELECT anything FROM whatever WHERE rating > 10 LIMIT 1) IS NOT NULL

You can set your jdk home editing product.conf like this: SetJavaHome /usr/lib/jvm/java-1.17.0-openjdk-amd64 Product.conf is in the following directories according to ide.conf: # Windows Platforms: # ...

The problem is that you are only removing the item from the Cart's list, but the Item itself still points to the Cart in the database. In JPA, the "Many" side (the Item) controls the ...

the handout is about 15 pages, and all of them is important, so i don't know how put it here, and my erd for mermaid draw is about 280 lines so i'm afraid that it's too long for every one, so how ...

You'll probably want to actually post the details in the body of the request so people can see them. Also mention any particular areas you aren't happy with in your current design and why.

For MySQL 8.0 and onwards ALTER TABLE table_name RENAME COLUMN old_col_name TO new_col_name; Credit goes to Lukas from this question.

I see, thank you for answer, definitely will check out book)

ok, thank you for answer, it seems like PG is good for me

thank you for answer, i'll try

Question was closed in SG: https://stackoverflow.com/staging-ground/79906216. There is no point to use advice post to circumvent the closure. Also you opened a post in dba, there is no need to post it ...

I actually built a Pinterest-related PinCatch tool website and went with PostgreSQL for structured data (user sessions, download history, metadata) and it has been working great for high-read ...

Thanks for your suggestion, i tend to be hasty to start, and thanks to your suggestion, i know what must be done next, sorry for a bad question when i have such a little experience about this. Thanks ...

Before talking about entities for it, it would be good to understand if you have the ideas of such self-protection mechanisms. If not, it would be not a good idea to talk about nothing. The topic is ...

Except that w3schools teaches all kinds of bad habits and incorrect terminology. Its like AI, take it with a pinch of salt.

Its the AI generation - everything is a prompt :)

This one is a good place to start.

Have you tried a tutorial? I mean there are loads out there, no one is going to write an answer as good as a tried and tested tutorial. It is an entire language, takes more than one question to get ...

These are not "prompts". They are keywords common to variants of the SQL language. You can learn more of them, as well as learn more about SQL in general, by starting with some ...

Short answer: No. Thinking about search and finding expression in database fields. It would be better stored in database.

And this knowledge must be translated into a test plan and test cases to make it available 24/7 while developing and testing.

First of all, 98 tables don't make the database large. When each table has an average of 1TB of data, that would make it large. But second, and actually more important, how are you going to test the ...

Right. Trusting the stuff an AI produces without verification by a knowledgeable human is a fairly certain recipe for disaster.

Honestly, 98 tables is typical or even on the low side for a single-application database. I don't mean disrespect, but if this intimidates you, then perhaps you should take on a simpler project until ...

You say that you designed a PostgreSQL database, so why give it to AI? As you have discovered, AI is not the answer to everything. You should find a good book or other resource on database design and ...

You can use either database. What matters is using the right modeling approach for the one you choose. With MongoDB, you model the domain with aggregates (users, boards, pins). If the number of pins ...

There's no wrong answer to your question of which one to use. You could be successful with either choice — PostgreSQL or MongoDB. Clearly those are successful database products for a variety of ...

When you write I want to build a system where the employee will know the exact location what exactly do you mean with "exact location"? Do you mean the exact planned location of the bus (i....

Without knowing anything about your experience level, or what you've used (except for C), there's no way to answer this question. Maybe have a conversation with Claude or Copilot to get a starting ...

I'm a big fan of c but it probably isn't the best choice for a project like this. c is usually used for high performance computation or low level system control. Your question is way too broad for ...

" the employee don't know where the bus currently is." Do YOU know where the bus is? How do YOU know? Presumably there is some application or website where you can find this information. ...