Bean works to JOB1 from May/15 to May/20) I have to store one record for each day of the range (6 record in this case) or use only one record with both dates in 2 fields of the same record? Well, in the case of ranges of days (for example Mr. Then i have to query the database for a certain day so to know who is working to a certain job in a specific day. I have to store information of this kind:Ī person is assigned to a job for a certain day (one day only)Ī person is assigned to a job from a day to another day (a range of days) If is a better choice to stored separately year, month and day into 3 separate fields or use one field for a complete date-time group? Supports SQLite extensions and third-party SQLite libraries.I ask for generic advice on what field format is best to use to store dates in a database (SQLite). Copy tables between SQLite databases using drag and drop operations. Export data to CSV files, SQL script, Excel or SQLite.

Import data from ADO data source, CSV files, SQL script or SQLite. Any restructure operation is wrapped in a nested transaction which is rolled back if any errors occur when applying changes. Restructure any complex table without losing data. Visual editors for table columns, indexes, foreign keys, triggers, unique and check constraints. Visualize and modify BLOB fields using the integrated Hex editor. Image editor currently supporting JPEG, PNG, BMP, GIF and ICO image formats. Edit data in the grid using powerful in-place editors. Advanced SQL editor with syntax highlighting and code completion.

Powerful means of SQL query parsing and analysis. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities. It is a feature rich administration and development tool for SQLite designed to answer the needs of all users from writing simple SQL queries to developing complex databases.The graphical interface supports all SQLite features. QLite Expert is a powerful tool designed to simplify the development of SQLite3 databases.

Sqlite expert professional portable