Image Store @ My SQL
Hi, I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). We have an client server application, server is located at another end of an intranet and the nodes are connected from different ends of intranet. In this modal, I need to store image of the student from one node that has to be accessed / Changed / by other nodes. If I have only one system I can store the path of the image. But it is a remote server, i can not store the PATH simply. Because of this i would like to go for an another modal of storing image itself into the DB I would like to know how VB 6.0 will handle this modal. Please give your valuable input on this issue. Thank you VIKKI A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
Re: Image Store @ My SQL
Dear Walter Heck, I am happy to receive immediate response from you. I am not clear with your answer, can you please explain it? Thank you From: Walter Heck wal...@openquery.com To: Vikram A vikkiatb...@yahoo.in Cc: mysql@lists.mysql.com Sent: Sat, 30 January, 2010 2:29:43 PM Subject: Re: Image Store @ My SQL Bad idea. Sotring images is what a file system is for. Create an NFS or other networked storage and store your images there. I don't see the problem? good luck, Walter Heck Engineer @ Open Query (http://openquery.com) On Sat, Jan 30, 2010 at 18:54, Vikram A vikkiatb...@yahoo.in wrote: Hi, I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). We have an client server application, server is located at another end of an intranet and the nodes are connected from different ends of intranet. In this modal, I need to store image of the student from one node that has to be accessed / Changed / by other nodes. If I have only one system I can store the path of the image. But it is a remote server, i can not store the PATH simply. Because of this i would like to go for an another modal of storing image itself into the DB I would like to know how VB 6.0 will handle this modal. Please give your valuable input on this issue. Thank you VIKKI A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
Re: Image Store @ My SQL
On Sat, Jan 30, 2010 at 19:03, Vikram A vikkiatb...@yahoo.in wrote: I am not clear with your answer, can you please explain it? Well, MySQL (as most databases) is not really suited for storing images. If you create a networked storage that you can share between both locations, that would solve your problem, right? cheers, Walter Heck Engineer @ Open Query (http://openquery.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Image Store @ My SQL
Bad idea. Sotring images is what a file system is for. Create an NFS or other networked storage and store your images there. I don't see the problem? good luck, Walter Heck Engineer @ Open Query (http://openquery.com) On Sat, Jan 30, 2010 at 18:54, Vikram A vikkiatb...@yahoo.in wrote: Hi, I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). We have an client server application, server is located at another end of an intranet and the nodes are connected from different ends of intranet. In this modal, I need to store image of the student from one node that has to be accessed / Changed / by other nodes. If I have only one system I can store the path of the image. But it is a remote server, i can not store the PATH simply. Because of this i would like to go for an another modal of storing image itself into the DB I would like to know how VB 6.0 will handle this modal. Please give your valuable input on this issue. Thank you VIKKI A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Image Store @ My SQL
Dear Sir, Let me explain what i understood, 1. I have to create a shareable folder among the network. 2. The image files has to be kept at share machine 3. Then the path (share machine) of the file has to be stored in the DB 4. When we want it has to be taken from the share Is it So? then i may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties. Please share your knowledge Thank you From: Walter Heck wal...@openquery.com To: Vikram A vikkiatb...@yahoo.in Cc: MY SQL Mailing list mysql@lists.mysql.com Sent: Sat, 30 January, 2010 3:16:11 PM Subject: Re: Image Store @ My SQL On Sat, Jan 30, 2010 at 19:03, Vikram A vikkiatb...@yahoo.in wrote: I am not clear with your answer, can you please explain it? Well, MySQL (as most databases) is not really suited for storing images. If you create a networked storage that you can share between both locations, that would solve your problem, right? cheers, Walter Heck Engineer @ Open Query (http://openquery.com) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=vikkiatb...@yahoo.in The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
Re: 50 things to know before migrating from Oracle to MySQL
Martijn Tonies wrote: database. I would also bet that 80% of the people who are actually writing queries with that many joins don't have a solid grasp of the fundamental principles of relational database design. Why not? Normalizing gets you -more- tables, not less. And normalizing is a goal in itself? I've seen plenty of normalized databases which have become a big mess because of the unnecessarily complex queries you needed to do a relatively simple job. A lot of the enterprise level features can be useful in certain cases, but it seems that a lot of times they are just used simply to use them. I cannot find justification for making databases unnecessarily complex, using subqueries when a simple join is all you need, using views, functions, stored procedures in cases that don't require such features, etc. I agree that a lot of people requiring more powerful hard- and software for their application are simply forgetting that they were supposed to produce a working application and not the most normalized database with all the fancy views and other stuff. -- Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
IMAGE STORE @ FEDORA 11
Dear One, I found nice solution on the following citation http://dev.mysql.com/tech-resources/articles/vb-cursors-and-locks.html It was really helpful to me. Thank you VIKKI A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
Fw: IMAGE STORE @ FEDORA 11
sorry the link i given is wrong. Please follow this http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html - Forwarded Message From: Vikram A vikkiatb...@yahoo.in To: MY SQL Mailing list mysql@lists.mysql.com Sent: Sat, 30 January, 2010 7:04:01 PM Subject: IMAGE STORE @ FEDORA 11 Dear One, I found nice solution on the following citation http://dev.mysql.com/tech-resources/articles/vb-cursors-and-locks.html It was really helpful to me. Thank you VIKKI A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!. Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexplorer/
Re: 50 things to know before migrating from Oracle to MySQL
Rudy Lippan wrote: How about complex data requirements? Depending on the resolution of your data set, I could see a simple person-type object that contained name, address, SSN, mother, and birth_info starting to approach the limit. Cities change, address changes, names change, and even mothers can change. The simple-looking street part of an address can have (at least) number, direction, name, suffix, any of which can change. Okay, so you want to link a person to an address table. I can justify that in the case of multiple addresses with a single person. But then you build a 'city' table to normalize that. Or no, better make a zip code table, link that to the 'city' table. Wait, streets can change names; a 'street' table too to link. Oh no! sometimes streets are split. So an address is a 'property' (a piece of ground), linked to a street, street linked to zip code, zip code linked to city. Damn (sorry), a 'property' can be divided... Oh my... Ever thought about updating a table by renaming a street? Or by selecting a group of street-number combinations and rename them? The real art is trying to balance the need of simplicity and ease of understanding with the need for flexibility, and that has nothing to do with relational theory. In real life the balance tends to go to unnecessary flexibility resulting in systems which are simply too heavy for the actual needs. Complex datasets are, by their nature, complex, and can only be simplified so much. You try to hide the complexity, you shift it, you move-it, you send it to its room, you pretend it is not there. And yet it still pops up at the most inopportune times and has to be dealt with. And still, in a lot of cases the complex datasets are even made more complex by normalization, trying to be ultimately flexible and creating a solution for problems which simply don't exist. In almost all cases a simple solution will be the best. Regards, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Image Store @ My SQL
I agree with Walter, a filesystem is far better suited for this. That said, mysql does have the ability to do what you are saying, you would just store it as a binary blob which is well documented and quite easy to use. See: http://dev.mysql.com/doc/refman/5.0/en/blob.html Colin On January 30, 2010 05:01:54 am Vikram A wrote: Dear Sir, Let me explain what i understood, 1. I have to create a shareable folder among the network. 2. The image files has to be kept at share machine 3. Then the path (share machine) of the file has to be stored in the DB 4. When we want it has to be taken from the share Is it So? then i may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties. Please share your knowledge Thank you From: Walter Heck wal...@openquery.com To: Vikram A vikkiatb...@yahoo.in Cc: MY SQL Mailing list mysql@lists.mysql.com Sent: Sat, 30 January, 2010 3:16:11 PM Subject: Re: Image Store @ My SQL On Sat, Jan 30, 2010 at 19:03, Vikram A vikkiatb...@yahoo.in wrote: I am not clear with your answer, can you please explain it? Well, MySQL (as most databases) is not really suited for storing images. If you create a networked storage that you can share between both locations, that would solve your problem, right? cheers, Walter Heck Engineer @ Open Query (http://openquery.com) -- Q: What's the difference between an Irish wedding and an Irish wake? A: One less drunk. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: I would like to post on lists.mysql.com
On Sat, Jan 30, 2010 at 01:49, Vikram A vikkiatb...@yahoo.in wrote: Dear Admin, I would like to share and get inputs from experts on MYSQL Db. I request you to grant access to me. You may not have noticed, but you're already posting to the list. All you have to do is subscribe and you have full access. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Looking for hosting or dedicated servers? Ask me how we can fit your budget! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: I would like to post on lists.mysql.com
Hi, if you did your subscription in any lists, you will automatically added to send and receive e-mails from professionals that are connected in it. See lists here: http://lists.mysql.com/ Wagner Bianchi 2010/1/30 Daniel Brown danbr...@php.net On Sat, Jan 30, 2010 at 01:49, Vikram A vikkiatb...@yahoo.in wrote: Dear Admin, I would like to share and get inputs from experts on MYSQL Db. I request you to grant access to me. You may not have noticed, but you're already posting to the list. All you have to do is subscribe and you have full access. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ Looking for hosting or dedicated servers? Ask me how we can fit your budget! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=wagnerbianch...@gmail.com
How to force Warning: #1048 Column cannot be null to Error
When I try insert NULL to VARCHAR NOT NULL column, It will shows a warning and convert NULL to '' then insert 。 I want to MySQL raise an exception when I try do that. How to do that? Thank you. Miao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: How to force Warning: #1048 Column cannot be null to Error
Take a look at SQL_MODE ;) Claudio On Jan 30, 2010 5:05 PM, Miao Jiang jiangfri...@gmail.com wrote: When I try insert NULL to VARCHAR NOT NULL column, It will shows a warning and convert NULL to '' then insert 。 I want to MySQL raise an exception when I try do that. How to do that? Thank you. Miao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: How to force Warning: #1048 Column cannot be null to Error
mysql SET sql_mode = TRADITIONAL; Query OK, 0 rows affected (0.02 sec) Then the insert query will fail and the row will not be added to the table...see you. Wagner Bianchi 2010/1/30 Claudio Nanni claudio.na...@gmail.com Take a look at SQL_MODE ;) Claudio On Jan 30, 2010 5:05 PM, Miao Jiang jiangfri...@gmail.com wrote: When I try insert NULL to VARCHAR NOT NULL column, It will shows a warning and convert NULL to '' then insert 。 I want to MySQL raise an exception when I try do that. How to do that? Thank you. Miao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: [MySQL] Re: Image Store @ My SQL
Vikram A wrote: Is it So? then i may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties. 1) NFS sharing a file (any file) is better suited for this task. 2) The DB should only hold the file path (pointing to the NFS share) Your comment above, what if the NFS share is unavailable, it will cause a problem. While this is true, the same can be said about your SQL server. What if it becomes unavailable? Point is, use the tools you have available for what they're best intended for. You can have 1 master server that is both your NFS as well as your MySQL server and that sits at one end of your intranet. Then you have the second machine, at the other end of the intranet, act as the MySQL slave and replicate everything from the master DB. As long as the paths stored in MySQL are pointing to the NFS path, everything should work fine. And if you don't want to run NFS, you can run rsync on the slave server and pull all the images from the master machine into the slave one. This will avoid images not being found if your master server goes down. There are many ways to skin this cat ... -- H | It's not a bug - it's an undocumented feature. + Ashley M. Kirchner mailto:ash...@pcraft.com . 303.442.6410 x130 IT Director / SysAdmin. 800.441.3873 x130 Photo Craft Imaging . 2901 55th Street http://www.pcraft.com . . .. Boulder, CO 80301, U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: [PHP] Good source for sample data?
At 3:08 PM -0800 1/29/10, Brian Dunning wrote: Thanks for the suggestions but I couldn't find any that suited my needs, so I made my own. Feel free to download if you can use them, I made files with up to a million unique records. Name, Company, Address, Phone, Email, etc., all are fake but are real addresses with correct area codes, zips, exchange, so will work for mapping, phone or address validation, whatever your needs are. Hope someone find it useful. http://www.briandunning.com/sample-data/ Brian: Thanks -- that was very nice of you. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org