SQlite's date type is very primitive and requires a heap of extra work when manipulation dates and time. And it does not support user defined functions so you cannot even write your own date handling functions to get over SQlite's lack of native date / time functions so thatalone would remove it from my DB short list.
@GringoDotDev27 күн бұрын
I’ve learned more about SQLite since recording this video. I agree with you. Alter table statements are also a huge problem. Probably time to do an update.
@erwandurand5001Ай бұрын
I found this video interesting at first and would have like to finish watching it but found chewing gum very off putting.
@ZzZzZzZz-z4sАй бұрын
livewire no me funciona al querer implementar en mi sistema la navegation sin reload :( al hacerlo me daña todos mis js y librerias en mi dashboard
@ZzZzZzZz-z4sАй бұрын
Livewire me da error :( con respecto a wire:navigate pues al parecer funciona pero me deshabilita todo mis js en mi dashboard
@kvelez2 ай бұрын
Interesting.
@GringoDotDev26 күн бұрын
Thank you!
@igitonga2 ай бұрын
Thanks this was really helpful but i have a problem, after successful deployment all i see is a white blank screen. My app is using react scaffold for frontend.
@shixzie2 ай бұрын
stop eating/chewing while you record!
@RT-mn2pb2 ай бұрын
Good discussion, especially the point about use what you know, what you already have, or can find expertise in. BUT, one important point is missing, that is, it's a limited perspective in an institutional environment. In the corporate or government world, the most used SQL DB's are: Oracle, MS SQL Server, or IBM DB2.
@GringoDotDev2 ай бұрын
Yup, that's completely right!
@juaninfante70002 ай бұрын
Agree 100% that's why I moved to spring boot
@GringoDotDev2 ай бұрын
Yeah! Spring Boot seems great, I wish I knew more about it. How are you finding it so far?
@raiyansarker3 ай бұрын
whats wrong with authjs or lucia. your reason is so stupid, php doesn't have any auth package, laravel has. this is not the question for first party or third party package. adonis has auth built it. talking about hot things, those are still heavily being used. you see the downloads and you would know. drizzle for me is an upgrade as how it handles things, unlike elequent which is the same for all these years, sometimes changes also mean improvement. there are currently 8 vulnerabilities reported in php itself. php developers usually get pride in saying a big portion of website on the internet runs on php and php isn't the same as it used to be, but they fail to say the percentage of those php website that uses wordpress and how 15% and 54% of php websites still in v5 and v7 respectively according to w3techs. I myself started from php and I know how the language is, how the architecture is so inefficient. But it bothers me when people trash on nodejs for such silly reasons like there is no auth package and they ignore things like lucia. having everything built in where you don't have to write at least minimal code is not good, I know a lot of "laravel" developers that doesn't know how auth even works, they only know to run a command.
@GringoDotDev3 ай бұрын
Beware the kool-aid, my friend. Good day and good luck.
@raiyansarker3 ай бұрын
@@GringoDotDev what?? 🫠
@DolphLongedgreens3 ай бұрын
Where to start? The ecosystem is a mess. Even when you limit it to the frontend where it belongs, the latest garbage fails in the least graceful way. NextJS: "A client-side application error occurred" Give me something sane. Prefer Java or Rust on the backend. Typescript is just more duct tape over a bad design. You have to use some JS in the browser, but it shouldn't break your project. Most of the functionality you need is provided by the browser API. Rely upon that instead of some insane SPA framework. We're at a point where jr. webdevs don't know basic HTML.
@GringoDotDev3 ай бұрын
Preach!!
@srikarakella79553 ай бұрын
Perfectly articulated man!!! This is the reason why I am moving to something more stable like SpringBoot or Go. I started working with Express a month ago and found out every single tutorial is either outdated or in fact I could not find any latest express tutorials that solved some problems, rather youtube/medium is filled with Next.js, Nextjs doesnt have as many openings as Express. Then comes typescript integration, every single module has to be in types and few middleware do not compile as the type is not recognized. Javascript was better than Typescript in Express. In fact, people now are saying Express and Passport.js are kinda outdated and suggest to pick something else. There is not a single architecture or approach or in fact a library for auth or a library for REST API at this point, every day something is brought new and the old ones are constantly marked outdated.
@GringoDotDev3 ай бұрын
Completely correct! Here today, gone tomorrow in that ecosystem.
@gregmakowski3 ай бұрын
As a data scientist, I am looking for ACCURACY comparisons on how FUZZY the nearest neighbors match is to the correct answer, or inaccurate some indexes may be.
@utsavtalwar94763 ай бұрын
MongoDB also has a vector search now!
@MrBrady954 ай бұрын
"The JS ecosystem moves so fast that it can't form a foundation." Exactly what I notice.
@GringoDotDev4 ай бұрын
Yup. :)
@jodaluca4 ай бұрын
el sitio web esta caido ??
@pmrebel27334 ай бұрын
You speak the truth man, this generation devs are so in love with complexity. Js is not great for backend
@GringoDotDev4 ай бұрын
I agree!
@josephp.33414 ай бұрын
Go > node
@GringoDotDev4 ай бұрын
You’re not wrong lol
@cmdaltctr4 ай бұрын
Love this video - i'm a junior in the programming world, and your videos are like listening to a senior dev advise on what to be aware of ahead! So what I get from this video, I have a vanilla JS proficiency, where enough to help me build interactions on my website. I should learn Node.js for small projects or microservices, but If I'm thinking long term to create a product that do not depend much on outdated dependecies, I should look for more mature ecosystem like Laravel for example. But that would require me to learn PHP (which I know a little). Did I get this right?
@GringoDotDev4 ай бұрын
Thank you! And yes, that’s a good summary of my views. Broadly speaking, if your goal is to build a successful business, you will be much better served by a mature full-stack framework than a ragtag collection of v0.x node libraries where the burden of integration is effectively all on you. Laravel is my personal favorite but Rails is a close second. People have done great things with Django as well, although I feel it’s gone a bit stagnant the last few years. Thanks for watching!
@gearboxworks4 ай бұрын
I view that 2050 claim with some skepticism. From what I understand the SQLite team(or is it one person?) does not accept contributions from outside the team and given that, will the committers still be around to maintain SQLite 26 years from now?
@GringoDotDev4 ай бұрын
Fair point!
@LeonC07045 ай бұрын
I was looking for videos on insights on how to choose a database and difference between the SQLs RDBMS and this was it. Great explanation, man
@GringoDotDev4 ай бұрын
Thank you!!
@nicolasmenescardi40775 ай бұрын
great stuff! Wonder how to integrate Jetstream with FilamentPHP multitenancy
@GringoDotDev5 ай бұрын
Glad you liked it! Haven't tried, but I think you could make them work together by configuring Filament tenancy to read/write on the same tenant columns (which is something like `team_id` and `user`.`current_team_id` for Jetstream).
@nicolasmenescardi40775 ай бұрын
@@GringoDotDev thanks man! 🙌
@TimescaleDB5 ай бұрын
Great video!
@GringoDotDev5 ай бұрын
Thank you! Great OLAP data store 😉
@thisbridgehascables6 ай бұрын
I don’t blame planetscale for the decision. I used the free tier as basically a testing remote db. I might actually use the regular plan at 30+.. in the future for a bigger project if they become stable and reliable into the future.
@GringoDotDev5 ай бұрын
Yeah, there’s a lot of value in managed vitess
@programmertelo6 ай бұрын
Amazing content, must try it
@GringoDotDev5 ай бұрын
Thank you!
@SaiyanJin856 ай бұрын
They fired Aaron? He’s the reason I know planetscale, they must really messed up with their depts
@GringoDotDev6 ай бұрын
Yeah Aaron strikes me as one of those people you just find a place for regardless of what’s happening in a macro sense. So much talent.
@kenny-code6 ай бұрын
Thanks a bunch - been running through your content. There's not much in the space of practical/down-to-eartch advice in the youtube space.
@GringoDotDev6 ай бұрын
Glad it was helpful!
@mattclarke76 ай бұрын
This move made me stop and think about what I was doing. I think I was learning on these services for a convenient developer experience because I do not really need global/infinite scale capabilities. I ended up dropping PlanetScale and Vercel completely and moved everything to a single Linode 4GB Dedicated VPS. I built my own multi-environment CI/CD with GitHub Actions and Docker. I use Cloudflare's "Zero Trust Access" product to protect access to the dev/staging deployments and the database is now running locally on the same host as the app. My application is now faster for my customers and it is cheaper for me!
@GringoDotDev6 ай бұрын
Yup! All my apps start life as single node deployments as well. It’s crazy how performant everything is when it’s all on the same server. People also forget that you can scale to billions of records in a modern relational DB before you need to shard.
@brainites6 ай бұрын
Most applications don't need those assumed scale on expensive cloud providers. I have been saying this for years and have been leading migrations from expensive cloud to VPSes and CEOs get amazed at the cost saved. When the economic downturn started, reality struck for some CEOs who didn't buy the idea of migration.
@libradohernandez23396 ай бұрын
Good take! 👍 saludos
@GringoDotDev6 ай бұрын
Gracias amigo!
@jonlemmon27186 ай бұрын
By far the best comparison between the two services I've seen anywhere on the internet. Thank you so much!!
@GringoDotDev6 ай бұрын
Thank you for such a nice comment!
@BradleyCulbertson7 ай бұрын
Jet Stream looks awesome, but I I'm a little confused for SaaS, as those core features are not included. Maybe show us how you could easily adapt this for Saas. There are just a handful of other packages that already have the multi-tenacny and payments, having the frontend would be nice though.
@GringoDotDev7 ай бұрын
Just add Laravel cashier (another first-party open source package) and along with the teams, MFA, API tokens, etc. with Jetstream I think you're set up pretty well for most SaaS scenarios.
@Jason-eo7xo7 ай бұрын
thanks. to the point without the ads and other bullshit. much appreciated.
@GringoDotDev7 ай бұрын
My pleasure man. Thanks!
@elcio-dalosto7 ай бұрын
Really nice content, I learned a lot with this video! But man, just don't chew like that while recording, please(or edit that before you post). I lost my focus a lot of times because of that. Anyway, success to the channel, you got a new subscriber.
@GringoDotDev7 ай бұрын
Thank you! Totally agree with you and thanks for the feedback
@tarilonte7 ай бұрын
Just a feedback: the audio is kinda hard to understand. I'm into the content but the audio quality may be better.
@GringoDotDev7 ай бұрын
Thank you! Yeah audio quality on my early videos was awful, I’ve been trying to improve
@Mica-sf9ud8 ай бұрын
Nice ! I was looking specifically for Redis vs PGVector for my vector DB and your explanation made perfect sense!
@GringoDotDev7 ай бұрын
Thank you!
@TechArtRoom8 ай бұрын
The biggest difference is the licensing models. If you distribute MySQL in a commercial product, you have to either make your entire project open source or purchase a a commercial license.
@GringoDotDev8 ай бұрын
Sure, but I don’t think it’s a super important distinction in practice. In cases where you use MySQL as your database for a web app, you won’t be distributing the binary and the licensing provision won’t apply. And in cases where you would distribute a binary (eg embedded environments) SQLite is almost always the go to option anyway, for reasons unrelated to licensing.
@TechArtRoom8 ай бұрын
@@GringoDotDev General consumer B2C websites - yes. B2B has numerous cases where they want an on-premise enterprise installs. ( eg. medical, large corps, finance, enterprise software) such as examples are Jira or Salesforce. In such cases, commercial license of MySQL would be required if its used. That''s often why other DBs are chosen in these cases because they have a more lenient distribution model.
@RockTheCage559 ай бұрын
Feature wise both would work for me. I was testing the free tiers tonight and planetscale took about times to return results to me +100ms. Mostly 150ms+) compared to 30-40ms for the other two contenders: neon & cockroachdb. I’m in the Midwest & setup all services in the Midwest. Would you base your decision on that or do u think it might or screwed since it’s the free tier?
@GringoDotDev9 ай бұрын
I'm not aware of any latency differences by plan for Planetscale. One thing to double-check would be that your region is on AWS if you're using AWS or GCP if on GCP. Crossing data centers could definitely add some lag even in the same region. Not sure if you've seen it but they have some docs on it here: planetscale.com/docs/concepts/network-latency Since the options are functionally equivalent for you, I would next assemble a price curve for each based on some reasonable assumptions and map out how I expected each option to scale over the next couple of years. If that too is a draw, then yeah, latency is a perfectly valid basis to make a decision. Closing thought (which applies to all options) is that you can get pretty far with putting most of your reads behind a short-term Redis cache for really low latency. For a lot of use cases, fast reads and slower writes is perfectly fine.
@streetboyback9 ай бұрын
Those who sell their courses on KZbin generally don’t discuss these things.
@GringoDotDev9 ай бұрын
For sure! I got tired of creators shilling for sponsors / courses / etc. and started the channel to just get (my view) of the unbiased truth out there. I hope it's helpful!
@streetboyback9 ай бұрын
@@GringoDotDev I have started learning about web development from past 3 months. I watched your other video about why nodejs should not be used. That was an eye opener for me. I have gone through dozens of videos and courses and no one has talked about it in the way you said. I started with nodejs and expressjs as framework, and believe me from past 1 month I am just setting up the environment, framework and libraries. Sometimes it is a compatibility issue, version issues, libraries get deprecated. The problem is most of the front end developers are creating the courses and tutorials, they know javascript and typescript and they push for it in the backend as well.
@GringoDotDev9 ай бұрын
@@streetboyback you're not alone! I agree that junior frontend devs moving to backend is driving a *lot* of the conversation and churn around node.js. Which is fine, I just really hope they keep an open mind to other ecosystems as they mature. I also think there's a really corrosive influence from channel / creator sponsorships, especially Vercel. Keep with it though! As bad as the current job market and learning materials are, I think it's the perfect time to continue upgrading your skills so you're ready for the next boom. I'll do my best to guide you along the way. Thanks for watching!
@birsingh53889 ай бұрын
Subscribed 😊
@GringoDotDev9 ай бұрын
Thank you!
@adambechtold67419 ай бұрын
Great video! I especially appreciated the way you clearly distinguished between what was a cold hard fact (e.g. supported data types) and what was a professional opinion that others might disagree with (e.g. NoSQL will burn you enough to mostly disregard it and focus on relational DBs). That's such a helpful way to share your experience and earned wisdom without creating confusion.
@GringoDotDev9 ай бұрын
Thanks so much, Adam! It's really nice to hear that it was helpful. I'm still really flattered that people listen to what I have to say!
@yjawhar9 ай бұрын
Great video! It would have been nice to include the link to the article!
@GringoDotDev9 ай бұрын
great point! I've added a link in the video description
@yjawhar9 ай бұрын
@@GringoDotDev thanks!
@abdelhaibouaicha32939 ай бұрын
📝 Summary of Key Points: 📌 Continuous integration involves running automated tests continuously as part of the software development process. GitHub Actions allows tests to be run whenever code is checked in or a pull request is opened. If all tests pass, the code can be deployed to the production environment. 🧐 Continuous integration allows for faster development and better quality assurance compared to the traditional approach of having a separate QA team and a complex release process. 🚀 Tests are essential for ensuring the functionality and stability of the application. Developers are encouraged to have at least a basic test suite to verify the core features of the application. 📌 The video demonstrates a GitHub Action created for a Laravel project called "The Stoic Developer." The job definition in the YAML file includes setting up the environment, installing dependencies, running tests, and deploying the code. 🧐 The speaker mentions the use of a tool called "act" to run GitHub Actions locally for easier development and testing. 🚀 Railway, a deployment platform, can be configured to gate the release of code based on the successful passing of tests. Railway will only deploy the code if all the actions defined in the GitHub workflow pass. 💡 Additional Insights and Observations: 💬 "Continuous integration allows for faster development and better quality assurance." 📊 No specific data or statistics were mentioned in the video. 🌐 GitHub Actions and Railway are valuable tools for implementing continuous integration and deployment in a Laravel project. 📣 Concluding Remarks: The video highlights the importance of continuous integration and demonstrates how to implement it using GitHub Actions in a Laravel context. It emphasizes the benefits of continuous integration, such as faster development and better quality assurance. The speaker also emphasizes the importance of testing and provides a practical example of setting up a GitHub Action for a Laravel project. Overall, the video provides valuable insights and guidance for developers looking to implement continuous integration and deployment in their projects. Made with Talkbud
@CodewithEmris9 ай бұрын
thank you for this video. it was really helpful. but i ve been having this error: ERROR: failed to solve: process "/bin/bash -ol pipefail -c ./deploy.sh" did not complete successfully: exit code: 126 Error: Docker build failed
@GringoDotDev9 ай бұрын
I’m glad you liked it! Have you run ‘chmod +x deploy.sh’? Without seeing the full trace my guess would be a lack of executable permission on the file
@isamlambert9 ай бұрын
Really enjoyed this video! Subscribed.
@GringoDotDev9 ай бұрын
Thanks, Sam! I'm a huge fan of your work, that means a lot coming from you.
@thebenkalungi9 ай бұрын
Are you using Prisma?
@GringoDotDev9 ай бұрын
I don’t use prisma but just did a quick check and it doesn’t seem to have first class support for geospatial queries. I imagine you could just write a raw query along the lines of what you see in the video however.
@oliviarojas702310 ай бұрын
Also I can't see some words that well in high quality mode 🎉
@GringoDotDev9 ай бұрын
Thanks for letting me know! I did my most recent video in 4K, let me know if it’s better
@RolandAyala10 ай бұрын
Great analysis. Thank you. I've been evaluating both (Neon, PlanetScale). I like that Neon is based on Postgres, but really dislike the coldstart times (even as of Nov 2023, seeing at bad as 10 sec). Neon keeps blogging about how they're addressing and are now sub second, but I'm just not seeing it (and running out of Ohio, which is supposedly their best control plane), so this has become trust issue for me. A solution is to just not let the instance suspend, but then quite a bit more expensive and, again, the trust thing. PlanetScale on the other hand just works and performs flawlessly. For these reasons, I'm leaning towards PlanetScale.
@GringoDotDev10 ай бұрын
Planetscale is a great option indeed! Having used them in production for a while I have nothing but good things to say. Fingers crossed they're able to navigate the current funk with Oracle and grow into a bigger stewardship role for MySQL.
@abellosimon10 ай бұрын
Excellente video.
@GringoDotDev10 ай бұрын
Gracias amigo! Si te interesa tengo planes de grabar esto de nuevo en español y pensamientos más actualizados
@LeonC07045 ай бұрын
@@GringoDotDev Genial, en el mismo canal o tienes otro?
@yepyep389710 ай бұрын
00:46: *randomly taps on the table, while looking away and prerecorded words appear on the screen, to look professional*
@GringoDotDev10 ай бұрын
probably the best performance review I've ever received!!
@KingSemajCHI10 ай бұрын
Useful but constructive criticism…maybe not chew gum on your next video 😂
@GringoDotDev10 ай бұрын
Hahaha duly noted!
@jofofouj10 ай бұрын
+1 to this. Love the info and how it was presented. Don't like the chewing noises.
@GringoDotDev10 ай бұрын
@@jofofouj thank you for the feedback!
@sarthakshah67614 ай бұрын
+1 😂
@therealbfg1234 ай бұрын
Great video, couldn't finish because of the chewing with my headphones on.