MySQL

MySQL

Application and Data / Data Stores / Databases
Needs advice
on
LaravelLaravel
and
WordPressWordPress

Hi All

I am currently working on preparing a multi-tenant app with one database per tenant. The app will have data analytics dashboards, CRM, and task management modules. Originally my thoughts were to build with Angular, Laravel, and MySQL, as the development team mainly consists of PHP developers.

However, the team is recommending to develop the app entirely using WordPress by utilizing a multisite model, saying that it will not have any impact on performance even as the user base increases.

My own take is that this will have a negative impact on performance. Can you please advise me if this is true?

READ MORE
7 upvotes·111.1K views
Replies (3)
Recommends
on
Laravel

Yes, right

WordPress can build the multisite model quickly, it can achieve faster results on a limited budget and time But during business maintenance and refinement after running the first version, WordPress may become a hindrance, also it could get heavier when load more plugin

Laravel needs more code work at the early stage of the project, page build, business logic, and so on, use Laravel will cost more time on the first version But after the first release, the maintenance and refinement will be much better than WordPress

READ MORE
9 upvotes·37.6K views
Full Stack Developer - Designer ·
Recommends
on
WordPress

I will advise going with the team in which your team is comfortable with, as you mentioned you have less time. WordPress is a good tool for customize development. Just care about the securities and don't use more than 2-3 plugins. Assign proper resources in terms of Ram and others using custom configurations of PHP and wpconfig. About Restful API it provides you built-in facility which you can us later on for the App developments for mobiles. Wish you good luck with your project.

READ MORE
5 upvotes·1 comment·36.8K views
neststay home
neststay home
·
January 24th 2024 at 9:42AM

Choosing a team comfortable for you is crucial, especially with time constraints. WordPress is an excellent choice for customized development; prioritize security and limit plugins to 2-3. Allocate sufficient resources like RAM through custom PHP and wpconfig configurations. Utilize WordPress's built-in Restful API for future mobile app development. Best of luck with your project!

·
Reply
View all (3)
Needs advice
on
FlutterFlutterLaravelLaravel
and
MySQLMySQL

Developing a managed multivendor marketplace mobile app to enable users to buy and sell (mainly used hardware) products from the same app, allowing buyers to checkout and purchase an entire listing at either the set "buy now" price or "make offer" to buy at a negotiated price with the seller. Please share your opinion on my current choice Flutter + Laravel (with MySQL) and are there more feasible alternatives?

READ MORE
5 upvotes·261.8K views
Replies (1)
Recommends
on
any

Just use the language you're most proficient and can iterate quickly with - of a, perhaps, larger concern - where is your backend?

Sure, you may be leveraging other services but I presume you're still going to log information about transactions and whatnot

READ MORE
4 upvotes·1 comment·15.1K views
Ahmed baber
Ahmed baber
·
March 8th 2024 at 7:21PM

nice advice

·
Reply
Needs advice
on
MongoDBMongoDB
and
MySQLMySQL

Hello, I am developing a new project with an internal chat between users. Also, there are complex relationships between the other project entities but I wolud like to build something scalable and fast and right now I am designing the data model. What kind of database would you recommend me to manage all application data? relational like MySQL, no relational like MongoDB or a mixed one? Thank you

READ MORE
6 upvotes·968.8K views
Replies (6)
Recommends
on
PostgreSQL
in

In MongoDB, a write operation is atomic on the level of a single document, so it's harder to deal with consistency without transactions.

READ MORE
5 upvotes·651.8K views
Recommends
on
MongoDB

MongoDB supports horizontal scaling through Sharding , distributing data across several machines and facilitating high throughput operations with large sets of data. ... Sharding allows you to add additional instances to increase capacity when required

READ MORE
4 upvotes·650.6K views
View all (6)
Needs advice
on
MongoDBMongoDB
and
MySQLMySQL

I'm starting to work on a Jira-like bug tracker web app. This is a hobby project that is mostly a way for me to learn about different technologies and development processes(CI/CD, etc..) so I could be more ready when I start applying for programming jobs.

I'm debating between MySQL, which I'm less familiar with, and MongoDB which I have used in the past.

My two points of consideration are the following:

