Menge Posted August 24, 2004 Posted August 24, 2004 i've been developing an application that relies on a database to store data (just like any other catalog program). i wanted it to be of easy set up. but right now in dev i'm using MySQL to store stuff. my problem is that mysql seems to require you to manually open the console and create the database and user for the program to use. is there a way to circumvent this? allow the program to automagically create its own user/database without the need for the user to have to even open an MySQL admin window? if not, is there any good zero config database that could be tightly integrated to a C# project? because i wanted it to be basically able to be set up 100% by the program (remove the burden from the user i dont care if its kinda complicated to set up from code. but i dont want the user to have to do it). thanks in advance :D Quote Menge
Joe Mamma Posted August 24, 2004 Posted August 24, 2004 when you say set up the database. . . do you mean the DB engine that holds the database or the database (tables, views, etc) itself. . . Look at the MSDE (microsoft data engine) for the previous. . . DDL (data definition language) for the latter. I am sure that mySQL supports DDL. Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Menge Posted August 24, 2004 Author Posted August 24, 2004 thanks, i'm gonna research into what you said. when i said "database" i meant something like a library that would be a database engine and that could be integrated into the project so the user won't need to set up a server for it. and that the piece of software could access/configure/manage on its own. Quote Menge
Menge Posted August 24, 2004 Author Posted August 24, 2004 looked into DDL, MySQL doesn't seem to support that (haven't found any specific documentation on it). i looked into the MSDE download... it's a 40MB download. i think it's a pretty hefty download there. and still would require some work on the user side (installing it and setting up part of it), no? know any other system that i could integrate? (cause those aren't really integrated, they're real life DB servers) Quote Menge
Joe Mamma Posted August 24, 2004 Posted August 24, 2004 looked into DDL, MySQL doesn't seem to support that (haven't found any specific documentation on it). i looked into the MSDE download... it's a 40MB download. i think it's a pretty hefty download there. and still would require some work on the user side (installing it and setting up part of it), no? know any other system that i could integrate? (cause those aren't really integrated, they're real life DB servers) the MS Jet engine wont suffice??? Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Menge Posted August 25, 2004 Author Posted August 25, 2004 the MS Jet engine wont suffice??? i dont like the paradigm of it that much. was looking for something more robust. i found out that MySQL has an embedded library for C/C++ available. i'm going to later on see how far i can get into wrapping it to C# since i couldn't find any decent libraries that wrapped that. Quote Menge
Joe Mamma Posted August 25, 2004 Posted August 25, 2004 i dont like the paradigm of it that much. was looking for something more robust. i found out that MySQL has an embedded library for C/C++ available. i'm going to later on see how far i can get into wrapping it to C# since i couldn't find any decent libraries that wrapped that. I cant believe MySql doesnt support Create/Alter Database Create/Alter Table Create/Alter Index etc. . . Quote Joe Mamma Amendment 4: The right of the people to be secure in their persons, houses, papers, and effects, against unreasonable searches and seizures, shall not be violated, and no warrants shall issue, but upon probable cause, supported by oath or affirmation, and particularly describing the place to be searched, and the persons or things to be seized. Amendment 9: The enumeration in the Constitution, of certain rights, shall not be construed to deny or disparage others retained by the people.
Menge Posted August 25, 2004 Author Posted August 25, 2004 i looked into it, and it does support that. i was able to connect to the server as root (in the default configuration) and create databases/users. though i think it's inadequate. more of a hack. later on today i'll try to wrap the libmysqld.dll C library in C# so that i can have a serverless daemon running on my pc Quote Menge
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.