The following techniques are available in MongoDB for removing documents from a collection:Continue reading on Medium »

Continue reading on Medium »

Continue reading on DataFrontiers »

Welcome to the fascinating world of Database Management Systems (DBMS), where data organization and management are key to unlocking the…Continue reading on Medium »

TRIGGERS sempre foram algo bem complicado de se implementar dentro da área de bancos de dados, mesmo que sua função possa ser substituída…Continue reading on Medium »

CASE WHEN statement is a powerful tool that allows you to perform conditional logic within your SQL queries. It’s a versatile construct…Continue reading on Medium »

SQL vs. NoSQL DatabasesContinue reading on Medium »

What is Email Marketing for Lead Generation:Continue reading on Medium »

Herkese selamlar! Bugünkü yazımda sizlere programlamada listeleme yöntemlerini anlatmaya çalışacağım, kod ve örneklerimiz javascript…Continue reading on Medium »

In the fast-paced world of business, effective communication with top management is crucial for success. Leveraging the power of…Continue reading on Medium »

I Just joined a company for a few weeks in a new department that focuses on providing food for customers, which was previously outsourced. I'm the only analyst/IT on the team and they want to build a database on excel to hold their financial information, which would be later used for analytics. The operations is quite big. Because we have a middle man to help buy most of our ingredients through vendors, some of the data like food purchases comes externally in a form of a report from the middle man, and some data comes internally. I don’t have experience with building databases. Is it a good idea to be building it in excel, or what should my next steps be? submitted by /u/penguboo [link] [comments]

I see a lot of terminology being thrown around these days, so much that I am not sure which thing does what anymore. Are any of you up to speed in how all these things come together? submitted by /u/Nearby-Leek-1058 [link] [comments]

I got into the startup company to develop website for their real estate company. I have trouble deciding twhich database to choose. Company is just startup and it's base of operation is in small country. Should I use MongoDB or Postgresql? Give me other suggestions if you could please. submitted by /u/ForsakenProgram250 [link] [comments]

I know LSM-Tree-Based DBs (like Cassandra) "tend to be better for write-heavy applications" and B-Tree-based DBs (like DynamoDB) "tend to be better for read-heavy applications" Which would be best for an "Increment-by-heavy application"? - Example: Keeping a count of the total all-time number of listens for all songs on Spotify, batched and written to the DB once each night - Since you would need to "increment-by" the number of new listens from the day, would this essentially be "reading" the existing value, calculating the new total, then "writing" the final result? If so, would that mean the number of reads/writes would be "even" (for these updates at least)? Or do I have some huge misunderstanding? Any and all assistance is greatly appreciated, thanks! submitted by /u/The_Gentel_Sandwich [link] [comments]

submitted by /u/IGNFico [link] [comments]

I’m struggling to import a 40GB MySQL dump in a reasonable time. On my Mac Studio M2 Ultra this import takes around 6 hours - which seems absurd. The database has some tables with 10+ million of rows, and every table heavily relies on FK constraints and triggers, which I believe to be the cause of the slow imports. Importing 40GB MySQL database seems like such a trivial thing to do, but alas. Anyone have any advice? submitted by /u/SabatinoMasala [link] [comments]

Is there any fastest method to help migrate between these 2 databases while keeping the original business logic intact? The number of methods from Caché is more than 20 thousand. If you just move it manually, it will take a long time. submitted by /u/Sarahhydroponic [link] [comments]

Hi everyone, So Im currently working on a website of mine (which is a wordpress, it probably dont matter but you got some context) and while developing a new feature I thought about a possible problem (I think ?) Here is the situtation: I have a table in my database which is already filled with datas, and each entry is either assigned to a user or not assigned. like : ​ id data assigned user_id 1 randomData true 3 2 randomData false <null> 3 randomData false <null> When a user do a specific action, the code do in this order : 1)Retrieve for an available entry in the previously mentioned table 2)Check the infos contained in the entry 3)Assigned the entry to the user. My question being, is there a risk that two users trigger the action almost in the same time and end up editing the same row ? And how could I prevent this ? submitted by /u/Guilty_Ad_5422 [link] [comments]

