Which database can safely use the GUID as the primary key besides SQL Server?

Question

The reason I want to use Guid is because when I need to partition the database, I will not have primary keys that overlap in both databases. Therefore, if I use Guid, there will be no overlap. I also want to use the GUID in the url, so Guid needs to be indexed.

I will use ASP.NET C # as my web server.

Answer 1

As others have said, you can use a GUID / UUID in almost any modern database. The GUID generation algorithm is pretty simple, and you can be pretty sure you won’t cheat, but there are some considerations.

+) Although the GUIDs are usually 128 bit values, the actual format used is different from implementation to implementation — you may want to normalize them by removing non-essential characters (usually dashes or spaces).

+) To ensure uniqueness, you can also add a value to guid. For example, if you are worried that MS and Oracle are facing conflicts, add “MS” to the former and “Or” to the latter — now, even if the guides themselves collide, their keys will not.

, , : (128 ) ( ).

( , ), , , .

, , - . , , :

1) , . , , , , . .

2) "" , ( ). , , (, ).

( ) .

- , - DB - , , . .

. , , ..

, , , , , a) b) ( , ). , " + ".

Answer 2

Postgres UUID. MySQL UUID. Oracle SYS_GUID.

Answer 3

RDBMS, , PK. , GUID CHAR (n) n, . , , , CHARs , .

, .

Answer 4

, GUID int128.

mySQL, postgres, , GUID ( , UUID, ).

Answer 5

, 3 + ints GUID UUID . ints/GUIDS/UUIDS , .

, , , .

, , , , GUID ( ) . , - .

Answer 6

, . , .

google " " .

Answer 7

SQLite. Guid .Net SQLite . .

, , , / / SQL Server.

Answer 8

, , MS SQL ASP.net, , , , Google :

MySQL

MySQL 2

SqlLite

Answer 9

If you are using other MS technologies already, you should consider Sql Server Express. http://www.microsoft.com/express/sql/default.aspx This is a real implementation of MS Sql Server, and it is free. This has significant limitations, as you can imagine, but if your product can fit inside those you get support from, the developer community and Sql Server stability and a clear upgrade path if you need to grow.