53 Matching Annotations
  1. Nov 2023
    1. Database transactions support a weak form of multi-version con-currency control by allowing an uncommitted transaction’s writesto be either committed or rolled back by aborting the transaction [8].However, most databases do not allow one user to share the state ofan uncommitted transaction with another user, and most databasesdo not allow the user to find out what data has changed in anuncommitted transaction (the equivalent of git diff). Moreover,in most database systems, an uncommitted transaction may holdlocks and thus prevent other transactions from making progress.

      I.e., DB-first approach does not have divergent view as first-class citizen.

  2. Oct 2023
    1. UUID Version 7 (UUIDv7) is a time-ordered UUID which encodes a Unix timestamp with millisecond precision in the most significant 48 bits. As with all UUID formats, 6 bits are used to indicate the UUID version and variant. The remaining 74 bits are randomly generated. As UUIDv7 is time-ordered, values generated are practically sequential and therefore eliminates the index locality problem.


      0 1 2 3 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 0 1 +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | unix_ts_ms | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | unix_ts_ms | ver | rand_a | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ |var| rand_b | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ | rand_b | +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+

  3. Sep 2023
    1. 你一定希望在校对过程中,即使有用户发生了一笔新的交易,也不影响你的校对结果。
  4. Aug 2023
  5. Jul 2023
  6. Jun 2023
  7. Jan 2023
    1. ```js const TOKEN = "YOUR_PERSONAL_ACCESS_TOKEN"; const GIST_ID = "YOUR_GIST_ID"; const GIST_FILENAME = "db.json";

      / * Reads the JSON file inside of the gist / async function getData() { const req = await fetch(https://api.github.com/gists/${GIST_ID}); const gist = await req.json(); return JSON.parse(gist.files[GIST_FILENAME].content); }

      / * Puts the data you want to store back into the gist / async function setData(data) { const req = await fetch(https://api.github.com/gists/${GIST_ID}, { method: "PATCH", headers: { Authorization: Bearer ${TOKEN}, }, body: JSON.stringify({ files: { [GIST_FILENAME]: { content: JSON.stringify(data), }, }, }), });

      return req.json(); } ```

  8. Oct 2022
  9. Aug 2022
  10. Jul 2022
    1. Scalability: Cosmos DB is horizontally scalable to support hundreds of millions of reads and writes per second

      Since it is a Platform as a Service, it isolates the configuration required to perform scaling from the users, allowing them to focus on their data manipulation.

    2. replicated

      so they said replicated, not fragmented.

  11. Feb 2022
  12. Dec 2021
  13. Aug 2021
  14. Feb 2021
  15. Nov 2020
    1. A Wikipedia kifogása az iTA szócikkel kapcsolatban

      Mint Wikipedia szerkesztésért "felelős" jelzem: ne törődj ezzel! Nem számít túlzottan, ha majd az "supervisor"-ok mégis jeleznek (amit nekem fognak), teszek valamit. A tag törölhető - szerintem.

  16. May 2020
    1. <div class="templates:surround?with=templates/page.html&amp;at=content"> <h1>Table of Contents</h1> <div data-template="app:toc"/> </div>

      This seems to combine two different ways of HTML templating:

      • class
      • data-tag

      Should it be done in this way?

    1. Collections tile which will open the Collection Browser. Navigate to the application root directory /db/apps/thun-demo, click on the New Collection icon, enter pages as name and click ok.

      This seems to be outdated. AFAIK, the way now is to use DB Manager in eXide.

    1. Using AWS SCT to convert objects (tables, indexes, constraints, functions, and so on) from the source commercial engine to the open-source engine. Using AWS DMS to move data into the appropriate converted objects and keep the target database in complete sync with the source. Doing this takes care of the production workload while the migration is ongoing.

      DMS vs SCT

      data migration service vs schema conversion tool

      DMS source and target db are the same

    1. By default, Amazon Redshift has excellent tools to back up your cluster via snapshot to Amazon Simple Storage Service (Amazon S3). These snapshots can be restored in any AZ in that region or transferred automatically to other regions for disaster recovery. Amazon Redshift can even prioritize data being restored from Amazon S3 based on the queries running against a cluster that is still being restored.

      Redshift is single az

  17. Apr 2020
    1. RPO limits how far to roll back in time, and defines the maximum allowable amount of lost data measured in time from a failure occurrence to the last valid backup. RTO is related to downtime and represents how long it takes to restore from the incident until normal operations are available to users

      RPO RTO

    1. While SimpleDB has scaling limitations, it may be a good fit for smaller workloads that require query flexibility. Amazon SimpleDB automatically indexes all item attributes and thus supports query flexibility at the cost of performance and scale.

      Simple DB vs DynamoDB

  18. Nov 2019
    1. I wonder, what else do we need files for?

      interestingly with it's then new mobile devices that's what apple thought! they came to this from ui / "sales" perspective though

  19. Nov 2018
  20. Oct 2018
  21. Sep 2018
  22. Sep 2016
  23. Feb 2016