1) Which one is more likely to be relevant for web dev jobs? While I want to learn new technologies, I prefer learning ones that will make me more hireable in the future.

2) Which one is more flexible when it comes to changing the shape of the stored data? I expect to need to make some changes as the project goes on.

Thanks, everyone!

READ MORE
8 upvotes·167.6K views
Replies (2)
Recommends
on
MySQL

MySQL is still more popular than MongoDB if you look at Google Trends. I've also added MariaDB, which is pretty much a copy from MySQL and its features, and PostgreSQL, which is also a popular relational database.

This is a very good article for comparing MySQL to MongoDB and which one you should use: MongoDB vs MySQL: A Comparative Study on Databases.

If you just want to learn and you have the time, I would opt for using both MySQL and MongoDB. For example using MySQL for most of the site content and MongoDB for saving log messages. As you get more and more logs you start to see the benefits from MongoDB's faster document fetching.

READ MORE
7 upvotes·1 comment·75.8K views
Tyler Jordan
Tyler Jordan
·
February 19th 2022 at 9:57PM

Hi! Thanks for the answer.

I really like the idea of opting to use both for different scenarios, and I think that this is the one I will go for.

Thanks again :)

·
Reply
Freelance Developer at DGTEpro·
Recommends
on
Clickhouse
InfluxDB

There's really not an awful lot of difference between the two, they have wildly different storage mechanisms but they each have their fairly similar benefits. If you want to learn something that might be a requisite skill for a job, I would also look at alternatives such as time based and column based systems like InfluxDB and the unbelievably fast and flexible ClickHouse. While they may seem like an unlikely fit for a personal bug tracker app, there's no reason not to use them. Since I got into InfluxDB people have been requesting it a lot and I'll be using ClickHouse for all large databases, probably forever. Expand your horizons beyond your competition's.

READ MORE
4 upvotes·73.5K views
Needs advice
on
MSSQLMSSQL
and
MySQLMySQL

We are planning to migrate one of my applications from MSSQL to MySQL. Can someone help me with the version to select?. I have a strong inclination towards MySql 5.7. But, I see there are some standout features added in Mysql 8.0 like JSON_TABLE. Just wanted to know if the newer version has not compromised on its speed while giving out some add on features.

READ MORE
4 upvotes·405.5K views
Replies (2)
Digital Developer at SpeakUnique·
Recommends
on
MySQL

MySQL AB doesn't implement anything in MySQL until they can find a way to do it efficiently and, often, more efficiently than other systems. So although I don't have experience with benchmarking JSON_TABLEs or similar new features, their development philosophy alone suggests that version 8 for the latest features would be a safe jump without sacrificing system performance.

READ MORE
6 upvotes·296.2K views
Cofounder at Wanderloop·

MySQL 8.0 is significantly better than MySQL 5.7. For all InnoDB row operations, you'll see a great performance improvement. Also, the time taken to process transactions is lower in MySQL 8.0. Moreover, there has been an improvement in managing read and read/write workloads.

READ MORE
6 upvotes·296.8K views
Needs advice
on
MongoDBMongoDBMySQLMySQL
and
PostgreSQLPostgreSQL

Hello,

I am trying to design an online ordering app similar to Doordash or Uber Eats. I'm having a hard time trying to finalise on what database (or mixture of databases) to use. I'm leaning towards using a relational database like MySQL or PostgreSQL. But, when the application grows, I don't want to join on 20 tables to get a data. Any help would be greatly appreciated. Thank you for your time.

READ MORE
7 upvotes·876K views
Replies (2)
CTO at Voila Cab's·
Recommends
on
MySQL

Hello Suhas , We build our product www.voilacabs.com which is in the same lines as yours but we have used a combination of Mysql and MongoDB. When using MySQL, i would recommend doing the following: 1. Use Mysql only for storage only and for realtime updates we recommend MongoDB. 2. Don't try to Join more than 3 tables. ( the moment you reach 3 join stop there and try to un-normalized database. 3. Never or very rarely use Auto-increments. ( we recommend using UUIDS ) . Use UUIDS always for Auto increments for MYSQL. If you using Postgre SQL then i would suggest you to please check this https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5c There is a stored procedure that generated unique keys instead of auto-increment keys and that will help you sharding or clustering database without sync errors. 4. Also For MongoDB if you can put a layer of REDIS Cache then that will boost your api performance under large loads. 5. Use Node.js programing language as that function asynchronously .

