Thank you so much for this video. Really high quliaty and direct to the point. Learned a lot!
@PlanetScale7 күн бұрын
Glad you got a lot out of it.
@bevedel10 күн бұрын
AWESOME! thank you
@عليالعصفوري-ط4ض12 күн бұрын
Is there a quey return data like [posts => [ Post=> 'hello', User => [ Id=>6, Name=>'jack' ]] as this
@TheErickds14 күн бұрын
maan! I just found this youtube channel, and I can say these 2 words about its content: Quality and Practicality!
@PlanetScale14 күн бұрын
Thank you! Appreciate it.
@Smit-SundaramTech15 күн бұрын
MySQL returning same select query result from buffer, where there is update query parallelly executing from client application, how to prevent this, so i can get updated result from mysql?
@PlanetScale15 күн бұрын
Is the update and the select queries happening in a single transaction, or two separate ones? If the same, then just ensure you runt he update before the select. If the latter, you should ensure that the update transaction completed before you try to select the new data. If you are using PlanetScale (or something similar) and are updating on the primary and then selecting on a replica, there can be replica lag. In this case, you'd either have to live with it, or make both requests to your primary.
@Smit-SundaramTech14 күн бұрын
@@PlanetScale I have multiple client connected with same DB table where counter field is getting updated first and then select query is being executed to get updated value, each client needs updated value but randomly on client PC I receiving old field value instead of updated one and when i fire query again in few seconds immediately its giving me updated value. How i can prevent this?
@SazianNULL15 күн бұрын
Ok, but what if i some time need case sensitive and some time not?
@kasir-barati18 күн бұрын
One more issue, id is most of the times uuid
@AnselmaRiemer19 күн бұрын
I really appreciate your efforts! Could you help me with something unrelated: I have a SafePal wallet with USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). What's the best way to send them to Binance?
@HollyGuevaraPS21 күн бұрын
If you're confused about what happens to the exercises table that I mentioned we'd want to move to the sharded keyspace, it's because I only address it in the "Avoiding cross-shard queries" video (my bad!). Because it's hard/impossible to find a Vindex that guarantees all rows for a users exercises and exercise logs are on the same shard, we're actually going to utilize Vitess reference tables for that one. It allows you to make a copy of the table on every shard. This is a great option for smaller relatively static tables, such as exercises.
@ElevateCode21 күн бұрын
I was trying to google how to pronounce paginate when I clicked on this LOL
@ahmad-murery21 күн бұрын
Nice. I wonder what exercise made Lily feel great?
@HollyGuevaraPS21 күн бұрын
Just checked the exercises table. Looks like she was doing conventional deadlifts! Lily is my dog so I guess that's pretty impressive :D
@ahmad-murery21 күн бұрын
@@HollyGuevaraPS great, we'll have another Anatoly soon (if you know what I'm referring to 😁)
@HollyGuevaraPS21 күн бұрын
@@ahmad-murery hahah she's got a sleeper build for sure!
@ahmad-murery21 күн бұрын
@@HollyGuevaraPS 😎
@HollyGuevaraPS21 күн бұрын
Free database hat to the first person to timestamp when you hear my toddler screaming in the background! 😭
@ahmad-murery21 күн бұрын
14:42 - 14:44
@ahmad-murery20 күн бұрын
Hello once again Holly, I just wanted to let you know that I haven't received my "Free database hat" yet. I hope it's not due to bad weather 🤔😁 Just kidding, anyway, a digital form (of the hat) is accepted
@PlanetScale17 күн бұрын
@@ahmad-murery Wow I just noticed YT held back my original response from my personal account 😭 email me [email protected]!
@ahmad-murery17 күн бұрын
@@PlanetScale YT algos are weird sometimes Sent you an email, please check
@leonardoisaiasmezanunez559824 күн бұрын
Thanks for the video.
@gnatinatorАй бұрын
The update videos are really nice.
@samgraham6355Ай бұрын
First
@tomasprochazka6198Ай бұрын
Postgres for everything
@mihailborovikАй бұрын
🎉🎉🎉❤❤❤
@ahmad-mureryАй бұрын
The first time I dealt with embedding was to build an app that allows you to chat with documents, I struggled to to get the results/answers properly formatted. Now, It seems easier for me to understand what's going on and I should revisit my code. Thanks Ben!
@PlanetScaleАй бұрын
Awesome! What vector DB were you using for this project?
@ahmad-mureryАй бұрын
@@PlanetScale I think it was chroma vector store
@PlanetScaleАй бұрын
@@ahmad-murery Cool!
@MikeCoutermarshАй бұрын
great teacher
@VV-xd2cvАй бұрын
Very Good Explaination
@sheldon98cАй бұрын
I never read about vector embedding but you explained the basics very easily.
@PlanetScaleАй бұрын
I'm glad you learned something!
@romanwbruceАй бұрын
great video !
@ahmad-mureryАй бұрын
I was a bit confused when I first read about Vector Embedding, now it's a little clearer. It's really funny how the most important point often comes in the next video. Thanks Ben!
@PlanetScaleАй бұрын
You are welcome! Appreciate your comments, and yes, stay tuned for a walkthrough of how to use it with PS.
@simbiatАй бұрын
Images not fitting into squares was just... aaaaaaaaa
@AbhishekPrajapati-b1eАй бұрын
Beautifully explained! I really appreciate it
@amrsaber5457Ай бұрын
What's that app he uses for the database?
@MD-mp7zmАй бұрын
Amazing video, Is it possible to handle datetime ragnes based on timezone. Timezones are my nightmare these days.
@s8x.Ай бұрын
great video. learning from youtube is amazing BUT its all about finding the right video. this one has 58k views. should be way higher
@ukraineincolor2 ай бұрын
So when?
@Liam696962 ай бұрын
Which work bench are you using???
@bytestarter2 ай бұрын
what about joinning?
@Sergey-jq5kz2 ай бұрын
Unsigned int is perfekt
@anandhunt10002 ай бұрын
pgadmin is best for postgresql
@vvsiva0072 ай бұрын
So, by 2038, it will be YourSQL, no more mySQL 😂
@raghu87052 ай бұрын
Hey planetscale, Thanks for the vitess mysq series. If there is any document which are still basic, would be helpful
@PlanetScale2 ай бұрын
Are you referring to our Learn Vitess or MySQL for Developers? Those can both be found here: planetscale.com/learn/courses/vitess planetscale.com/learn/courses/mysql-for-developers Are you looking for an additional resource to learn more than these provide?
@raghu87052 ай бұрын
@@PlanetScale yes, Im looking for resources more than this. The above resources uses vitess /mysql examples. Would be great if I get any docs or videos where they even write those example scripts, explanations of them,.
@PlanetScale2 ай бұрын
@@raghu8705 For Vitess, here's a few resources you can try: The official docs: vitess.io/docs/ Our Vitess page: planetscale.com/vitess (also has links to other pages with more info) You can search around for Vitess on youtube, and there's a number of conference talks. For example: kzbin.info/www/bejne/fmWlZq2Cd8t6hJo
@fabiojonathanarifin12 ай бұрын
a very easy to understand explanation! thank you
@Runval27012 ай бұрын
6:09 not understand ? somebody can explain how does select count(1) from todos will execute or work ?
@kqvanity2 ай бұрын
Come in just about time. I wanted to obtain the rows count before, and my approach was to get the ids of the last few rows haha
@kqvanity2 ай бұрын
Your style of teaching is very unique!
@mingxiu-ee6px3 ай бұрын
I am learning to use vitess, which is very helpful to us.
@mnouman15523 ай бұрын
Could you please explain what do you mean by "Scrolling and Throwing away that offset data". I believe you are talking at memory level things. It would be so helpful if you explain and show how pagination works at disk level,how pagination queries select data from disk partitiones stored in Binary tree format.
@vineetdev20093 ай бұрын
How to do join operations after vertical sharding?
@PlanetScale3 ай бұрын
You're probably referring to cross-shard (or cross-keyspace) queries. There's a blog post from Square that talks about these with Vitess that you might find interesting: developer.squareup.com/blog/cross-shard-queries-lookup-tables/
@vanshsharma45283 ай бұрын
how do we get the hostname
@PlanetScale3 ай бұрын
What database are you looking for the hostname for? Your PlanetScale database? One elsewhere? If you are currently trying to import a DB into PlanetScale, I recommend opening a support ticket: planetscale.com/contact
@Sweetironman3 ай бұрын
I have a question for you. I'm working with a table which has more than 3 billion rows and each month new 20-25 million rows are being added. And we have created 5 indexes for all efficient searching but when we access data for even a month it takes too long. And the recent data of the week access is good, the data is loaded fast ( here we also just access recent data for that month) but when our recent record touches more than 3-4 million rows after 4-5 days the quary again becomes very very slow? I'm thinking of creating a separate table for each year for balancing the load but I'm not able to understand why for 4-5 day of the start of the month it's working good but then after 4-5 million new rows it's becomes slow again. It's not making sense to me? Any suggestions will be really appreciated.
@PlanetScale3 ай бұрын
Interesting scenario! Hard to say for sure without more details, but a few things could be happening here: (1) The queries fetching only recent results are able to mostly hit data that is already in memory. The ones that fetch larger and older data sets might have significantly more I/O, leading to drastically slower query times. (2) You said you created 5 indexes ... are you confident they are being used appropriately? If you are using planetscale you can use Insights to figure this out. If not, you can try running some EXPLAINs to see whats going on. You might find this useful for investigating: planetscale.com/blog/identifying-and-profiling-problematic-mysql-queries
@raghu87053 ай бұрын
Hey, thanks for the walkthrough. Those anomalies detects similar latency issues. What’s different between the sort option in ran query table vs anomalies? Also does the anomalies detects some SQLi or any of similar things?
@PlanetScale3 ай бұрын
In short, anomalies happen when there is a spike in queries executing *slower* than the 97.7th percentile for the query pattern. A query could have long latency but not trigger an anomaly (for example, if that query typically takes a long time). You can read more about anomalies here: planetscale.com/docs/concepts/anomalies
@raghu87053 ай бұрын
@@PlanetScale but this can be seen inside the query table sort latency feature right?
@HollyGuevaraPS3 ай бұрын
@@raghu8705 Yeah! You would see evidence of an anomaly in that tab as well. BUT not all query latency necessarily is an anomaly. When we call something an Anomaly, we are basically saying your database is not healthy. There's something abnormal going on that you should look into. Versus if you're looking through the query latency metrics in that Insights table, there may be some high query latency that yes may not be great, but it's not unusual and doesn't mean there's an issue with your database.
@jizhang753 ай бұрын
you video tutorial has been always informative, and instructive, really really appriciate