Add a page to list all the topics

[abompard]

It would be nice to have a page that would basically be the result of SELECT DISTINCT topic FROM messages with a time delta. Having it as an API endpoint would make it even more useful, to know what's available.

[asamalik]

That would be really useful to discover what topics exist, I'd love that!

[MundiaNderi]

Hey @abompard and @asamalik Is this issue still open and up to date? I'd like to work on it as an Outreachy intern.

[abompard]

Yes, that is still a valid issue to pick from. Please assign it to yourself using the link at the top of the right column.

[NoubissiViany]

Hi, @abompard and @asamalik. Is this issue still active and up to date? I would like to work on it as an Outreachy intern.

[Solar-Rays]

Hi @abompard @asamalik Can I work on this also please?

[anshikavashistha]

I want to work on this issue. @abompard please assign this to me

[damilareogaga]

Please assign this issue to me @abompard

[anshikavashistha]

I am working on it
@abompard @asamalik

[abompard]

Hey @MundiaNderi , are you still interested? Have you started working on it?

[Precious000]

Hi @abompard appears this has not been assigned yet, can you please assign it to me? I’m an outreachy intern and would love to work on it. Thanks

[MundiaNderi]

Hey @abompard Thank you for assigning the task to me. I had started another Outreachy task by the time you replied that I'm still working on. Since @anshikavashistha had already started on it, my suggestion is that they continue working on it.

[abompard]

I've been contacted by @anshikavashistha and she's working on something else now. I'm going to go through the comments by date then. Are you still interested @NoubissiViany ?

[NoubissiViany]

@abompard yes i’m still interested

[abompard]

Alright, go ahead! :-)

[NoubissiViany]

Okay thanks very much.

[princyym]

Hello @abompard , I am a beginner and I want to work on this issue can you assign it to me.

[abompard]

Hi @princyym , it's unfortunately already assigned. @NoubissiViany do you still want to work on it?

[NoubissiViany]

@abompard Yes I am, please I need more details on the issue. For example, in which language are we going to create the endpoint and in which folder are we specifically going to work? I'm lost at a certain point

[abompard]

Hey @NoubissiViany , are you still interested or should I unassign you so that other can work on it?

[NoubissiViany]

You can unassign it to me.

…

On Fri, Jun 28, 2024, 14:10 Aurélien Bompard ***@***.***> wrote: Hey @NoubissiViany <https://github.com/NoubissiViany> , are you still interested or should I unassign you so that other can work on it? — Reply to this email directly, view it on GitHub <#676 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AW3W7QBTVPK44JLC2HB4QFDZJVOGFAVCNFSM6AAAAABB63GHYGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOJWHA3TGOBXG4> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[abompard]

If we want to have a representative view of the topic, I think we should make a materialized view in datanommer/postgresql for the list of messages over the past year, and add to that the number of messages in each topic.

Having a materialized view would help with the cost of the query.