Let me know if you still need any suggestion's . Thanks & Regards Rupen Makhecha CTO @ Voila Cab's www.voilacabs.com

READ MORE
4 upvotes·3 comments·772.6K views
Raunaq Gupta
Raunaq Gupta
·
June 5th 2020 at 7:34AM

If you use MySQL and want a better sharding solution on top of it, then I suggest looking into @Vitess. You can also explore https://planetscale.com as a dbaas alternative to managing those services yourself.

·
Reply
Rupen Makhecha
Rupen Makhecha
·
June 5th 2020 at 8:05AM

Great, i think Vitess sounds promising. Thank you for this nice recommendation

·
Reply
Raunaq Gupta
Raunaq Gupta
·
June 5th 2020 at 8:37AM

Disclaimer: I work for PlanetScale where we maintain Vitess as well. We also have a beta feature currently in the works where someone can try out Vitess on top of their existing MySQL infra without making any changes. Please feel free to contact me if you'd be interested to test it out.

·
Reply
Cofounder at Wanderloop·

I would recommend a mixture of MySQL and MongoDB. Using MongoDB for the Content Distribution Network (CDN) will make it easy to store high volume incoming data. MySQL is recommended to be used for business logic. PostgreSQL is not recommended since you will be faced with inefficient database replication features and constant migration from one PostgreSQL version to another.

READ MORE
1 upvote·2 comments·773.1K views
aleyrizvi
aleyrizvi
·
May 26th 2020 at 4:07PM

How about mysql 8 with xdev protocol? Basically it offers a document store right out of the box.

·
Reply
Rafey Iqbal Rahman
Rafey Iqbal Rahman
·
May 27th 2020 at 7:12AM

The X Protocol is good.

·
Reply
Needs advice
on
MariaDBMariaDBMongooseMongoose
and
PostgreSQLPostgreSQL

Hi all. I am an informatics student, and I need to realise a simple website for my friend. I am planning to realise the website using Node.js and Mongoose, since I have already done a project using these technologies. I also know SQL, and I have used PostgreSQL and MySQL previously.

The website will show a possible travel destination and local transportation. The database is used to store information about traveling, so only admin will manage the content (especially photos). While clients will see the content uploaded by the admin. I am planning to use Mongoose because it is very simple and efficient for this project. Please give me your opinion about this choice.

READ MORE
6 upvotes·305.5K views
Replies (7)

The use case you are describing would benefit from a self-hosted headless CMS like contentful. You can also go for Strapi with a database of your choice but here you would have to host Strapi and the underlying database (if not using SQLite) yourself. If you want to use Strapi, you can ease your work by using something like PlanetSCaleDB as the backing database for Strapi.

READ MORE
4 upvotes·229.2K views
Meam Software Engineering Group·
Recommends
on
Mongoose
PostgreSQL

Your requirements seem nothing special. on the other hand, MongoDB is commonly used with Node. you could use Mongo without defining a Schema, does it give you any benefits? Also, note that development speed matters. In most cases RDBMS are the best choice, Learn and use Postgres for life!

READ MORE
4 upvotes·233K views
View all (7)
Needs advice
on
Auth0Auth0
and
AWS AppSyncAWS AppSync

Hi. We have an application, which offers clients with mobile Apps. Mobile apps serve using REST APIs provided by a big Monolith web frontend and backend built on PHP/MySQL running on a conventional dedicated machine.

Now we have started rolling out our application across the globe. We want to serve each country at its own TLD like, myapp.us, myapp.pk etc.

Since each country site might have different features and localization challenges, therefore, we'll need to have several different master branches, each for a country. And the backend application will be cloned on a separate machine for each country.

We'd need to geo-restrict mobile apps as well. So a client from the US would be served via our ".us" TLD REST API, and Pakistan client's App should be served with REST APIs from .pk TLD.

Need a piece of advice on, Which AWS service can we use to have a single authentication endpoint which would authenticate Apps from the relevant country server by automatically detecting the location?

Thanks.