I'm not a computer/programming oriented person. I'm tired to put my files in infinite layers of folders. I need to remember in my brain how they are placed in the folder tree. My files can be : Videos, audio, pdf, word, excel etc. I would like to classify/search my files with keywords and properties... I saw Jellyfin, it is mostly music and videos oriented. I would like a general solution for different file types. Any ideas? submitted by /u/joellapointe1717 [link] [comments]

I need to design a database for my mobile app - a flashcard app similar to anki. There are around 25 subjects, each having around 3 to 10 subtopics. each topic may have 5 to 20 headings and each heading may have 100 to 1500 flashcards. There will be a million plus flashcards easily. I need to organise these flashcards content as question, answer, explanations, these fields will be multimedia rich like images.... for managing them i will be assigning ID, TIme last accessed, time last reviewed, time taken to study, similarities to the other cards, due date etc. Once studied i will be assigning them to spaced repetion algorithm and students have to study the 'flashcards due for the day' everyday. This is where i am concerned about NoSQL . Can you suggest me which dbms i should choose, why and how to choose a serverless option for your recommendation. thanks in advance submitted by /u/appalam25 [link] [comments]

submitted by /u/Nixtivo [link] [comments]

submitted by /u/adam_optimizer [link] [comments]

Projects that need full text search, do you guys commonly use the apis provided by your databases like PostgreSQL FTS or MySQL FTS? Or do you guys use some other service like elasticsearch/algolia? I need to implement a item search in my application but not sure to use DB inbuilt FTS or an external service. submitted by /u/Horror-Card-3862 [link] [comments]

Hi, just a quick question - is there anyone here who actually uses GS-Base? Any major problems? Is it sufficient as a replacement for MySQL on home databases? Thx. submitted by /u/Mastodont_XXX [link] [comments]

Hey All, Just moved from using Mongo to Postgres not long ago and having some issues understanding my query's EXPLAIN results. Firstly- using Mongo, all my indexes are as good as none after projection/multiple actions. Using Postgres, are the indexes still available to use after JOIN? For example, if using both JOIN and GROUP BY/ ORDER BY, is the latter action doomed to be index-less? (given we don't save the result of the initial join separately) Secondly- What is ProjectSet?? can't seem to find any explanation over 3 words... ​ Thank you so much for helping me with my confusion! submitted by /u/HadarN [link] [comments]

Just as Git has become fundamental to software development, data engineers need similar tools to work in parallel, compare data versions, promote changes to production and roll back data when needed. Nessie provides data engineers with a Git-like version control system for managing data versions, branches, merges, and commits. This can be very helpful when multiple data engineers are working with and transforming data at the same time. Nessie allows each engineer to work in separate branches while maintaining a single source of truth in the form of the main branch. This functionality empowers data engineering teams to maintain data quality collaboratively in the face of unrelenting change. https://blog.min.io/uncover-data-lake-nessie-dremio-iceberg/?utm_source=reddit&utm_medium=organic-social+&utm_campaign=nessie_dremio_iceberg submitted by /u/swodtke [link] [comments]

I have an app that I wrote using CodeIgniter3 and mySql on AWS RDS. I am going to convert to CodeIgniter4 but am also considering modifying the database. The app is heavily database centric. RDS is quite expensive. It is a multiuser system. I have considered possess due to its ability to have a separate table for each user. I am also considering using MSSQL due to the ability to debug the script. Any thoughts? submitted by /u/richb201 [link] [comments]

How do I go about evaluating an entity relationship diagram and database? I am working on an assignment that requires me to evaluate an entity relationship diagram and database, how I go about this ? I’m confused on how to start and structure this review, thanks submitted by /u/average_couchpotato [link] [comments]

Reporting server databases are part of the MSSQL Availability group, however in the reporting server configuration manager the web service url is pointed directly to DB server hostname. I want to I reconfigure the reporting server web service URL to the availability group listener hostname. How do I redirect the url to the availability listener name if someone tries to access the old url ? submitted by /u/l0ne-warri0r [link] [comments]

Reporting server databases are part of the MSSQL Availability group, however in the reporting server configuration manager the web service url is pointed directly to DB server hostname. I want to I reconfigure the reporting server web service URL to the availability group listener hostname. How do I redirect the url to the availability listener name if someone tries to access the old url ? submitted by /u/l0ne-warri0r [link] [comments]

