SQL Arena

Cookies Policy

Which cookies and storage technologies SQL Arena uses, and how to manage them

Last updated: May 12, 2026

1. What are cookies

Cookies are small text files that a website stores in the User's browser during a visit. They allow the site to remember the User's actions and preferences over time.

This Policy describes which cookies and similar technologies (localStorage, sessionStorage) the site https://sql.coderang.dev uses, for what purpose, and how the User can manage them.

2. Categories of cookies we use

Strictly necessary (the Service cannot function without these; no consent required):

  • "access_token", "refresh_token" — httpOnly authentication cookies. Lifetime: access — 15 minutes, refresh — 7 days.
  • "is_logged_in" — authenticated-state flag for the UI. Lifetime: 7 days.

Functional (store user preferences):

  • "lang" (localStorage) — selected interface language (ru/en).
  • "theme" (localStorage) — colour theme (light/dark).
  • "sqlarena_tabs_*", "sqlarena_favorites", "sqlarena_editor_config" (localStorage/sessionStorage) — SQL drafts, favourite tasks, editor settings.
  • "sqlarena_cookie_consent" — record of the User's choice regarding cookies.

Analytics and performance measurement (optional, only with consent):

  • The Service currently does not use third-party analytics cookies. If such cookies are added, this section will be updated and the User will be asked to choose.

3. Managing cookies

On the first visit to the Service, a notice is shown with two choices: "Accept all" or "Necessary only". The choice is stored and can be reset by clearing cookies and reloading the page.

The User may delete stored cookies at any time via browser settings. Note that removing strictly necessary cookies will prevent the use of authenticated features of the Service.

Instructions for popular browsers:

  • Google Chrome: Settings → Privacy and security → Cookies.
  • Mozilla Firefox: Settings → Privacy & Security → Cookies and Site Data.
  • Safari: Settings → Privacy.
  • Yandex Browser: Settings → Tools → Clear browsing data.

4. Third-party cookies

When signing in via Google, GitHub, or Yandex, the respective OAuth provider may set their own cookies. Those are governed by the providers' own privacy policies. The Service has no access to that data.

When making a payment on the YooKassa page, the payment service sets its own cookies needed to process the transaction. See YooKassa's own policy for details.

5. Contacts

For questions about cookies, please contact coderang.dev@gmail.com.