READ MORE
3 upvotes·66.4K views
Needs advice
on
Azure Cosmos DBAzure Cosmos DBNeo4jNeo4j
and
OrientDBOrientDB

We have an in-house build experiment management system. We produce samples as input to the next step, which then could produce 1 sample(1-1) and many samples (1 - many). There are many steps like this. So far, we are tracking genealogy (limited tracking) in the MySQL database, which is becoming hard to trace back to the original material or sample(I can give more details if required). So, we are considering a Graph database. I am requesting advice from the experts.

  1. Is a graph database the right choice, or can we manage with RDBMS?
  2. If RDBMS, which RDMS, which feature, or which approach could make this manageable or sustainable
  3. If Graph database(Neo4j, OrientDB, Azure Cosmos DB, Amazon Neptune, ArangoDB), which one is good, and what are the best practices?

I am sorry that this might be a loaded question.

READ MORE
7 upvotes·209.6K views
Replies (1)
Recommends
on
ArangoDB

You have not given much detail about the data generated, the depth of such a graph, and the access patterns (queries). However, it is very easy to track all samples and materials if you traverse this graph using a graph database. Here you can use any of the databases mentioned. OrientDB and ArangoDB are also multi-model databases where you can still query the data in a relational way using joins - you retain full flexibility.

In SQL, you can use Common Table Expressions (CTEs) and use them to write a recursive query that reads all parent nodes of a tree.

I would recommend ArangoDB if your samples also have disparate or nested attributes so that the document model (JSON) fits, and you have many complex graph queries that should be performed as efficiently as possible. If not - stay with an RDBMS.

READ MORE
5 upvotes·2 comments·14.2K views
Michael Staub
Michael Staub
·
August 6th 2020 at 4:53PM

Another reason I recommend ArangoDB is the fact that the storage engine does not limit your data model. You cannot create a geo-index on a 'user.location' field in any of the gremlin-compatible stores for example, as the JSON documents can only have one level of properties.

·
Reply
Thiru Medampalli
Thiru Medampalli
·
August 7th 2020 at 9:00PM

Hey @ifcologne,

Thanks for your response, We woud explore the ArangoDB <

Here are some more details if you are wondering

Operation produces many samples(output) from other samples(input). We are traking both Operation and Samples (two graphs i.e one for operation and another for samples), Typical depth is 10 to 20 for both Operation and Samples but some are even deeper(> 20). Operations could be million records(2-3 million) and samples could be (10 to 20 million) records so far over the years. We are using the Closure data model in the dbms to represent the tree/graph data.

Access patern:

API and some power users directly access the data via specific sql(stored procedure and/or special sql sripts). We are open to restrict or enhance the acess pattens further.

We are finding it hard to go upstream/downstream and also merge two tree structures(operations and samples) as depth increaseses

We are finding hard to data mine based on sample or process attributes(some are nesed)

Hard to represent multiple parents to one child.

·
Reply
IT Specialist ·

I am a Microsoft SQL Server programmer who is a bit out of practice. I have been asked to assist on a new project. The overall purpose is to organize a large number of recordings so that they can be searched. I have an enormous music library but my songs are several hours long. I need to include things like time, date and location of the recording. I don't have a problem with the general database design. I have two primary questions:

  1. I need to use either MySQL or PostgreSQL on a Linux based OS. Which would be better for this application?
  2. I have not dealt with a sound based data type before. How do I store that and put it in a table? Thank you.
READ MORE
7 upvotes·634K views
Replies (6)

Hi Erin,

Honestly both databases will do the job just fine. I personally prefer Postgres.

Much more important is how you store the audio. While you could technically use a blob type column, it's really not ideal to be storing audio files which are "several hours long" in a database row. Instead consider storing the audio files in an object store (hosted options include backblaze b2 or aws s3) and persisting the key (which references that object) in your database column.

READ MORE
7 upvotes·481K views
Recommends
on
PostgreSQL

Hi Erin, Chances are you would want to store the files in a blob type. Both MySQL and Postgres support this. Can you explain a little more about your need to store the files in the database? I may be more effective to store the files on a file system or something like S3. To answer your qustion based on what you are descibing I would slighly lean towards PostgreSQL since it tends to be a little better on the data warehousing side.

READ MORE
5 upvotes·480.9K views
View all (6)