I want to get a list of column names from a table in a database. Using pragma I get a list of tuples with a lot of unneeded information. Is there a way to get only the column names? So I might end up with something like this:
I must be missing something trivial with SQLAlchemy’s cascade options because I cannot get a simple cascade delete to operate correctly — if a parent element is a deleted, the children persist, with null foreign keys.
I have to label something in a “strong monotone increasing” fashion. Be it Invoice Numbers, shipping label numbers or the like.
I’m using django with apache and mod_wsgi and PostgreSQL (all on same host), and I need to handle a lot of simple dynamic page requests (hundreds per second). I faced with problem that the bottleneck is that a django don’t have persistent database connection and reconnects on each requests (that takes near 5ms).
While doing a benchmark I got that with persistent connection I can handle near 500 r/s while without I get only 50 r/s.
Why is :memory: in sqlite so slow? I’ve been trying to see if there are any performance improvements gained by using in-memory sqlite vs. disk based sqlite. Basically I’d like to trade startup time and memory to get extremely rapid queries which do not hit disk during the course of the application. However, the following … Read more
I have a file that’s growing about 200,000 lines a day, and it is all formed with blocks of three lines as such:
I have a custom product catalog database, and I want to migrate it to WordPress.
are there any tools for that? or I have to do it manually.
I have a question about add_post_meta and update_post_meta.
I’m trying to select rows that fall into a certain date range from my database table. The range is determined dynamically by the user. In my database I have a column called “dateAndTime”. It has dates stored into it in this format: 2021-06-01 19:37:00 I’m trying to select the rows with this: function getEventsByDateRange(){ $eventType … Read more
I need a solution to do this with WP. In admin: I need to input data into database (name, surname, certification, level, date of issue). In Frontend: client can use a specific search field to search within the inserted data and get a table with the results. (name, surname, certification, level, date of issue). Any … Read more