To make your first application robust, consider adding these elements:
Instead of building a query string with variables directly, you use placeholders (like ? ). This is essential for preventing , a common security vulnerability where users can manipulate your database through input fields.
: Add indexes to columns that you search or join frequently to speed up retrieval times. moja_prva_aplikacija.sql
: If your application runs the same query multiple times with different data, the database only has to "compile" the query once, making it faster. Other Recommended Features
For a project named moja_prva_aplikacija.sql (which translates to "my first application"), a "good feature" involves moving beyond simple data storage toward security and efficiency. To make your first application robust, consider adding
: Instead of using SELECT * , only request the specific columns you need. Always include a WHERE clause to avoid loading massive amounts of unnecessary data.
: If you are using stored procedures, look into commands like SET XACT_ABORT ON (in SQL Server) to automatically roll back changes if an error occurs. : Add indexes to columns that you search
: Use Primary Keys to uniquely identify records and Foreign Keys to create relationships between tables (e.g., connecting a Users table to an Orders table).