4 ms·

You still need to test against a live database instance right?

• ramraj07 6y ago
  Sometimes yes, sometimes no! If the sql you're using is testable syntactically in sqlite itself, then your tests can be very light and done on a in memory sqlite database. The standardization of a dataframe like object allows me to infer the schema going into and out of a method and automatically create and tear down the expected tables! However sometimes you use custom SQL for your specific dialect so the test has to happen on that database. But you can still write some isolation wrappers to run them on a development db. They probably won't run in a second so you might have to keep them in a separate pipeline or something