1/7/2023 0 Comments Openoffice base export sqliteSQlite does not give you anywhere near the data types that PostgreSQL does, but it has the basics and from the sounds of it will be enough to get you going. It is also very easy to move up from SQlite to the more serious DB (PostgreSQL) when you're more comfortable with DBs, and tbh setting up PostgreSQL in ubuntu is very simple (and free). From the first tests, it seems that does not return certain values necessary for the correct management of the schema and tables in Base. it's a curse because single file slower access, poor concurrency. Hi all, Im trying to integrate the SQLite JDBC driver into my jdbcDriverOOo extension which normally allows any JDBC driver to work in LibreOffice / OpenOffice Base. A blessing in that you can just grab a copy of that file, replace it with past copies and in that respect is very simple and intuitive. It's a good my-first-database tool and for simple stuff it's fine and the database is just a single file (both a blessing and curse). doesnt support common import/export)įor development and testing of something simple (ie just single user access to the DB) I would suggest SQlite. Something along the lines of RazorSQL (is trialware), SQLite (no GUI, requires programming), or sqlite Expert (free vers. I found three or four likely candidates, but either they were trial versions, or they didnt import/export, or they were cmd line Small learning curve (I have NO database or programming experience) Prefer something that worx in both *buntu & Windoze (but if one or the other, would need to be Win) Must be able to import/export CSV and or. No internet or server functionality (will only be using it on a couple home computers) No db managing, administration, development, or programming functions necessary Simple database creating and editing (GUI preferred - no cmd line) Which there seems to be a serious lack of. I guess the issue is I need something SIMPLE and FREE. Pretty mind boggling for someone who has NO experience with databases. I've Googled for several hours, and Holy Cow!. So, I'm in need of a very simple database program, and wanted to ask if anyone who had experience could help me choose one.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |