MariaDB

MariaDB

Application and Data / Data Stores / Databases
Needs advice
on
FirebaseFirebaseFlutterFlutter
and
SupabaseSupabase

Hello,

I'm in the midst of reviewing an old CRUD SAAS I have running on Angular 7 with a MariaDB backend and Laravel PHP. Presently is hosted on a couple of Linode servers- and really feeling the weight, especially with the looming need to upgrade to A15 and meet the pace and scalability occurring (for context, the SAAS turns in over 24k USD monthly in subscriptions- so I have concerns around the impact of a new stack on existing clients). Additionally, I manage a Kotlin and Swift codebase for appdev.

I'm looking at moving towards Flutter for a singular codebase, and something serverless but still relational- like Supabase. In the past, I ran my own Auth services- but it was a ton of work to setup and maintain, so looking at using Firebase for Auth services (I know Supabase has Auth as well, but I wonder if it's as reliable and frequently maintained as Firebase?) Supabase has a FlutterSDK as well which makes things much simpler. Planning on maintaining microservices like Stripe etc for functional aspects.

I would love some insight from those who have done a tech stack transition, what should I be aware of- those who have produced in Flutter or a similar stack, what am I walking into without knowing?

READ MORE
7 upvotes·228.8K views
Replies (1)

Hey, I reckon with Flutter, Firebase, or Superbase you're looking at the right technologies, though I wonder if there's a faster way to get your new app up and running.

Your first sentence "CRUD SaaS" app made me wonder whether a low-code solution could do the trick for you. How much UI customization are you looking for? Is this a typical "admin panel" web app with a couple of screens for login/logoff, data entry, etc? Or is this something with a highly customized UI? And do you need native mobile or just a responsive web app?

There are a couple of online database builders that give you a hosted relational database, authentication, the ability to write logic, and deployment in one platform.

Our company Five, for example, has a low-code IDE that gives you a fully-provisioned MySQL DB, a prebuilt responsive React/MUI user interface, and one-click deployment of web apps onto AWS infrastructure.

You can build most of your application using Five's pre-built features. But you can also write SQL, JS or TS to query your data, or to add logic.

READ MORE
1 upvote·3K views
Needs advice
on
DjangoDjangoFirebaseFirebase
and
LaravelLaravel

I need advice. Am currently building a real estate marketplace mobile app using Flutter for frontend. I am not sure which backend solution to use, and thinking of using Firebase, Django or Laravel for backend and MongoDB/MariaDB for the database. I want to build an API backend and then use RESTful API calls for the frontend.

READ MORE
7 upvotes·73.3K views
Replies (1)

I think you should first choose either a database or server side programming language then you can streamline your other choices based on that, but I think if you are building a big project then going with django + firebase / mongodb would be a good choice else choose laravel + firebase.

READ MORE
3 upvotes·1 comment·61.4K views
Bibusa Nkolomba
Bibusa Nkolomba
·
May 26th 2022 at 5:40PM

I use PHP and Python for backend and MySQL. I think I'll go with PHP/Laravel or Python/Django

·
Reply
Needs advice
on
HadoopHadoopInfluxDBInfluxDB
and
KafkaKafka

I have a lot of data that's currently sitting in a MariaDB database, a lot of tables that weigh 200gb with indexes. Most of the large tables have a date column which is always filtered, but there are usually 4-6 additional columns that are filtered and used for statistics. I'm trying to figure out the best tool for storing and analyzing large amounts of data. Preferably self-hosted or a cheap solution. The current problem I'm running into is speed. Even with pretty good indexes, if I'm trying to load a large dataset, it's pretty slow.

READ MORE
2 upvotes·156.2K views
Replies (1)
Recommends
on
Druid

Druid Could be an amazing solution for your use case, My understanding, and the assumption is you are looking to export your data from MariaDB for Analytical workload. It can be used for time series database as well as a data warehouse and can be scaled horizontally once your data increases. It's pretty easy to set up on any environment (Cloud, Kubernetes, or Self-hosted nix system). Some important features which make it a perfect solution for your use case. 1. It can do streaming ingestion (Kafka, Kinesis) as well as batch ingestion (Files from Local & Cloud Storage or Databases like MySQL, Postgres). In your case MariaDB (which has the same drivers to MySQL) 2. Columnar Database, So you can query just the fields which are required, and that runs your query faster automatically. 3. Druid intelligently partitions data based on time and time-based queries are significantly faster than traditional databases. 4. Scale up or down by just adding or removing servers, and Druid automatically rebalances. Fault-tolerant architecture routes around server failures 5. Gives ana amazing centralized UI to manage data sources, query, tasks.

READ MORE
4 upvotes·1 comment·138.9K views
pionell
pionell
·
September 23rd 2020 at 7:58AM

thanks, looking into this!

·
Reply
CTO and Software Architect at Medstrat·
Needs advice
on
AppOpticsAppOptics
and
DatadogDatadog
in

We use AppOptics. I am curious what are the current leaders for APM for small companies (50 employees) that use Python, MariaDB, RabbitMQ, and Google Cloud Storage. We run both Celery and Gunicorn services. We are considering Datadog or some other deep code profiling tool that can spot I/O, DB, or other response time/request rate issues

READ MORE
3 upvotes·125.7K views
Replies (1)
Recommends
on
Instana

If you want to get deep insights and fast issue resolution have a look at INSTANA.

There is a public sandbox to get first insights and feeling for the tool. If you like it you can also run a free trial if you like.

READ MORE
Instana - Getting Started with APM (instana.com)
2 upvotes·2 comments·4.5K views
Gal Cohen
Gal Cohen
·
February 2nd 2021 at 7:47AM

We are running Python & Celery, our stack is based on AWS ECS. We are using NewRelic. This tool is just amazing, both for API and Offline workers. It would provide any metric I was looking for, including a profiler, SLA / SLO dashboards, infrastructure metrics. It has alerting capability that is easily integrated with Pingdom / PagerDuty / Webhooks.

·
Reply
Greg Smethells
Greg Smethells
·
September 19th 2020 at 8:29PM

Thanks, I’ll take a look.

·
Reply
Needs advice
on
Node.jsNode.jsReactReact
and
React NativeReact Native

I'm researching what Technology Stack I should use to build my product (something like food delivery App) for Web, iOS, and Android Apps. Please advise which technologies you would recommend from a Scalability, Reliability, Cost, and Efficiency standpoint for a start-up. Here are the technologies I came up with, feel free to suggest any new technology even it's not in the list below.

For Mobile Apps -

  1. native languages like Swift for IOS and Java/Kotlin for Android
  2. or cross-platform languages like React Native for both IOS and Android Apps

For UI -

  1. React

For Back-End or APIs -

  1. Node.js
  2. PHP

For Database -

  1. PostgreSQL
  2. MySQL
  3. Cloud Firestore
  4. MariaDB

Thanks!

READ MORE
11 upvotes·405.2K views
Replies (7)
Recommends
on
Flutter

My Recommendations: Front End: Flutter because of developer tooling and powerful declarative widget system Back End: Node.js or Go because Node.js has a large ecosystem and Go has a good built in http setup Database: Cloud Firestore because of ease of use, NoSQL, and the ability to set data from the client

READ MORE
14 upvotes·2 comments·12.5K views
anandarao493
anandarao493
·
July 27th 2020 at 4:46PM

Thanks, since Google cloud Firestore is a NoSql database, I'm wondering how does it work for an app where it does daily transactions in a user checkout flow, etc.. ?

·
Reply
awesomebanana2018
awesomebanana2018
·
July 27th 2020 at 5:50PM

I'm not entirely sure what the question is about, as I don't see any problem using Cloud Firestore for transactions, but here is a use case for using Firestore with stripe: https://firebase.google.com/docs/use-cases/payments

·
Reply
FullStack Dev ·
Recommends
on
Node.js

If you go with react / react native I advice you to go with node. Why ? I first didn't believe coding in javaScript everywhere (back, front and db queries) was making life SO much more easy. I still followed the advice, in the end this is a huge relief. For a small startup project with 1/2/3 devs, using only one langage increases efficiency a lot. You can switch very fast from a topic to another.

READ MORE
8 upvotes·10.9K views
View all (7)
CEO at Scrayos UG (haftungsbeschränkt)·

We primarily use MariaDB but use PostgreSQL as a part of GitLab , Sentry and Nextcloud , which (initially) forced us to use it anyways. While this isn't much of a decision – because we didn't have one (ha ha) – we learned to love the perks and advantages of PostgreSQL anyways. PostgreSQL's extension system makes it even more flexible than a lot of the other SQL-based DBs (that only offer stored procedures) and the additional JOIN options, the enhanced role management and the different authentication options came in really handy, when doing manual maintenance on the databases.

READ MORE
11 upvotes·684.2K views