Welcome to our most recent MySQL for Beginners article! We’re going to focus on tables today as the foundation of database administration…Continue reading on Medium »

MySQL is one of the most popular database management systems that have been used in many apps. It’s renowned for its compatibility with…Continue reading on Medium »

STRUCTURED QUERY LANGUAGE(SQL)Continue reading on Medium »

Continue reading on Medium »

Continue reading on Medium »

Continue reading on Medium »

databases that actually have a decent GUI as opposed to just doing things via the console? submitted by /u/savant78 [link] [comments]

Continue reading on Medium »

Continue reading on Medium »

Continue reading on Medium »

Okay guys, a real quick question…Continue reading on Medium »

In my React.js application I have a list of todos like this and their order can be changed Todo 1 Todo 2 Todo 3 Let's say I move the Todo 3 to top, Now the list becomes Todo 3 Todo 1 Todo 2 I want to persist the order in DB. How can I achieve this? I am using MySQL submitted by /u/Taka-tak [link] [comments]

If you're interested in distributed databases there is a free virtual event next week. r/YugabyteDB's Distributed SQL Summit (DSS) Asia (April 24th) is aimed at people interested in adopting a modern data ecosystem and simplifying their database modernization. You can find out more and register here➡️https://events.ringcentral.com/canvas/events/distributed-sql-summit-asia-2024/registration submitted by /u/Yugabeing1 [link] [comments]

Hello. I am a complete beginner and know very little about databases, but I would like to read about it and learn. I have done some internet research on books and manuals for beginners, and titles like "Designing data intensive applications", "Database internals" and "Mysql crash course" have come up. However, by reading the book description, they all seem to be business-oriented. While my interest in databases is purely to learn how to store data in a way that makes it easy to compare information (I suppose then I should learn about SPQL?), for academic research. Any recommendations or advice? submitted by /u/LoganDeya [link] [comments]

I am building an inventory management SaaS for mobile and web. I’ll be managing with a single web server. But for db, I am stuck between if I should go for Approach 1: A Database per organisation Vs Approach 2: One database shared between all organisations where each record in every table is identified by an organisation id My analysis so far is, Approach 1: - data isolated completely (peace of mind) - customer with low data will not be affected by an adjacent high data customer - moving the db around to different server can get easy - though not an intention, can convert to a custom solution at later point have no idea about scalability- is it difficult? managing backups could be difficult? Approach 2: - data isolation created with row level security of Postgres (less peace of mind though an unrealistic fear at times) - performance issues due to mixing up of high and low usage customers - easy maintenance - easy scalable ? - managing backups is easy What else am I missing ? Please do suggest me a choice about it ? submitted by /u/Prestigious_Ebb5260 [link] [comments]

I am building an app in Maui and was going to use SQLite as the database. I want to be able to also expand this app to ASP.net and possibly a Windows application at a later date. I want to use SQLite as the database and want to keep it as independent as I can from the main application. So down the road I can add in a different DB if I need to . I was reading the Maui docs and they suggest using the sqlite-net-pcl nuget package as the ORM, possibly because it is tailored for mobile apps? But the problem I see with this is I wouldn't be able to use this ORM for ASP.net or another framework that isn't mobile focused. So would I be better off using Dapper? or EF? for the sake of expansion and the ease of having it work on all frameworks? Or is there a way I can use sqlite-net-pcl with all frameworks? I have used Dapper before but never tried EF. Wasn't sure if one of these options would be a better solution. Thank you for the guidance! submitted by /u/80sPimpNinja [link] [comments]

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

So I was assigned to make a payroll management system, and my first task was to create an ERD out of it. i would just like to know if what I'm doing is right? Or am I missing some entities or attributes? It's just a simple payroll management system. Any help would be appreciated thanks ! https://preview.redd.it/drp4kewzpruc1.png?width=1212&format=png&auto=webp&s=0e504f6bcd6ca424e48d5ed2aa7c9fe4f974f6d7 submitted by /u/9342134o_C [link] [comments]

I was looking for a way to create an ERD that can also get generated into html structure that can be navigated. I saw what Dataedo can do, which looks really amazing. But their pricing seems very high, and I don't see that I can purchase just the ER diagram tool. Are there any similar tools/vendors that can do something like what Dataedo does? What is important is that I can edit the description of tables/columns/objects (etc) in the XML files and then maybe use a tool to generate the HTML that can be served locally or thrown into a web app in Azure or something. submitted by /u/Genuine-User [link] [comments]

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

I am building a world database of schools for an awareness project at work. All the information is public, but I have to find it separately in each of the schools websites, which given its an international database, will take me ages. ​ Is there a shortcut? ​ Thanks! submitted by /u/Exotic_Ad4675 [link] [comments]