I need to store the following data in postgresql. I have a list of businesses and each business has a list of customers. Each customer for each business has a list of transactions. And every customer for every business has a chat room. I decided the following schema Business Table(Name, business_id) Customer table(Name, customer_id, Foreign Key to business_id) Transactions Table(Name, foreign key to customer_Id from customer Table, foreign key to business_id from business Table). Messages Table(data,sender(could be either business owner or customer), foreign key to customer_Id from customer Table, foreign key to business_id from business Table) Is there a better way? submitted by /u/MemberOfUniverse [link] [comments]

Currently I'm trying to build web app for online voting where registered user can create their own Election. For the database, every time user create an election should the system create new required table for the election or I could just some tables to hold everything ? case 1 (create required table for each election ) : user_table (id,name,email,etc) election_table (user_id, election_id,etc) per election created by user above, below tables will be created in database with electionId is part of table name : voter_electionId_table (voter_id,name,email,etc) candidate_electionId_table (candidate_id,no,name) ballot_electionId_table(vote_id,candidate_id) case 2 ( same tables for every election) : user_table (id,name,email,etc) election_table (user_id, election_id,etc) voter(voter_id,election_id,etc) candidate_electionId_table (electionID,candidate_id,no,name,etc) ballot_electionId_table(electionId,vote_id,candidate_id) which from above is better ? or none of them is good (If yes, please share your thought). ​ submitted by /u/xedoxzara [link] [comments]

Hello everyone, Do I have a dataBASED idea for you (sorry. Had to). I run a theater production agency in Poland. We produce a show, create multiple casts and tech teams, receive orders all over the country and go to events to play. We been a few years on the market and it is getting a bit overwhelming with the amount of data we need to work with and how much more data we need to collect. I'm trying to repair communication and information. I've been thinking about a DB/app to be able to use it for administration, logistics and, if possible, planning. First, what information I need to collect: Client (person that is organizing the event, ordering a show) Employees (3 types: techs [that have different tech roles. Some employees can do multiple jobs], actors [can play different roles, depending on the show. Like techs, some can play multiple roles], administration [basically me and the boss, but could be assistants or anybody else we might employ that doesn't go into the earlier categories]) Orders (Basically bookings/reservations made by clients. I want to implement a system via wordpress for this. I also need the information if the orders have been "moved" to a different date, or cancelled, and by who) Contracts (These probably will be 2 different tables - employee contracts, where, depending on the "department" a contract would be filled with information provided in the Employees table. I think there should be a seperate table for their pays. The other table would be Client Contracts - I also have a few types - quarterly contracts that include 'x' amount of orders, single contracts with single/double orders [depending on the orders]) Shows (ATM we have 2 shows available) Who/what/where (Not sure how to call this one. Basically to collect data which actor or tech played which role, when, how many times, in what towns. Things like that. It would be both for quality management and information on pay for the month) With all this I also would love to: have the option to import/export data to/from csv/xml files or to a google sheets file. Right now I'm running a "flimsy" db in google sheets, because my employee is older and not that technical savvy. It would be great if it would import data from the booking plug-in Export data to another website, where our fans can look up where and when we are playing and what cast is playing FTM that is everything that comes to mind. I must add - we have 2 shows, but the orders can come up: Show 1 (S1) is being played the same day, same time in 2 different places, 2 different clients, 2 different casts S1 and Show 2 (S2) are being played in 1 place (so we need a proper cast, to be able to play) and another S2 is being played somewhere else 2-3 times in 1 day S1 in 1 place Shows in our home town don't require a tech group or any drivers. Hopefully someone can help me out with this. submitted by /u/L3v1Ning [link] [comments]

So far I was using the ranking database website I found to consider which database I want to use. Is there a better website/tool to help choosing a DB for a project? For this example I'm writing in Rust a small POC, running on Docker, so I figured out in memory database is the best, if it has the option to save to disk for backups is great but for the POC in memory is more than enough, I don't need key-value database so Redis is good for this, relational would be sufficient but I don't seem to find one, there are too many options to find the needle in this haystack. So how do you guys choose a database? Edit: why is there a huge DB in my post that send you back to this post?... submitted by /u/barakadax [link] [comments]

submitted by /u/eranchetz [link] [comments]