Just a heads up: the real, open-source Anki app is at apps.ankiweb.net/ The URL mentioned in the video is for a shady company that tries to trick people into thinking that it's the original.
Second that. I hope James can expand on this awesome piece of technology. Like subscriptions and show how to implement instead of JWT express-sessions with a separate table for storing the session ids
This tutorial is absolutely stellar! It's my new gold standard for how to balance covering a lot of content in an accessible and non-overwhelming manner. Thank you so much for putting it together!
I have been using Postgraphile for on a project for several months now. We switched from TypeORM & TypeGraphql. I like Postgraphile a lot more than trying to use those libraries. For the most part it's been pretty nice to work with and reliable. Probably wouldn't choose it for every single project, but I'd say overall I like it.
I'm amazed and frightened by this at the same time. All the complex things that can be done using just SQL and Postgres. And at the same time, unless someone really knows these tools, it would take them a lot more more time to build such app with them. That's why web frameworks coupled with ORMs exist anyway. I don't see myself using this anytime soon. But really great job!
Fantastic work! Keen to try this out. The smart tags defining access control are nasty though... surely there's a better way, like native postgres row level security?
hey do you know how to query say to id, for example in table names i want only John and Alice. Since condtion in postgraphile only takes one value i can only get john or alice. Anyone knows how to do this?
Very nice tutorial. I am trying to access a Heroku Postgres DB. First i created a schema using pgadmin. Then i am stuck with "db-migrate up: to create a table. database.json file : { "dev": { "driver": "pg", "host": "my host", "port": "", "database": "my database", "username": "my username", "password": "my password", "ssl": "true" } } migration file: CREATE TABLE tawag.person( id serial PRIMARY KEY, first_name text NOT NULL, last_name text NOT NULL, created_at timestamptz DEFAULT now() ); Need help to get through this hurdle.. Thanks again for your great tutorial.
Great tutorial, thank you! It's pretty cool that PostGrahile can get a GraphQL server up and running from a Postgres database so easily. As soon as requirements get complicated though, you're now programming in the database. So while this may be attractive for db admins, as a developer, I'd rather build logic inside of a web application. I can see myself using PostGraphile for pet projects and demos, but not for anything serious in production. All in all, neat stuff!
What I like about your tutorials is that besides all the technical stuff you share some actual useful life skills stuff along the way like Spaced repetition or Pareto principle. Bravo and keep it up! Thank you
I can't believe this is free. It's just that good!
Just a heads up: the real, open-source Anki app is at apps.ankiweb.net/ The URL mentioned in the video is for a shady company that tries to trick people into thinking that it's the original.
Very Good.. any plans on full course in postgraphile ?
Second that. I hope James can expand on this awesome piece of technology. Like subscriptions and show how to implement instead of JWT express-sessions with a separate table for storing the session ids
Very well-put together, informative and helpful. Thank you!
This tutorial is absolutely stellar! It's my new gold standard for how to balance covering a lot of content in an accessible and non-overwhelming manner. Thank you so much for putting it together!
This is exceptionally high quality stuff!
I have been using Postgraphile for on a project for several months now. We switched from TypeORM & TypeGraphql. I like Postgraphile a lot more than trying to use those libraries. For the most part it's been pretty nice to work with and reliable. Probably wouldn't choose it for every single project, but I'd say overall I like it.
same here. The only things that stops me from going all the way in is issues with implementing subscriptions and express session
One of the best tutorials in this form factor that I've seen. No distractions, quite advanced stuff but yet not boring at all
This video is so professionally overproduced! But thank you!
someone pinch me
I'm amazed and frightened by this at the same time. All the complex things that can be done using just SQL and Postgres. And at the same time, unless someone really knows these tools, it would take them a lot more more time to build such app with them. That's why web frameworks coupled with ORMs exist anyway. I don't see myself using this anytime soon. But really great job!
This is a great course, also because postgraphile is an excellent piece of software and bridge between SQL and GraphQL
Thank you for the tutorial! Could you please show how to use subscriptions based on this video?
excellent
Awesome
very informative!
Fantastic work! Keen to try this out. The smart tags defining access control are nasty though... surely there's a better way, like native postgres row level security?
Yep, in the official documentation you have a full exemple using Row Level Security (www.graphile.org/postgraphile/postgresql-schema-design/)
hey do you know how to query say to id, for example in table names i want only John and Alice. Since condtion in postgraphile only takes one value i can only get john or alice. Anyone knows how to do this?
Very nice tutorial. I am trying to access a Heroku Postgres DB. First i created a schema using pgadmin. Then i am stuck with "db-migrate up: to create a table.
database.json file :
{
"dev": {
"driver": "pg",
"host": "my host",
"port": "",
"database": "my database",
"username": "my username",
"password": "my password",
"ssl": "true"
}
}
migration file:
CREATE TABLE tawag.person(
id serial PRIMARY KEY,
first_name text NOT NULL,
last_name text NOT NULL,
created_at timestamptz DEFAULT now()
);
Need help to get through this hurdle..
Thanks again for your great tutorial.
@knowthen. Amazing intro. Any interest in doing a follow up with advanced topics of Postgraphile as well as best practices running in production?
This is an y tutorial.
Thanks for being this detailed.
Great tutorial, thank you! It's pretty cool that PostGrahile can get a GraphQL server up and running from a Postgres database so easily. As soon as requirements get complicated though, you're now programming in the database. So while this may be attractive for db admins, as a developer, I'd rather build logic inside of a web application. I can see myself using PostGraphile for pet projects and demos, but not for anything serious in production. All in all, neat stuff!
What I like about your tutorials is that besides all the technical stuff you share some actual useful life skills stuff along the way like Spaced repetition or Pareto principle. Bravo and keep it up! Thank you
Best of the best. Keep going and you’ll TH-cam your way to the top.
Your tutorials are on point! But I don't see myself learning psql functions anytime soon.
Also can you do elixir basics and projects tuts?
Thanks for the mini course, great work!
Thanks for creating and sharing this 👏👏👏
It's really one of fantastic tutorials
Awesome tutorial! Thanks!
I haven't used Postgraphile, how does it compare with other options such as Prisma 2, Hasura or TypeGraphql?
Postgraphile is more like Hasura. TtpeGraphQL is also nice, however, you need to write all the resolvers yourself
Any thoughts on Prisma?
had to play this one at 0.75 speed
pls use the postgres docker image
amazing video!
thank you!!!
You talk too fast and say too little