Hello, Not sure if I am in the correct sub. However, I am looking for a person to set up a database and an app for a website. We're trying to cut cost within reason and preferably looking for people based in Australia, New Zealand. We're trying to avoid currency costs exchange so preferably outside of USA and Western Europe but I will consider all responses. If you need more information just let me know or dm me a message. submitted by /u/captaingirl2 [link] [comments]

Hello! I am building a database system and want to add Deadlock prevention (Wait-die), but have some questions regarding consistency and aborts. Let's say I have T1 and T2, S(X) - read lock, U(X) - update lock, W(X) - write lock: T1: R(X) W(X) T2: R(X) W(X) Both transactions will receive an S(X) lock and then will try to upgrade to W(X). This, of course, leads to deadlock (sad for deadlock prevention mechanism) My question: How do I deal with this? Transactions release R(X) and try to get W(X) - Consistency violation I thought about adding a U(X) lock that is exclusive to U(X) and W(X) but is not limiting S(X). So T1 will receive U(X) and will be able to upgrade to W(X). The problem is what to do with T2? I cannot let it wait for T1 to finish, because then the consistency is violated. Should I then abort and restart T2 instead? Another issue is, how to understand which type of lock to receive - provided I can't infer from the API the access pattern (kind of like how updates use U(X) lock in SQL databases) I haven't been able to find an answer online on this matter, but if anyone knows some - would also be appreciated! submitted by /u/Volume999 [link] [comments]

database that is a MariaDB database? submitted by /u/savant78 [link] [comments]

