news.volyx.in

SQLite 3 Fiddle (sqlite.org)

765 points by sgbeal · 1571 days ago · 136 comments on HN

Article summary

SQLite has released a new web-based application called SQLite Fiddle, which allows users to run a modified version of the SQLite CLI shell in their browsers. The application is built using WebAssembly and provides a way to test and experiment with SQLite databases without the need for a server-side backend. The database is stored in memory by default, but users can also export and import databases using the Options toolbar. SQLite Fiddle is not an officially-supported deliverable of the SQLite project, but it is provided in the hope that it may be useful or interesting to users.

Main themes

  • SQLite Fiddle
  • WebAssembly
  • Database testing
  • Technical interviews
  • Code quality
  • IndexedDB
  • Persistence and storage
  • Emscripten and JavaScript binding

What commenters say

  • The SQLite Fiddle application is useful for technical interviews and quick demos, allowing candidates to showcase their skills in a realistic environment.
  • Pair programming in an interview is a valuable way to evaluate candidates, as it allows for a more realistic assessment of their skills and problem-solving abilities.
  • Some commenters argue that having candidates work on an assignment and submit it by a deadline is a better way to evaluate their skills, as it allows them to work independently and showcase their abilities without the pressure of an interview.
  • The use of SQLite Fiddle could potentially replace the need for IndexedDB in some applications, but it is not a direct replacement due to differences in persistence and storage.
  • The size of the SQLite Fiddle application is relatively small, with some commenters noting that it is comparable to the size of other web applications and libraries.
  • Some commenters express concerns about the quality and maintainability of the JavaScript code generated by Emscripten, and suggest that manual binding or alternative tools may be necessary to produce high-quality code.
  • The SQLite Fiddle application is seen as a useful tool for testing and experimenting with SQLite databases, and its release is viewed as a positive development by many commenters.
  • There are differing opinions on the best way to evaluate candidates in a technical interview, with some arguing for pair programming and others advocating for assignments or other approaches.