create custom endpoint.

[ajaytank1991]

Hello

I want to create custom endpoint.
How can I do it in plausible CE?

my requirement is that,

I have a page for ex domain.com/contact-us I am changed the the page slug to domain.com/contact

In state domain.com/contact consider as new page.

I want move old slug data to new slug so If I checked page state it would be same.

But I handle it. My project is in react js/ nodejs

I will trigger that end point in my project when slug change.

[ruslandoga]

👋 @ajaytank1991

There is no functionality for this at the moment. You might be able to do that with a reverse proxy but that's something you would need to research on your own.

[ajaytank1991]

Thank you.

Let me try it.

[ajaytank1991]

👋 @ruslandoga

Thanks for details. I was really helpful to me.

given snippet is working fine with plausible_events_db But It is not woks with plausible_db.

I have did this changes

plausible_db:
    # Plausible v2.1.1 was tested against PostgreSQL versions 15 and 16
    image: postgres:16-alpine
    restart: always
    volumes:
      - db-data:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=postgres
    ports:
      - "5432:5432"

and this code for node js

const clickhouse = new ClickHouse({
	url: 'http://localhost:5432',
	debug: false,
	basicAuth: null,
	isUseGzip: false,
	trimQuery: false,
	usePost: false,
	format: "json", // "json" || "csv" || "tsv"
	raw: false,
    config: {
		session_timeout                         : 6000,
		output_format_json_quote_64bit_integers : 0,
		enable_http_compression                 : 0,
		database                                : 'plausible_db',
	},
});

When I verify the status using curl
curl http://localhost:8123
it's return 200 OK - it is working fine

curl http://localhost:5432
it's return 500 bad request.

Do you have any idea what I missed here?

It will be very helpful to me if you can assist me.

Thank you.

[ruslandoga]

localhost:8123 is ClickHouse, localhost:5432 is PostgreSQL. Please do use ChatGPT or other similar tools for the rest. This is no longer related to Plausible :) Good luck!

[ajaytank1991]

Ooh Okay,

Can we connect plausible_db database in node project?

If yes, how we can do it?

If no, Can we create custom endpoint(I mean API) in Plausible CE? I will trigger that api where I want in node project.

Or should we user our custom PostgreSQL database?

Thank you.

[ajaytank1991]

localhost:8123 is ClickHouse, localhost:5432 is PostgreSQL.
I got your point.

Can we connect plausible_db database in node project?

If yes, how we can do it? it will helpful to me is you can assist me.

If no, Can we create custom endpoint(I mean API) in Plausible CE? I will trigger that api where I want in node project.
Or should we use our custom PostgreSQL database for plausible_db in Plausible CE?

Thank you