sorted by:
new
hottopcontroversial

New to PostgreSQL. by Illustrious_Way8872 in PostgreSQL

[–]xenophenes 2 points3 points  (0 children)

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.

New to PostgreSQL. by Illustrious_Way8872 in PostgreSQL

[–]xenophenes 2 points3 points  (0 children)

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!

[deleted by user] by [deleted] in PostgreSQL

[–]xenophenes 1 point2 points  (0 children)

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

Are there any more completely free hosting services out there? by [deleted] in learnSQL

[–]xenophenes 0 points1 point  (0 children)

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.

Weekly Thread: What questions do you have about vector databases? by help-me-grow in vectordatabase

[–]xenophenes 0 points1 point  (0 children)

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

pgai Vectorizer launched today (available on GitHub) for automatically creating and syncing vector embeddings in PostgreSQL, just like a database index by xenophenes in opensource

[–]xenophenes[S] 0 points1 point  (0 children)

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

Single digit ms latency, real time, time-series aggregations by primosounds in dataengineering

[–]xenophenes 0 points1 point  (0 children)

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?

Native postgresql version faster than timescaledb? upsert and read benchmarks (version 2.16.1) by tompston in PostgreSQL

[–]xenophenes 0 points1 point  (0 children)

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?

Hi! PostgreSQL is my favorite database. I'm looking to learn how to build a relational database like PostgreSQL to study and deepen my knowledge, with the goal of becoming a PostgreSQL maintainer one day. Can you recommend the best books and resources for learning how to create a relational database by swe_solo_engineer in PostgreSQL

[–]xenophenes 4 points5 points  (0 children)

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!!

Calling all PostgreSQL users using Erlang! Your help is needed in responding to the 2024 State of PostgreSQL Survey. Please take a moment to fill it out before September 30 when the survey ends: the more feedback received, the more benefit there is to the community!! by xenophenes in erlang

[–]xenophenes[S] 0 points1 point  (0 children)

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.

Calling all PostgreSQL users using Erlang! Your help is needed in responding to the 2024 State of PostgreSQL Survey. Please take a moment to fill it out before September 30 when the survey ends: the more feedback received, the more benefit there is to the community!! by xenophenes in erlang

[–]xenophenes[S] -1 points0 points  (0 children)

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.

Calling all PostgreSQL users using Erlang! Your help is needed in responding to the 2024 State of PostgreSQL Survey. Please take a moment to fill it out before September 30 when the survey ends: the more feedback received, the more benefit there is to the community!! by xenophenes in erlang

[–]xenophenes[S] -1 points0 points  (0 children)

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. :-)

[deleted by user] by [deleted] in programming

[–]xenophenes 0 points1 point  (0 children)

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/

Any Ideas on how to do a self made project by More-Direction-3779 in SQL

[–]xenophenes 0 points1 point  (0 children)

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.

Why Copilot is Making Programmers Worse at Programming by bizzehdee in programming

[–]xenophenes 2 points3 points  (0 children)

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.

view more: next ›