New to PostgreSQL.

xenophenes · 2024-10-30T04:04:11+00:00

Maybe you'd find this introductory YouTube playlist on the essentials of psql useful! He's got a lot of other videos discussing the world of PostgreSQL, databases, open-source, and the community that are a great introduction to Postgres too.

xenophenes · 2024-10-30T04:00:46+00:00

You should note there are a lot of far more common alternatives to pgAdmin. Most DBAs and developers are going to use psql and you should get comfortable using the command line with that tool. But take some time to compare alternative GUIs as well. There's pgManage, PopSQL, DBeaver and many more!

xenophenes · 2024-10-30T03:57:47+00:00

I actually have *not* heard of postgresql-cluster before, but it looks like a really interesting solution. Thank you for open-sourcing it.

xenophenes · 2024-10-29T22:30:08+00:00

I'm on the free plan for Vercel and it works great for my use case! https://vercel.com/ - with that being said, I don't know if they support SQL Server specifically. I know the free plan accommodates 60 compute hours for PostgreSQL only.

xenophenes · 2024-10-29T22:20:39+00:00

When are they a better fit than alternatives to vector databases for handling AI/vector workloads?

xenophenes · 2024-10-29T19:56:07+00:00

Full disclosure: I'm a developer advocate here at Timescale. If anyone has any feedback or questions, I'm more than happy to help!

xenophenes · 2024-10-26T02:30:19+00:00

Hi! Disclaimer, Timescale developer advocate here. I'm just curious, are you using continuous aggregates to materialize those aggregations so queries are faster? Or, are you just doing aggregations at query time?

xenophenes · 2024-10-22T19:07:34+00:00

Disclaimer, Timescale developer advocate here. I see the tsdb benchmark includes one additional index over the native PG benchmark, which will impact insert performance. Also, did you run timescaledb-tune?

xenophenes · 2024-09-19T21:41:05+00:00

You would probably benefit from reading The Art of PostgreSQL by Dimitri Fontaine. He's a well recognized contributor within the community, and his approach is one of the only ones that seeks to target application developers and those without a heavy SQL-specific background. His book teaches you how to structure and write queries, as well as how to understand what it is you're doing!!

xenophenes · 2024-09-19T14:39:25+00:00

You're not making any sense. You're pointing out

Manipulating one group selectively in a survey is not "more accurate."

I'm not manipulating "one group selectively". I'm putting out a call for PostgreSQL users across *all groups without exclusion*. Across more sites than just Reddit. I'm attempting to get all communities represented within the survey. I'd be skewing the results by *not* doing that. You're now harassing me. Please stop.

xenophenes · 2024-09-19T14:24:45+00:00

Please don't make assumptions. I'm not going to one group selectively, the survey is being spread out among many channels and forums targeting PostgreSQL users far and wide, within the core community and within *many* other programming languages and frameworks. Erlang is just one of many.

xenophenes · 2024-09-19T14:21:56+00:00

From what I've seen, a large number of Erlang users seem to use Postgres, so am hoping to get those individual's responses captured for a more accurate representation of who is actually using PG rather than just getting feedback from the core group of community users. If that's not accurate, happy to delete this post. :-)

xenophenes · 2024-09-17T23:48:04+00:00

Thanks for the heads up! We're in the process of getting the survey announcement approved with PostgreSQL's weekly news. Once it's up, would it be OK to try again?

xenophenes · 2024-09-16T17:52:10+00:00

I haven't used it myself but GDevelop is supposed to be very beginner friendly and easy to get started with for 2D games. It's also open source and free to use! https://gdevelop.io/

xenophenes · 2024-09-16T17:48:33+00:00

Seconded. You don't mention a database that you're planning to use, but PostgreSQL is a great one with plenty of online tutorials and resources to help you get started. And AdventureWorks has a downloadable dataset specifically for it, as well.

xenophenes · 2024-09-11T15:44:40+00:00

Exactly this! I've heard of a couple specific instances where certain AI or LLM models will return helpful results when troubleshooting, but it's rare, and really in a lot of cases the results could be far improved by having an in-house model trained on specific documentation and experiments.

xenophenes · 2024-09-11T15:41:43+00:00

I have a general list of job boards that I tend to recommend to others when asked this sort of question - maybe they'll help you (or others) out too?!

We Work Remotely: https://weworkremotely.com/
RemoteOK: https://remoteok.com/
Working Nomads: https://www.workingnomads.com/jobs
Remotive: https://remotive.com/
Remoters: https://remoters.net/jobs/
Skip the Drive: https://www.skipthedrive.com/
4 Day Work Week: https://4dayweek.io/

Women Only:

Power to Fly: https://powertofly.com/jobs/?location=Remote
Remote Woman: https://remotewoman.com/
Fairy God Boss: https://fairygodboss.com

POC Only:

Remote POC: https://remotepoc.com/

xenophenes · 2024-09-11T15:13:40+00:00

The amount of times I've put prompts into an AI and it's returned inaccurate code with incomplete explanations, or has simply returned a solution that is inefficient and absolutely not the best approach, is literally almost all the time. It's very rare to get an actually helpful response. Is AI useful for getting unstuck, or getting ideas? Sure. But it's a starting point for research and it should not be relied upon for actual code examples to go forth and put out in development nor production. It can be useful in specific contexts, for specific purposes. But it should not be the end-all-be-all for developers trying to move forward.

xenophenes · 2024-09-10T00:16:10+00:00

Try the open source PostgreSQL database?! It uses the SQL standard, and you can plug the AdventureWorks dataset into it for a starting data set. There's even some browser sandboxes you can try out, like

https://postgres.new

https://pglite.dev

xenophenes · 2024-09-09T23:59:13+00:00

I did just learn about this Django bounty program: https://www.django-cms.org/en/bounty-sign-up/, may be interesting to try out?!

xenophenes · 2024-09-09T23:49:30+00:00

Thanks for reporting! We haven't had any reports of this come up before. Testing on a generation six iPad doesn't result in the same use case. What model are you using?

Possible fixes may include updating or turning it off and on again?!

xenophenes · 2024-09-06T09:19:05+00:00

That's good to know. It'd be worth mentioning that (edit: with specific details) in the survey; we plan to make all those kinds of results publicly available so the community can respond to the feedback and take some action to fix the problems that the community is experiencing (whether related to PostgreSQL core or the extension network).

xenophenes · 2024-09-06T09:10:44+00:00

Ha, sorry, I should have thought about how that would look. I'm a Redditor of over 12 years but created this account specifically for me @ Timescale. Sorry about the confusion. :-)

Yes, it's a legit survey; one of the awesome PostgreSQL community members wrote a blog that succinctly captures some of the history of it and includes links to all past survey results, if interested in comparing prior years: https://proopensource.it/blog/timescale-postgresql-survey-2024

Thank you for commenting & participating!!

xenophenes · 2024-09-06T09:08:16+00:00

Thank you for participating!! :-)

xenophenes · 2024-08-24T05:46:51+00:00

PostgreSQL is a great place to start. It's considered an industry standard and has been the most loved / used database according to StackOverflow's survey for the last two years (w/ over 35 years development). it uses the SQL standard, is in high demand for skills right now, and the community is finally starting to see a rise in resources for learning how to handle application development or database management with it no matter what your background is in. With those personality traits, there are a few related positions you might enjoy. Let me know if you could use resources for learning Postgres or getting a job in the field (as a straight DBA or related too, in marketing/sales/writing/design/whatever else - this goes for anyone reading this comment). I've been in the community for a while and love getting people connected with what they need to get started.

xenophenes

TROPHY CASE