FTPDB banner

FTPDB

Created by: jam06452
19 devlogs
25h 10m 1s

FlavorTown Project Database

Demo Repository

README

Loading README...
jam06452
jam06452 worked on FTPDB
about 23 hours ago
2h 50m logged

I fixed a lot of issues and bugs. Reverted API docs, and changes to the backend DB.ex. Calling random projects as an RPS from supabase instead of getting “random” projects manually, this ensures that these are truely random, added a filter to ensure default banner projects are excluded since this are normally default starter projects which have no time or content. Redone projects structure to make it more suitable for more vertical screens. Formatting, redone some DB.ex structure. A lot of work of the supabase tables to make RPCs work correctly, supabase tables needed maintenance etc to ensure they are happy.

Attachment
0
jam06452
jam06452 worked on FTPDB
3 days ago
2h 15m logged

Added openAPI schema for @SeradedStripes
Fixed some carasel issues
Tidied up some stuff

Gotta improve how the openAPI is presented

  • Chores, OPENAPI docs, and fixes (3718655)
Attachment
0
jam06452
jam06452 worked on FTPDB
3 days ago
0h 38m logged

Chores & Devlog page fix
Making devlog page nice next

  • Formatting & Random devlogs API (75dfac6)
  • /devlogs page for random devlogs (a0786c3)
Attachment
0
jam06452
jam06452 worked on FTPDB
3 days ago
0h 18m logged

Basic devlog page

Attachment
0
jam06452
jam06452 worked on FTPDB
4 days ago
1h 22m logged

Fixed scraping media URLs, was not fetching since I was using the incorrect API, i still dk what to do as images

Attachment
0
jam06452
jam06452 worked on FTPDB
4 days ago
2h 11m logged

Fix to homepage, refactor of functions under DB.ex, misc, project, user, devlogs reorder of functions for maintainability.

Consolidated frontend to use single CSS style document,

And more!
probably more caching

  • Added navbar being the same (a3b8294)
  • Consolidated frontend, all uses same CSS styling from one file (fa1912a)
  • Homepage fix (e20a8b7)
  • Refactor, misc, projects, users, devlogs (831f3b5)
  • Refactor, misc, projects, users, devlogs. Pt2 (0fe368a)
  • Homepage Fix and misc (ff89f47)
Attachment
0
jam06452
jam06452 worked on FTPDB
4 days ago
0h 23m logged

Fixed project page showing total user time instead of total project time

Attachment
2

Comments

SeradedStripes
SeradedStripes 4 days ago

lowkey having flavorpheus spam me with these devlogs

jam06452
jam06452 4 days ago

havent done one for 5hours gng

jam06452
jam06452 worked on FTPDB
4 days ago
0h 46m logged

Added faster banner scraping by using 40 concurrent workers, I added the option to rescrape FT for banners not just for Null values in the database

Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
1h 43m logged

Added a container that updates the database in realtime via the API

Idk what image to do

Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
0h 36m logged

Chores & Features

Added /page/:d to show user stats when being searched
Added separate panel for searching for users

  • Fixed crash when nil was being divaded by 3600, fixed by making default 0 if no value fetched (e0bce39)
  • Added searching for people (4747ff2)
  • formatting (66349a4)
  • Search improvements (074f5e1)
  • Added /user/:id page for user stats & projects (8fe4f1c)
Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
1h 16m logged

Added Cachex caching, this should significantly take off database load and speed up the site. idk what to do for the photo since it as all backend work

  • Implemented Caching with cachex (f83753b)
  • Fixed bug where when you clicked on a project it brought the user to the /project/:user_id (de490e9)
Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
1h 43m logged

Added /projects to view projects in a grid view with shuffle to get random projects etc
More buttons everywhere
Slack fix

Be sure to use /suggestions for improvements

  • slack fix (6d374f0)
  • Added more buttons in project page (4c0cae6)
  • formatting (f3cfb3c)
  • Added a /projects page that shows random projects or those based off of filters (5383084)
Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
0h 38m logged

Added suggestions, let me know what things you want now

  • Added suggestions page that messages me on slack with suggestons (1a76864)
Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
0h 23m logged

Added searching with smart complete which takes into account hotness and total likes to correctly find what you are looking for

  • Carousel is now working properly with the dots (833f24e)
  • Added total likes in project viewer (7eae16c)
  • Formatting & Searching (d51140a)
Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
1h 10m logged

Added native viewing for devlogs and projects within this. What should I add next?

  • Added profile pictures and display name (754d480)
  • Fixed forwarding to via user_id not project_id (ba2a975)
  • get_devlogs function (d66d9ce)
  • Renamed api.ex to DB.ex, more routes. (62a6fe1)
  • Added /project/:id path to show the project and devlogs locally (48d21dd)
Attachment
0
jam06452
jam06452 worked on FTPDB
5 days ago
1h 14m logged

Added banners & Profile pictures and names

  • Added banners to homepage (ff1e556)
Attachment
0
jam06452
jam06452 worked on FTPDB
6 days ago
0h 34m logged

Added basic frontend work with help from claude to get it done quickly.
I am working on getting project banners next
Added more API routes so we can see who has the most freetime

Attachment
0
jam06452
jam06452 worked on FTPDB
6 days ago
2h 56m logged

Added backend APIs for the frontend being built
/hot returns top ten projects determined by an algorith,
/top_this_week returns the top projects from this week
/fan_favourites returns most liked projects.

I am working on a frontend next using the PETAL stack.

ps, IDK what image to add since this is all backend

Attachment
0
jam06452
jam06452 worked on FTPDB
6 days ago
2h 5m logged

Scraped most of FT, some devlogs missing project IDs, the APIs are alr to work with but I will be releasing my own that are better. I do not have a frontend yet

Attachment
0