252
Tarallo - selfhostable FOSS Trello alternative (feddit.it)
submitted 7 months ago by matteinim@feddit.it to c/selfhosted@lemmy.world
27 comments fedilink hide all child comments

Hi! For the ones of you that use Trello, I made a simple to use and host alternative in PHP. It's not a complete alternative like other projects, and I mainly made it to be able to host it on free PHP web servers while having control over data/attachments. It also support a basic importer for Trello JSON exports.

I'm hosting a test instance here, you can make an account to try it out (no email required):

https://trytarallo.altervista.org/

And the repository with other instructions is here:

https://github.com/michelematteini/tarallo

top 27 comments
sorted by: hot top controversial new old
[-] HumanPerson@sh.itjust.works 25 points 7 months ago

Wow code with actual comments???!!!! Amazing!

[-] matteinim@feddit.it 14 points 7 months ago

...and I didn't even minimize them on the test instance, so that people will feel their weight while the page load :D

[-] HumanPerson@sh.itjust.works 4 points 7 months ago

Is there a docker version or a chance of one in the future?

[-] matteinim@feddit.it 10 points 7 months ago

I know it's kinda expected in these project... Let's say that if no one contributes it, I'll have to look up how to set it up, since I'm not really a web dev. But yeah it's gonna be there.

[-] Turun@feddit.de 13 points 7 months ago* (last edited 7 months ago)

A basic image is really easy. It's basically just

Dockerfile

FROM debian  # start with a minimal Linux system. There are probably better options than debian. Some images are made especially for docker (i.e. very minimal and light weight). 
RUN apt install dependencies  # do what ever you need to get your app running. 
RUN echo "options and stuff" >> /etc/a/config/file  # you can also edit system files
COPY . /app  # copy your project into the docker container.
EXPOSE 8080  # doesn't actually do anything, but documents where the app will be listening
CMD server-binary run /app/main.php  # I have actually no idea how php server stuff works

(Docs https://docs.docker.com/reference/dockerfile/)

Then people can run your project with docker.

Edit: checking the readme some small changes would be required. Config.php should read in environment variables and the DB init SQL should be run automatically somehow.

[-] matteinim@feddit.it 1 points 7 months ago* (last edited 7 months ago)

Edit: checking the readme some small changes would be required. Config.php should read in environment variables and the DB init SQL should be run automatically somehow.

I'll probably start with making these changes to make it compatible, thanks!

[-] HumanPerson@sh.itjust.works 3 points 7 months ago

I was looking for something like this a little while ago but couldn't find anything and this looks perfect. My server is mostly docker only so I might try to figure it out.

[-] lemmyreader@lemmy.ml 11 points 7 months ago

The screenshots look nice !

[-] richieadler@lemmy.myserv.one 8 points 7 months ago

in PHP

😥

[-] Pixel@lemmy.sdf.org 7 points 7 months ago

Imagine starting project in PHP in 2024

[-] Rikj000@discuss.tchncs.de 12 points 7 months ago

I write PHP on the daily and don't understand the hate it gets :/

At least I can work on Linux at home while my co-workers are stuck on Windows with their C#

[-] OpenPassageways@lemmy.zip 4 points 7 months ago* (last edited 7 months ago)

It's been nearly 10 years since you needed to develop with C# on Windows.

New versions of .NET have been cross platform with a free IDE since 2016.

[-] Rikj000@discuss.tchncs.de 1 points 7 months ago

Legacy software still requires maintenance.
Legacy dependencies still require to be used in new projects.
Dual booting multiple times a day is not feasible.

For those reasons none of my co-workers can fully switch to Linux.

[-] lascapi@jlai.lu 7 points 7 months ago

I love you're stack! PHP and vanilla JS 🤩 It's so KISS!

I like that I can install it on my o2switch server.

[-] octopus_ink@lemmy.ml 7 points 7 months ago

I spent just a few minutes with it and I like it a lot. I swear it's more responsive than actual trello! :D

[-] tristan@aussie.zone 5 points 7 months ago

This looks great, I don't suppose you plan on a pre-made docker container?

[-] Fizz@lemmy.nz 4 points 7 months ago

Actually a pretty cool project. Its smooth and works exactly how i would expect. Hopefully some companies use it and contribute money or code so you can keep improving it.

[-] lolcabanon@programming.dev 2 points 7 months ago

Hey! I see lot of people here hating on PHP, but I totally get what is you goal here and I love it!

I don't really like PHP myself, but I absolutely love that I can litteraly spin up a LAMP stack OSS in like 15 minutes on a shared hosting if it's mostly "copy files, edit config.php, init db, done".

Some modern setup which are required to run on VPS that are supposedly easier since they run in docker are just so cumbersome to install... Like you need 6 api keys for 3 different cloud services and 12 containers configured in a docker-compose.yml just to try a local instance...

[-] promitheas@iusearchlinux.fyi 2 points 7 months ago

Ive been looking for something like this for a while. Ill need to try it out

[-] mypasswordis1234@lemmy.world 1 points 6 months ago

I like it but UI/UX could be better

[-] Suoko@feddit.it 1 points 7 months ago

It's Time for activity pub integration :)

[-] Tick_Dracy@lemm.ee 1 points 7 months ago* (last edited 7 months ago)

The app seems great. @matteinim@feddit.it I'm getting an error when trying to create the DB tables: Reason: SQL Error [1273] [HY000]: (conn=517001) Unknown collation: 'utf8mb4_0900_ai_ci'

Does it support MariaDB 10.6.17?

[-] matteinim@feddit.it 3 points 7 months ago

That is the character set and collation that should be used, and your DB probably don't support it. You can try by leaving the default by removing "CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci" inside init_db.sql, anywhere you find it.

[-] Tick_Dracy@lemm.ee 1 points 7 months ago

I created a DB with utf8mb4 with the general_ci collection, but the issue remains. I'll try to change the SQL script

[-] Tick_Dracy@lemm.ee 1 points 7 months ago* (last edited 7 months ago)

To make it work, I had to remove some things from the script, which didn't work for me:

  1. START TRANSACTION;
  2. SET time_zone = "+00:00";
  3. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  4. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  5. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  6. /*!40101 SET NAMES utf8mb4 */;
  7. CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci (like you suggested)
  8. COMMIT; (In Alter Tables, since as far as I remember, DDL commands don't need to commit, only the DML ones. So I did the commit manually)

If I need to remove the registration, do I have to update the Value column on tarallo_settings table or are there any settings' menu which I'm not seeing?

[-] mattreb@feddit.it 2 points 7 months ago

No there aren't just disable it from tarallo_settings!

[-] Olly1240@feddit.it 1 points 7 months ago

This was a missed opportunity of calling it in honor of Lino Banfi: Tarello

this post was submitted on 08 Apr 2024
252 points (100.0% liked)

Selfhosted

39948 readers
239 users here now

A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.

Rules:

  1. Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.

  2. No spam posting.

  3. Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.

  4. Don't duplicate the full text of your blog or github here. Just post the link for folks to click.

  5. Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).

  6. No trolling.

Resources:

Any issues on the community? Report it using the report flag.

Questions? DM the mods!

founded 1 year ago
MODERATORS
ruud@lemmy.world
Loki@lemmy.world
CannaVet@lemmy.world
devve@lemmy.world
HybridSarcasm@lemmy.world
HybridSarcasm@lemmy.hybridsarcasm.xyz