This NEW DATABASE Has Lots of Features - GUI, TypeScript, Search, and More!
HTML-код
- Опубликовано: 13 сен 2024
- IT'S OUT OF PRIVATE BETA! I've been waiting to try Xata for months. I'm so excited to try it out. It feels like the perfect database to use with my Jamstack/Serverless applications. I LOVE being able to have a powerful database with a nice looking and easy to use GUI on top of it. In this video, I'll walk you through my favorite features of Xata and why you should consider using it in your next project.
** Sponsored by Xata **
Try Xata for FREE - xata.io/
Support Xata on Product Hunt - www.producthun...
STAY IN TOUCH 👋
Check out the Podcast - compressed.fm/
Newsletter 🗞 - www.jamesqquic...
Live streams on Twitch 🖥️ - / jamesqquick
Follow me on Twitter 🐦 - / jamesqquick
QUESTIONS...?
Join the Discord Server 💬 - / discord
Want to know what hardware and software I use? www.jamesqquic...
Warning! New databases should, in general, raise serious concerns when it comes to production usage. This is because is takes YEARS for even the largest companies with the most experienced developers and analysts to hone and refine and bugfix a database platform. Typically, the very first feature to suffer is performance, followed by dependability and then price. Powerful tools are wonderful, especially since they will tend to push established platforms to improve their own tooling and features. But tools mean nothing in the absence of dependability, and little in the absence of performance. So tread carefully before committing to a new platform. That being said, it's great to see new and creative thinking applied to DBs.
Couldn’t have said it better myself!
Just use Postgres.
The sentence you can parrot any time any day any situation and be right.
@Robert Mirabelle Don‘t kid yourself. Under the hood, it’s just Postgres, Redis or MongoDB. What you are buying in SaaS „Databases“ is simply a maintained graphical and SDK interface. That‘s it.
@dino slide
I believe you are correct. Especially when the OP said he hates doing then. The Excel mindset most front end developers have makes the data you are using much more insecure and harder to relate.
And the platform is also not in hardware you can control? Why don't you just give it to Google or Facebook directly. I'm sure your customers clients will be happy to know this private data isn't so private because it was sold. Guess the time it takes to spin up another instance looks better now
But… it’s built on postgresql and elasticsearch. Your comment makes it sound like they built a whole relational database from scratch. Obviously, it’s only as performant as the design allows. But it’s not a from-scratch database.
Wonderful!! Thank you so much for diving in
Yeahhh!! I'm excited about this. More videos coming next week!
You can get all of these nice to have features on an existing database with a few external tools without having to change your underlying database away from postgres,mysql, mongo DB or big table.
The important features of Price, performance, underlying data storage methods, And Reliability are completely skipped over.
When it comes to Implementing and maintaining performance and production websites these are the only things that truly matter. Everything else is an NPM package bolted on.
That's exactly what I thought. Prisma, for example, is great tool which brings a typed client, a GUI with Prisma studio and the schema file for editing and afterwards migrating.
TypeORM is another I've used recently. Very good orm with strong typescript integration.
Postgraphile will give you a full graphql integration to postgres backed DB.
So this is Postgres + Elastic Search. All wrapped in the xata-js-Client on the client side. Wich is for my taste a little to much of a vendor lock-in. Despite, they say Drizzel integration is coming. Also I wonder if features form their competitors (meilisearch, typsense ...)such as search-as-you-type are possible ? And how good is the performance ?
Thanks for this video :) Having used the Airtable's API with JavaScript, I'll definitely play with Xata. Looking forward to watching your next tutorial on Node / Express/ TypeScript / Xata.
Yeahhh!! It’s a lot better from a developer perspective I think!
Great Tool! Thanks for sharing this with the community.
Very welcome. I’m excited about it!
Certainly looks nice although no on prem/self-hosted option problematic in some sectors, also do they have non-US server options for GDPR compliance?
Its really cool actually. This gonna reduce the work on express js. This is gonna be a threat on MongoDB and Express. And I'm sure google/firebase or aws are gonna come up with somthing similar.
It’s pretty neat. Really excited to see what the future holds
Man I met those guys in Budapest at a conference and had the pleasure to test the platform earlier and it’s quite something
They are pretty awesome!
aw man, I am building something of this nature too! I am still validating the observability part and the realtime updates at the application level (multi user/session sync of the data). My approach fortunately is wildly different from Xata however, though the end result is the same. The approach is derived from my experience in building the product catalog for Oculus/Meta and FICO (the credit score), perhaps once it's in a demo able state, I could get your opinion?
PS: it's typescript all the way from front to back :)
Looks great but is it secured enough?
Secured in what sense?
I really wish they had a GraphQL endpoint for accessing this as well instead of their own proprietary client.
That would be a good feature request to put out there! It does have an endpoint you could call directly, so in theory you could put graphql in front of it yourself
I've used Strapi & DatoCMS to build data models. It's great to see improvements in searching capabilities & auto generating code for querying apiendpoints & a great UX experience when creating/updating different data types. VSCode integration with Xata looks amazing too! Cloning data between different environments has been a challenge, so copying data to different branches can save time/keep track of changes. I just want to quickly build a data model so I can spend more time building the frontend page.
As with autogeneration of api endpoints, I wonder what's the security like? Any obvious concerns?
But can it hold a billion rows of data and still query points in time within 0.002 seconds like MYSQL / Mongo?
Feature-wise, how does this database compare with MySQL/MariaDB?
Hey James I really love your videos. I'm sure you'll continue being a powerful resource on RUclips. A quick question please. You mention TypeScript a lot. From your perspective, is it beneficial mainly for the static typing and interfaces? Or are there some additional features that I haven't found yet? I'm really looking for a reason to adopt it. Thanks!
I think that’s the big thing but the implications of those are big. Code clarity, self documentation, more organized, etc. I highly recommend it!
@@JamesQQuick thanks man 🙋♂️
Tooling!!!!! IDEs are able to provide more functionality for strongly typed languages.
More autocomplete is always good.
@@oscarljimenez5717 Truth!
I am so excited about this database. I found out about it last week and it checks the box for plenty of things I was looking for in a DB of this kind for an app I am planning on building soon.
Yeahhhh love it :)
Looks like a great product - thank you for sharing 🙏
I'm certainly enjoying it!
Looking forward to your next video
Thank you! I'm excited for it to come out next week!!
Vendor lock crap 👍
Bahaha sure
I can't seem to create a multi-select Linked Field... It's linking one record, but not allowing multiple? 🤔
Hmm I don’t know right off hand. Want to try and ask in their discord?
At what all geo locations can we save spin up a db though?🤔
Cool. I'm currently watching SurealDB.
Oooh I haven't heard of that one!
sir can you give your thoughts on "The Odin Project" and is it enough to become a web developer?
Seen the SurrealDb?
Nope, haven't heard about it. Tell me more!
Thanks
I would choose nothing other than PostgreSQL if it has to be free, as there is no reason to use any other database. PostgreSQL is the only free SQL database that offers performance, stability, and scalability for big data (apart from commercial databases. Oracle, being the best, but is also expensive).
Love from Delhi, the capital of India.
I find databases very interesting.
Worked with MySQL, Postgres, Redis, Mongo, Cassandra, sqlite, proprietary ExtremeDB and many more.
Still interested in this new kid on the block.
Thanks for sharing!! Lots of really good options out there.
Again mine is the first view.. love from India
Nicely done!!
I wanna know more about it, specially about performance!
Maybe I can do a deeper dive in the future!
Very cool
Feels like surrealdb and pocketbase
Those are cool names. I haven't seen those products though.
i'm from Cambodia, thanks
Thanks for sharing! Glad you did!!
it screams vendor lockin
There are tradeoffs with every solution product. Yes, there is vendor lockin, but also other benefits that come along with it.
I just want something like this but to connect a sql database too.
u know nothin
You could try Prisma.
You should take a look at Directus.
I have. I’ve actually done a video on it :)
@@JamesQQuick Oh I missed that one!
Looks like aws aurora with a gui
Interesting
Try MS SQL Server
Ineresting product. The pricing on the other hand...
Strong free tier. Are you thinking you would break out of the free tier soon?
Some Brazilians could find that database a little bit "boring" (Xata or Chata [same pronunciation in portuguese brazilian] means "boring") lol
haha good to know!
Authorization seems weak on the client side.
How so?
Don't do it then... this is a database, not a server.
@@oscarljimenez5717 What do you mean don't do it? Don't do authorization?
@@JamesQQuick I mean don't do authorization in the client side if you want security.
@@oscarljimenez5717 well true authorization can't take place in the client side. The server side always has to be the source of truth for authorization. On the frontend, it would be used for user experience.
Looks kinda similar to AirTable
Yeah similar UI but more geared towards developers with the SDK I think!!
this trend in Frontend is creeping to backend now
looks and feels a lot like the no code db Xano!
Ayy I remember you talking about that!
I'm from India ( state: TamilNadu )
Welcome to the channel :)
It looks like hidden advertisement on product which just left beta. I am disappointed to watch such video.
How is it hidden advertisement? It's labeled as a sponsored video. Also a sponsor product I am excited to talk about.
@@JamesQQuick I am sorry, I didn't see it was sponsored. Indeed, where is marking it was sponsored?
@@omnizsk In the description as well as a 00:45 in a text callout.
warning!! this is obviously paid review
And it is labeled appropriately to explicitly state that. There's no hidden agenda here. It also happens to be a product I am genuinely excited about!
Smells like vendor lock-in 👎
There are trade offs with everything
@@JamesQQuick You‘re right. Still an interesting service. I like the unit scaling strategy in their pricing.
Seriously, another DB? there are plenty of good ones out there already, SQL Server, Oracle, MySql, MariaDB, PostgresSQL, etc etc.. I'll pass, but you guys and gals can jump on the bandwagon 😴😴
Jumping on the bandwagon now!!
I know it’s the hip thing foe developers to use a dark theme for the IDE (and everything else), but really if you are going to be demoing stuff and showing your screens in a video, ditch the dark theme. It is very difficult to see, especially if you don’t have good contrasting colors. I mean black black background with blue text?
Just a suggestion.
I was interested in what you had to say about Zeta, but just had to stop watching. Too much work.
Fair enough. Thanks for the feedback!
@@JamesQQuick For what it's worth, I disagree. I don't like burning my eyeballs on youtube any more than I do while coding. Thanks for keeping it dark!
Why on earth would i want to use this and pay when MySQL. Mariadb and Postgres is totally free, unlimited and easy to use and PROVEN?? My advise is to dump this. If we have to pay, i would rather go for SQLSERVER or Oracle depending on affordability. Frankly, this is another rubbish from people who may have nothing to do. I may be sarcastic but I just about had enough of this crap )and the likes of Strapi) thrown into the IT world and no one delivers business solutions that works properly. Bro, my advise to you is to get more video courses on things like vuejs, nuxt etc with full details. These frameworks are good but deliver crappy documentation written for "Greeks or Geeks". Until now these frameworks have not delivered one documentation of how to deploy on VPS shared services/host using linux or centos.
Wow, very opinionated. It may not make sense for you. If you're comfortable with the tools you have, no one is forcing your hand :)
For freealncers with clients who want to see their data these options are quite useful to provide them with a GUI, especially if they are used to something like Google sheets etc. Howver, I do agree with you re the documentation for frameworks like Nuxt and Vue. I love both but the docs are not great at explaining concepts.
@@JamesQQuick Opinionated? Frankly, its a term created to brand some truth and a term that is extensively abused by people. If i dont agree with you, i become "opinionated" not the truth in it. Anyway, its not about making sense, its about confusing the industry and business solution developers. Do you really know the hell solution developers go through to get jobs done? One of reasons is simply web developments software have lost their sense of direction. Its become more of a "show-off" for software developers. Middleware like Prisma makes sense as it makes life easier to access databases from within frameworks. This one is really rubbish.
@@truthteachers You're just expressing your very one dimensional opinion. Again, if it doesn't make sense for you, no one is forcing your hand. Phrases like "this is another rubbish from people who may have nothing to do" aren't very inclusive and are 100% opinionated. So glad that you took the time to watch the video and share your thoughts though :)
hope to have a compare with Prisma.i o
It has similar functionality with its TypeScript code generation. In general though, Prisma works with lots of databases. Xata is the database and the code generation tied together!