473,320 Members | 1,695 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

GUIDs/uniqueidentifiers why not?

Hello,

I am trying to bring my entire organization from a Microsoft
platform to a Linux one, starting with all of the servers we are
currently running. Sun ONE ASP allows me to run ASP on Linux through
Apache, Mono is working on .NET, but the one thing I can't migrate is
SQL and it's because products like mySQL and Postgres have no built-in
GUID support. We have 100 databases with GUIDs as primary keys across
all of them. It works great in a Microsoft world, but as soon as you
want to go to Linux it seems like their is no way. I have seen a lot
of "hack" fixes, but it still escapes me why mySQL won't support this
kind of seemlingly great functionality.

In my case I have a universal history table that allows the
storage of all sorts of events in one table, it's great, everytime I
need to add a new one I add a new history type to a type table and
then just start throwing data in the table, later on I can look it
back up just fine. It works for everything I do. This really helps to
reduce my need to duplicate the same concept all over the place and
speeds programming since I don't have to worry about which table
contains what history. Now, the reason this uses GUIDs is I can key
into the table with a GUID for the history type. Then I can query the
"reference GUID", which is a generic column that only the specific
software that put it there understands, without ever having to worry
about software that doesn't know what something is trying to do
something with it. I would much rather the software error than try to
take an action that is not warranted by the value.

Any help understanding or with a solution to this problem would be
helpful, thanks.

Shaun
Jul 19 '05 #1
0 1344

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Jon Perez | last post by:
Is there a Python function that works on all platforms (not just Win32) to generate such in the DCE / Microsoft format? If not present, this looks like it would be a very Pythonic addition to...
0
by: Shaun Clark | last post by:
Hello, I am trying to bring my entire organization from a Microsoft platform to a Linux one, starting with all of the servers we are currently running. Sun ONE ASP allows me to run ASP on Linux...
8
by: Roland Hall | last post by:
Would a GUID be a good idea to use for a random generated account code. The user will be given a link to pass the GUID and then be prompted for a password. Ex....
4
by: J.Marsch | last post by:
I notice that when I generate various guids, they appear to have a mix of upper and lowercase letters. Is the uniqueness of a guid case-sensitive? In other words, if I generate a guid, and...
1
by: vector | last post by:
I've got an application that generates GUIDs. A lot of GUIDs. Lots of GUIDs that end up in files on disk, taking up space. I'd like to continue using the Guid.NewGuid() function as my unique tag...
1
by: Andrew S. Giles | last post by:
Hello, I am writing a COM interface to one of my classes, so that the interface bmay be used to provide a means of sending data from a legacy code application to the new .NET user Interface. ...
11
by: Jeff | last post by:
Hi - I'm experiencing a strange problem when comparing 2 guids. In my trial, they're not equal. When I step through the (VB.NET) code, they are evaluated as equal, and when I enter the...
2
by: Howard Kaikow | last post by:
Being lazy, I sometimes copy a project to another directory, then tweak the code. A problem arises because then both projects have identical GUIDs in the .sln file, and in the assembly file. ...
1
by: GHUM | last post by:
Hello, I created lots of guids via pywintypes.CreateGuid() on windows. Now I would like to run the same software on Linux / Solaris / FreeBSD. So I should produce "compatible" GUIDS on...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.