PostgreSQL features you didn’t know about 👩‍💻 #programming #code #technology #tech #software

Key Takeaways

postgres has some amazing features that you probably didn't know about you can store Json data directly into your database the Json column lets you insert Json data unless you query array items or objects so maybe you don't need a nosql database working with dates is actually easy instead of doing some strange calculations you can use the keyword interval or add and subtract numbers to more accurately get what you're looking for you can also write recursive queries so if you want to recursively query your database you use this to do it x amount of times and if you need to generate fake data really quickly using generate series you can create a series of a value interesting and if you need to sample your database you can use the table sample keyword this works similarly to like data frame head and pandas or any other data frame Library so before you add more Tech postgres might have you covered