ghostfolio VS PostgreSQL

At Ghostfolio, we are very excited to participate in Hacktoberfest for the second time, looking forward to connecting with new and enthusiastic open-source contributors. Hacktoberfest is a month-long celebration of open-source projects, their maintainers, and the entire community of contributors. Each October, open source maintainers from all over the world give extra attention to new contributors while guiding them through their first pull requests on GitHub. This year the event celebrates its 10th anniversary.

Give us a Star: If you have found value in Ghostfolio or appreciate our commitment to simplifying investment tracking, please consider giving us a star on GitHub. Your support helps us reach a wider audience and make a difference in the world of wealth management.

A manual action where I multiply and divide all actions. It works, bit hardly. Won't do it again. A next time, I'll probably try to do a sell all old stocks for X/stock, and then buy all for X/splitamt/stock to handle this.

https://github.com/ghostfolio/ghostfolio/discussions/1072

100 requests a minute for a free API isn't gonna cut it for automated trading, and extreme pedantic preferences aren't very conducive for a "community project" type thing. You can track specific stocks using something https://github.com/ghostfolio/ghostfolio but I don't about a generic Stock Ticker type thing either.

Don't know CoinMarketCap well and what you use it for, but maybe ghostfol.io is interesting for you?

We are very excited to join Hacktoberfest for the first time with Ghostfolio and meet new and ambitious open-source contributors. Hacktoberfest is a month-long celebration of open-source projects, their maintainers, and the entire community of contributors. Each October, open source maintainers from all over the world give extra attention to new contributors while guiding them through their first pull requests on GitHub.

Does Ghostfolio cover your needs? I know there has been a lack of selfhosted portfolio trackers up until its recent release.

go to the github page, Thomas is very active there https://github.com/ghostfolio/ghostfolio and he has a Slack channel too you can join.

The yml files I'm using are the ones here: https://github.com/ghostfolio/ghostfolio/tree/main/docker

When I decided to publish the project as open source software (OSS), I did not know what exactly to expect. In the worst case, nobody would care. And in the best case, the repository would be overrun with contributions. The truth is probably somewhere in between.

Another key feature of txtai is being able to quickly move from prototyping to production. This article will demonstrate how txtai can integrate with Postgres, a powerful, production-ready and open source object-relational database system. After txtai persists content to Postgres, we'll show it can be directly queried with SQL from any Postgres client

SQL (Structured Query Language) databases are relational databases. They organize data into tables with rows and columns, and they use SQL for querying and managing data. Examples include MySQL, PostgreSQL, and SQLite.

Node.js, MySQL and PostgreSQL servers installed on your machine

Each app’s front end is built with Qwik and uses Tailwind for styling. The server-side is powered by Qwik City (Qwik’s official meta-framework) and runs on Node.js hosted on a shared Linode VPS. The apps also use PM2 for process management and Caddy as a reverse proxy and SSL provisioner. The data is stored in a PostgreSQL database that also runs on a shared Linode VPS. The apps interact with the database using Drizzle, an Object-Relational Mapper (ORM) for JavaScript. The entire infrastructure for both apps is managed with Terraform using the Terraform Linode provider, which was new to me, but made provisioning and destroying infrastructure really fast and easy (once I learned how it all worked).

I've used MySQL for years. But recently, I found myself working PostgreSQL and simple things like dumping and restoring a database are different enough that I decided to document the process. It's straightforward enough once I knew how.

A running Rails application needs a database to connect to. You may already have your database of choice installed, but if not, I recommend PostgreSQL, or Postgres for short. On a Mac, probably the easiest way to install it is with Posrgres.app. Another option, the one I prefer, is to use Homebrew. With Homebrew installed, this command will install PostgreSQL version 16 along with libpq:

PostgreSQL

PostgreSQL: Offers a robust feature set and strong compliance with SQL standards, making it suitable for a wide range of applications, from simple to complex, particularly where data integrity and extensibility are key.

FerretDB is an open source document database that adds MongoDB compatibility to other database backends, such as Postgres and SQLite. By using FerretDB, developers can access familiar MongoDB features and tools using the same syntax and commands for many of their use cases.

To better understand how SQL injection works, let's quickly create a vulnerable app using Node.js, Express, and a PostgreSQL database. The application takes user input from a form, constructs a SQL query, and executes it against the database to fetch some data.