Comments (5)
We've used KSUIDs as primary keys in MySQL database, ether using their base62 representation or their binary format. The column type should be varbinary(27)
or varbinary(20)
depending on the approach you take. The advantage of using the base62 representation is it enables copy/pasting values when composing queries manually.
Let me know if that helps answer your question.
from ksuid.
It'll work just like indexing other byte sequences, a lexicographic comparison will work just fine with KSUID (in both base62 and binary representations).
I'm not aware of any MySQL function that generate a KSUID, we generate them client-side when constructing queries.
from ksuid.
Thanks for your prompt reply. And can you please explain me that how indexing for ksuid works in MySQL?
from ksuid.
Also one more question :
Is it possible to generate KSUID directly through MYSQL ?
like for example we have "SELECT UUID()" ?
from ksuid.
Thanks a lot
from ksuid.
Related Issues (20)
- Go's default random number generators are not safe for concurrent use? HOT 2
- cmd template should use text/template to avoid escaping HOT 1
- Wrong epoch date in README? HOT 3
- Is it possible to generate KSUID from SQL? HOT 2
- Min/Max KSUID private HOT 1
- [Request] Add Go mod support HOT 1
- KSUID from string? HOT 1
- KSUID is not nanosecond-aware HOT 1
- How do I convert from `string` to `ksuid.KSUID` format? HOT 1
- Passing a timestamp before the epoch to FromParts does not return an error
- What happens after 100 years? HOT 3
- What is the differences between Sync and Async? HOT 1
- Postgres extension written in rust to generate ksuid HOT 2
- [Question]: Could I pass my own payload to ksuid?
- [Question]: I know that is not possible to use more than 16 bit payload, but what's the reason?
- GUID comparison HOT 2
- KSUID order not predictable HOT 5
- Parse accepts argument containing non-alphanumeric characters HOT 1
- KSUIDs do not sort properly. HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ksuid.