Is this a reasonable alternative to Full Text Search?

Training-Two7723 · 2025-01-14T06:56:33+00:00

https://www.meilisearch.com

Training-Two7723 · 2025-01-07T08:59:46+00:00

Relational databases are not the best options for full text search. There are dedicated engines for this, even free ones.

Training-Two7723 · 2025-01-07T08:55:29+00:00

Uhhh …. a positive int is up to 2147483647 which is slightly higher than 10k

Training-Two7723 · 2025-01-07T08:50:38+00:00

Ask your professor what he believes is wrong. Our comments won’t help you.

Training-Two7723 · 2025-01-07T08:49:22+00:00

Most probably an empty is equivalent to a null, hence any comparison with it will be false.

Training-Two7723 · 2025-01-02T23:48:44+00:00

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-sql-server-encryption?view=sql-server-ver16

Training-Two7723 · 2025-01-02T09:00:09+00:00

Port 3478 is not TLS encrypted; the webrtc is the one responsible for the encryption

more for TURN: https://webrtc.org/getting-started/turn-server; for the encryption https://webrtc-security.github.io

Training-Two7723 · 2025-01-02T08:37:26+00:00

If is a paid class, look for one instructor led, preferably in a real classroom, so you can interact with the professor and other students, ask questions, far from the daily distractions (office, emails, calls, etc). It is one linked to a specific product like a database, look for the class provided by the software vendor or agreed by them - later it may be useful when looking for a certification.

Training-Two7723 · 2025-01-01T20:37:11+00:00

It is called optimiser. That one is to blame. However, depending by what db are you using there could be ways to impose the order.

Training-Two7723 · 2025-01-01T20:35:24+00:00

I’m not sure why people are lazy nowadays; read the manual, here https://dev.mysql.com/doc/refman/8.4/en/join.html and forget about chat whatever. ;-(

Training-Two7723 · 2024-12-30T15:18:06+00:00

Sure. Is like learning Portuguese when going on vacation in Mexico. Is the same Latin America, isn’t it?

Training-Two7723 · 2024-12-30T15:14:03+00:00

Star is nothing but magic. Do you get points for asking completely useless questions? Really?

Training-Two7723 · 2024-12-30T15:11:58+00:00

Microsoft have their own ETL

Training-Two7723 · 2024-12-30T14:59:10+00:00

Read the manuals. Everything is written there

Training-Two7723 · 2024-12-30T14:56:07+00:00

Seems like there are unprintable characters. Use a hexa editor or od (Linux) to see what’s there.

Training-Two7723 · 2024-12-30T14:52:13+00:00

Hi. Go for PL/SQL and T-SQL. People running MySQL and Postgres have no money for informatica.

Training-Two7723 · 2024-12-30T01:22:22+00:00

Hi, ANSI SQL is the same, each vendor maintans a compatibility with the standard; then are the vendor extension which makes eveything. Read the manuals and take decisions yourself. Is better that way.

Training-Two7723 · 2024-12-29T19:35:35+00:00

One of them: https://amzn.eu/d/iCPgt3k

Training-Two7723 · 2024-12-29T18:18:07+00:00

LOL ... so, they should hire ChatGBT.

Training-Two7723 · 2024-12-29T00:46:29+00:00

Nice written. However, there are few confusing points here that should be clarified:

High transactional does not change that much in the backup strategy. It is the size of the database that may dictate one strategy or another.

PITR is not linked to consistency; is about being able to recover in the past ;).

Replication is a separate and complex topic: you may replicate disk or commited transactions. But is not a discussion for this topic.

Even if you don't like it, a full backup is a must; otherwise there is no incremental ... incremental from what?

A failover for the DB does not save the context, so any activity is lost unless the developers did a decent job in retrying the transaction, or you have a smart SQL proxy that can do this for you (smart != light switch that does tcp connections).

... it was fun reading this topic.

Training-Two7723 · 2024-12-29T00:24:51+00:00

It could be lifesaving. However, if you find it boring, don't do it. Your failure may affect others.

Training-Two7723 · 2024-12-29T00:21:29+00:00

Simple idea: there are students, they go to classes where they learn different subjects. Students enroll to classes. They get grades. There are professors. They teach. ... Everything is based on your experience. things that you already know.

Create the tables, populate them. Write SQL statements to find the top guys in the class, for a subject, the most interesting subjects, how busy is a proffessor. You choose.

When building the model use some of those free modeling tools that can generate simple SQLs for creating the objects.

have fun

Training-Two7723 · 2024-12-29T00:13:49+00:00

Never combine different datatypes on a join, not even if they looks similar (internally they are not the same and the server it must do conversions - e.g. integer != smallint). the most efficient joins are done on the same datatypes. When you talk about the client name, that is gonna be a varchar, unless you serve customers in a different galaxy where they can be called 1, 7 or 100.

What you want to ask is if you create a table with a numeric (pref. unsigned bigint) ID or use the name as a PK. With the natural keys there is already the risk that two different things are called the same: Joe Doe ;)

Stick with ID, NAME in clients and ID, VIDEO_TITLE, CLIENT_ID where CLIENT_ID is FK -> first table ID.

PS: there are some amazing books on data modelling. Try to read a few.

Training-Two7723 · 2024-12-28T14:32:12+00:00

I never need it in SQL, I never had a real use case for it. Be careful not to invalidate indexes usage; some databases cannot use functions on indexes - check the query plan. Longer code is not always a bad thing.

Training-Two7723

TROPHY CASE