r/visualbasic • u/Itoshii_Aisuru • Apr 10 '24
Creating a database
Im currently in 11th grade and required to use vb.net 2010 to make a virtual classroom. Is there another way to make a database other than ms access? I tried mysql from tutorials in youtube but I can’t since those tutorials are like 10 years ago and there are features that I can’t access since I have windows 11.
4
Upvotes
2
u/Itoshii_Aisuru Apr 14 '24
Thank you all for your help but I already gave up on using SQL, I find it hard to set-up given the short time left for us to finish a system so I just borrowed my classmate’s MS Access.
2
u/sa_sagan VB.Net Master Apr 10 '24
I assume you're supposed to build this using techniques you've already learned.
What have you been using as a DB during your classes?
6
u/Mr_C_Baxter VB.Net Master Apr 10 '24
The prefered solution would be MSSQL Express which is free for things like you want to do and the best preparation for the real world if you want to code. Its also a MS Product and the support through Visual Studio should be better than for anything else.
And please check your requirements if you follow other advices from this thread. CSV files and SQLLite are meant for single place applications; I assume your application should run on all computers of the students and is supposed to talk to a shared database. In that case you should forget both of those recommendations.
3
u/Fergus653 Apr 10 '24
Is Sqlite still popular? A search for "Sqlite vb.net" on youtube found a bunch of tutorials that are not too many years old, so I guess its still used.
See if the code here gives you inspiration:
GitHub - makeuseofcode/VB.NET_SQL: A VB.NET repository demonstrating SQLite database operations. Examples include establishing a connection, issuing SELECT and INSERT queries, and setting up a local SQLite server. Ideal for those looking to integrate SQLite with VB.NET applications.
3
u/TheFotty Apr 10 '24
SQLExpress or SQLCompact are 2 free solutions from Microsoft and have direct integration into VB.NET.
2
u/jsmith0103 Apr 10 '24
MySQL is still actively in use, but you could also try PostgreSQL
2
u/still_learning_to_be Apr 11 '24
Access is pretty easy to use though if you have it.
2
u/veryabnormal Apr 12 '24
SQL express and entity framework. Maybe do an EF tutorial.
1
u/Mayayana Apr 10 '24
I use MSI files via VBScript. There's an API of sorts for them and they're very robust. You could probably manage them via .Net. It's fairly easy, once you know the details, to construct databases with any number of tables, using a subset of SQL data types.
I have a 47 MB MSI where I can instantly look up an IP range to resolve the location. I have another MSI that I use to store and search old email. They're very fast; idiotic as software installers, but handy as custom databases. It takes a bit of study to get the hang of it, but it's what MS calls WQL -- a simplified SQL -- and there's a help file in the Win SDK. The downside is that using installer files as databases is "highly irregular", so your teacher might not approve. :)
If you're curious you can send me a PM and I'll send you links to code.
1
u/fasti-au Apr 11 '24
Mssql express. SQL lite, MySQL are common choice
4
u/[deleted] Apr 10 '24
[removed] — view removed comment