I made this video (https://www.youtube.com/watch?v=_JGgGR3Rp60) a while back about different caching strategies. In it, I explain: Side Cache Read-Through Cache Write-Through Cache Write-Behind Cache Write-Around Cache. Having a good handle on these has been very important for us at Superthread as one of our key differentiators is speed at scale. btw. Superthread is an all-in-one project management software and wiki for small teams. I hope that some of you find it useful & interesting. submitted by /u/totally_random_man [link] [comments]

Heyo, I stumbled upon this youtuber that seems to be a lecturer at an university putting all of his material online. It's compact and divided into seperate 3-20 min videos, and handles a ton of database stuff. If you're stuck w/ something or need some extra info, you might find it on there. Just here to drop this off for a future google-searcher 😉 The channel is called Theoretical Computer Science, @ TheComputerScience, has about 2k subs. submitted by /u/EkkosFatNuts [link] [comments]

when using a database, such as MariaDB on a server, is the database queried directly by the html that teh client uses, or, does the client query data in the database by sending a POST or GET to for ex an intermediate fle, such as a python file, and then that python file queries the database and then returns the data to the client? submitted by /u/savant78 [link] [comments]

I'm looking for a laptop to install Linux Oracle on it. I also have a Macbook but it does have some serious compatibility issues with Oracle and I'm pursuing the database so install some other database-related software too. So please suggest to me some laptops that are decent to run Oracle or tell me the specs I tried to find offline market submitted by /u/rohit_1824 [link] [comments]

Hello, I’m a student using MySQL for the first time. For one of my classes I have a project where I need to make a database system that a business can use to keep track of clients and orders. I used visual studio to make an application which connects to a local MySQL server that runs on my laptop. I used mamp and phpMyAdmin in order to run the server. The application works as it should, however I need to turn in the project to my professor along with the database and all of the records within it. My question is since the server runs locally on my computer, how can my professor use the application and access the database server? Is there a way to access the server from another computer? Thank you, I would really appreciate any help. submitted by /u/JedLongtree1029 [link] [comments]

I'm fairly new to using MySQL, rather this is my first project for academic purposes. The "helpdesk system" that the database is for, it's managed through calls and not tickets. Now, is there a more "organized" or "optimized" way of coming up with my mock data? I have a table for "Employees", "Equipments", and "Specialists". From there, the database sort of just branches out to "Calls", "Issues", and "Solutions" where I have to utilize some of the data I input in the first three tables which I mentioned. Is there a more logical way of doing this? I mainly use Mockaroo for my mock data but of course, it wouldn't "generate" the same dataset despite inserting the same field and same data type. For example, in my "Calls" table, some of my FKs are an employee's first and last name which is named "Caller_FName" and "Caller_LName". But I have to come up with 15 rows or so of that, I've tried manually doing it initially but because of the number of data of course it wouldn't be the "advisable" way right? Is there some other website or application I could use along with generating "text" data about the description of an issue being handled in the helpdesk system? submitted by /u/someunknownmf [link] [comments]

I am tasked with designing a database, which a team of around 15 users will need access to. The database will store doctors. I will be receiving Excel files containing the data, I will need to load into the DB, and my users will later on pull from this DB using some filtering. I'd like to keep the DB and front end separate... maybe like an Access DB and Excel front end? We are a Microsoft shop. Any suggestions? submitted by /u/OwnFun4911 [link] [comments]

A new feature that we’re adding is a user being able to create their own tables, similar to something like google sheets but limited to a certain number of types. These types are things like Number, Text, URL, email, DateTime, etc. I’m really confused on the best way to represent this in my database. Since this is a common feature by many applications, is there a common pattern used for something like this ? We use Postgres btw. submitted by /u/hugh57231 [link] [comments]

Hi, I'm a bit of a noob with databases so I'm unsure if this is an issue for here or for the SQLite (Have already tried flask but their solutions lead me to think this is a issue with the DB) page or something else, so apologies for that off the bat. But here is my issue. I'm attempting to connect to my database and this seems to work since the print statement returns "Connected to database successfully!". My form seems to be working correctly too as the output does give the username and password. When I attempt to print the results of the query however, this does not seem to get any data, just returning []. The database does exist and is in the same directory, i would add an image however, it seems to delete them:/ Does anyone know what the issue would be here? I have been stuck looking for a solution for a week and this is my last resort. Once again, apologies if this is the incorrect subreddit, I'm just stuck and running out of time. If this isn't correct, please could you point me in the right direction:) Some extra info: I created the database using command line and then populated this database using a software called TablePlus (not sure if the issue could just be that?). The code and the database are within the same folder (Should i add something?) ​ app.py #----------------------------------- #IMPORTS import sqlite3 from flask import Flask, render_template, request #----------------------------------- #SETUP app = Flask(__name__) #----------------------------------- #ROUTES @app.route('/', methods=[ 'GET', 'POST']) def index(): if request.method == 'POST': #----------------------------------- #SQLITE connection = sqlite3.connect("user_data.db") cursor = connection.cursor() if connection: print("Connected to database successfully!") else: print("Error connecting to database!") #----------------------------------- #HTML FORM name = request.form['name'] password = request.form['password'] print(name, password) #----------------------------------- #QUERY query = "SELECT name,password FROM users where name= '"+name+"' and password='"+password+"'" #query = "SELECT name,password FROM users where name='billy' and password='mullen';" #print(f"Executing query: {query}") cursor.execute(query) results = cursor.fetchall() print(results) #----------------------------------- #VALIDATION if len(results) == 0: print('login failed try again') else: return render_template("logged_in.html") return render_template( "index.html" ) if __name__ == '__main__': app.run(debug=True) index.html <!DOCTYPE html> <html lang="en"> <head> <title>login page</title> </head> <body> <centre> <h1>Login Page</h1> <form method = "POST"> <br><br> <input type ="name" name = "name" placeholder = "Username"> <br> <input type ="password" name = "password" placeholder = "password"> <br> <input type="submit" name="submit"> </form> </centre> </body> </html> Output: WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead. * Running on http://127.0.0.1:5000 Press CTRL+C to quit * Restarting with stat * Debugger is active! * Debugger PIN: 375-394-052 127.0.0.1 - - [12/Apr/2024 16:15:15] "GET / HTTP/1.1" 200 - Connected to database successfully! billy mullen [] login failed try again 127.0.0.1 - - [12/Apr/2024 16:15:52] "POST / HTTP/1.1" 200 - file feedback when using command prompt: sqlite> SELECT name,password FROM users where name='billy' and password='mullen'; billy|mullen sqlite> submitted by /u/AspectBilly [link] [comments]

this is rather a clarification on the category, classifying olap type software: what is considered a “database” and what is an “db engine”. I always thought that there should be a clear separation between them. my definition: - a database is where i actually manage, have control over both storage & processing e.g. mysql. - an engine is only the compute/processor without managing storage of X GB, e.g. sitting on top of s3 - hive, trino. so in case of OLAP db clickhouse, depending on deployment - clickhouse can be categorized as both database and engine? e.g. if I create a click house database with a fixed storage of 100GB - a cluster of 3 servers - then its a db. if I created a click house cluster on top of s3 - then this is an engine without need to manage storage. depending on deployment clickhouse can be similar to hive(atop hdfs), presto/trino that only includes processing engine? submitted by /u/No_Dependent_8959 [link] [comments]

I am 31M, I am working as L3/Team Lead SQL server database administrator in my current organisation. I have around 8+ yrs of SQL database administrator experience in my biodata. In which I have experience of 1yrs 8 months in back office and 1yrs 10 month experience as application support. After this job I switched my profile to SQL server database administrator and I show all my experience as SQL server administrator. Now I am seeking advice for my career advancement. I want to know what should I do to increase my skills and my pay scale? submitted by /u/Large-Alternative802 [link] [comments]